Visual Builder

Get Involved. Join the Conversation.

Posts

  • Raghu Rajagopalan
    Table Component to Sync with Business Object Changes25.0
    Topic posted May 16, 2018 by Raghu RajagopalanRed Ribbon: 250+ Points, tagged Business Objects 
    Title:
    Table Component to Sync with Business Object Changes
    Summary:
    Table Component to Sync with Business Object Changes
    Content:

    Created the APP with Table Component Based on  Business Object. Had 5  Columns Selected for the List Page.  And App Ran fine. Added a new Column to Business Object. Wanted this to be included in same Table Component. so  Selected Table Component added a Empty Column and associated with Business Object Through Properties (Found that it matches other field definition for the Table COmponent) The Column does not display any value even though I have populated . Have I missed any steps. Please advise

  • Raghu Rajagopalan
    Created a Page and Added a Table COmponent Related to...65.0
    Topic posted May 13, 2018 by Raghu RajagopalanRed Ribbon: 250+ Points, tagged Business Objects, Composite Component 
    Title:
    Created a Page and Added a Table COmponent Related to Business Object. Added a Custom Button to voke a Rest API. Rest API Parameter needs to be mapped to COlumn on Selectred Row from Table COmponent. How do I refer Table Components COlumn on Selected Row
    Summary:
    Created a Page and Added a Table COmponent Related to Business Object. Added a Custom Button to voke a Rest API. Rest API Parameter needs to be mapped to COlumn on Selectred Row from Table COmponent
    Content:

    I created a Page and Added a Table Region, Creatre Page and Edit Page.

     

    Added a Custom Button on Main Page.

     

    Custom Button has to call a Rest API and the Parameter for Rest API needs to be Mapped to Column on Selected Row .

     

    Not sure How I can refer column on Table Region.

     

    {{ $page.variables.oj_table_1651387367_2SelectedId.keyID }}

     

    Can some one Advise.

     

    Thanks


    Raghu

  • Abhijeet Khanapure
    Update business object on button action85.0
    Topic posted April 26, 2018 by Abhijeet KhanapureBlue Ribbon: 750+ Points, tagged Business Objects 
    Title:
    Update business object on button action
    Summary:
    Update business object on button action
    Content:

    Hi,

     

    Need inputs on how to get handle of the business object  in custom code

     

    My requirement is,

    1) On button click read value from the business object

    2) Update that value for that field

     

    Code used in custom code for button -

     

    /**************************************/

    alert($COntactQueryListArchetypeRecord.getValue('conNUmber'));

    resolve();

     

    /******************************/

     

    Getting error

    Error: Cannot read property 'getValue' of undefined

     

    Thanks,

    Abhi

  • Abhishek Vashishtha
    Update operation on BO fails15.0
    Topic posted April 11, 2018 by Abhishek VashishthaGreen Ribbon: 100+ Points, tagged Business Objects 
    Title:
    Update operation on BO fails
    Summary:
    Update operation on BO fails
    Content:

    Hey,

     

    I'm trying to perform an update operation on the data of a Business Object. But it fails.

     

    Can anyone please help with  this?

     

    require([

        'operation/js/api/Conditions',

        'operation/js/api/Operator'

    ], function(Conditions, Operator) {

        var so = Abcs.Entities().findById('SearchAccount');

        var SendFlag = so.getProperty('sendToEloqua');

        //var condition = Conditions.SIMPLE(SendFlag, Operator.EQUALS,'Y');

        var operation = Abcs.Operations().update({

      entity: so,      

      record: {

       sendToEloqua: 'N'     

      }

    });

       operation.perform().then(function(operationResult) {         

      if (operationResult.isSuccess()) { 

       alert("Updating Contact");

       operationResult.getData().forEach(function(oneRecord) {

      

        resolve("ok");

       });

            }

     

    }).

      catch(function(operationResult) {

            if (operationResult.isFailure()) {

                // Insert code you want to perform if fetching of records failed

            }

        });

    });

  • Abhishek Vashishtha
    Unable to see business object data (after adding a few...4
    Topic posted April 11, 2018 by Abhishek VashishthaGreen Ribbon: 100+ Points, tagged Business Objects 
    Title:
    Unable to see business object data (after adding a few records)in the live mode
    Summary:
    Unable to see business object data (after adding a few records)in the live mode
    Content:

    Hey,

     

    The ask is, that new records should be created from the user entered values at the UI. And at the same time, the newly created records should be visible at the UI in a table.

     

    So, I managed to push new records into the BO using custom code. But the records do not show up at the table at the same time, though they are visible in the data designer -> business Object-> MyBO-> data.

     

    However, if I refresh the page, by navigating to business object and then coming back to page, the new records are shown up.

     

    Can anyone pls suggest what extra needs to be done to make the new records to show up at the same time when they are pushed into BO?

     

    Thank you so much!

     

    Below is the code for creating the records in BO.

    var so = Abcs.Entities().findById('SearchAccount');

    var operation = Abcs.Operations().create({
                  entity: so,
                  record: {
                   emailAddress:'abc@xyz.com',
                   firstName: 'Abc',
                   lastName: 'def',
                   sendToEloqua:'Y'
                  
                  }
                 });

                 operation.perform().then(function(operationResult) {
                  if (operationResult.isSuccess()) {
                  
                   resolve("ok");
                  }
                 }).catch(function(operationResult) {
                  if (operationResult.isFailure()) {
                   alert('Could not insert the Contact Records in BO');
                   reject("error");
                  }
                 });

  • Sherwood Daniels
    Display reference or combo box in table15.0
    Topic posted March 6, 2018 by Sherwood Daniels, tagged Business Objects, Custom Code, Database, REST 
    Title:
    Display reference or combo box in table
    Summary:
    Display reference or combo box in table
    Content:

    I am developing a VBCS app where the data comes from a DBaaS instance. I access this data via REST API. Not sure if this is relevant but thought I'd mention it.

     

    I have tables that reference foreign keys. The foreign key is a sequence number generated by the database. Obviously the users would rather see business values than these sequence numbers. I have created References that provide user-friendly values for the foreign keys. On detail pages I can use a list box to display the user-friendly values.

     

    Is there a similar strategy that I can use for tables? I don't see a way to define which control is used to display a data field in a table. Dragging-and-dropping any of the controls from the palette is being rejected for tables.

     

    Attached is a pic of representative page. The Group and Mapping columns are pointed to the references. In Development mode they show up as blanks.

     

    Thanks in advance for your help.

  • Varun Anne
    How link between ADD page and Search page15.0
    Topic posted February 16, 2018 by Varun AnneGreen Ribbon: 100+ Points, tagged Business Objects 
    Title:
    How link between ADD page and Search page
    Summary:
    How link between ADD page and Search page
    Content:

    I am trying to add two tabs in which one will be for Search data i.e we can only edit the data as below screen.

    pastedImage_0.png

     

    I have other page as Add in which i have added one row of data and in this we can just add the data i.e create only works. Below is the screen shot. for this i have created two Business objects one is and can you please provide me how to connect that two business objects to display the data in search page.

    pastedImage_1.png

     

    My final requirement is how we can connect data in add page to search page. i am not able to link two pages

     

    Thanks&Regards

    Varun

  • paryul mehta
    Custom BOP issue while getting data from Database as a...25.0
    Topic posted February 13, 2018 by paryul mehtaBlue Ribbon: 750+ Points, tagged Business Objects, Custom Code, Database 
    Title:
    Custom BOP issue while getting data from Database as a Schema Service
    Summary:
    Custom BOP issue while getting data from Database as a Schema Service
    Content:

    Hello we  have the following tools to work with.

    1: Database as a Schema service

    2: Visual Builder Cloud service

    We're trying to do the following.

    Deploy a restful webservice created by the wizard available in APEX , deploy it , consume that as a business object in Oracle Visual Builder Cloud service.

    So we can build an app around this object. In an older post it was explained to me that for these restful webservices created in apex (ORDS) we need to create a Business Object Providers to consume

    such services. I've attached the code that we edited based on the link provided before as a reference point https://blogs.oracle.com/shay/getting-data-from-rest-services-into-oracle-application-builder-cloud-service

    We can see that the webservice is called but no data is showing up in the Visual builder cloud service. We can get the data when we call the webservice in our browser and in apps such as SOAPUI etc.

    I've attached some screenshots and also the sample code files. Can you help?

    Have a sample table test_state

    pastedImage_0.png

    we've deployed this table as a rest service from the Database as a schema service Apex console.

     

    pastedImage_1.png

     

    pastedImage_2.png

     

    pastedImage_10.png

     

    pastedImage_3.png

     

     

    pastedImage_4.png

     

    pastedImage_5.png

     

    We tried accessing the data using the steps shown below but it doesn't bring up anything.

     

    pastedImage_6.png

     

    pastedImage_7.png

     

    pastedImage_8.png

     

    pastedImage_9.png

  • Varun Anne
    How to create new BOP15.0
    Topic posted February 8, 2018 by Varun AnneGreen Ribbon: 100+ Points, tagged Business Objects 
    Title:
    How to create new BOP
    Summary:
    How to create new BOP
    Content:

    How to create new BOP with FSCM Fusion rest service and both Fusion SAAS and VBCS are not present in same domian.

     

    Is it in the same way as creating new service extension using rest service. i.e by providing fusion Userid and password when we create service with Fusion rest service

  • Pramod Vasudeva Murthy
    Custom objects fields in ABCS forms65.0
    Topic posted February 7, 2018 by Pramod Vasudeva MurthyBlack Diamond: 60,000+ Points, tagged Business Objects, Custom Code 
    Title:
    Custom objects fields in ABCS forms
    Summary:
    Custom objects fields in ABCS forms
    Content:

    Hi Gurus,

     

    I am exploring Oracle Engagement Cloud and it has a self-service portal for end customers(B2C) which is called Digital Customer Service(DCS). It is built ABCS framework.

     

    We have the abilities to expose Standard business objects in the forms.

     

    Wondering if there are abilities to embed Custom object fields on the form while raising SRs? or is it Customisable?

     

    Please let me know.

     

    Oracle Engagement Cloud: 13C

     

    Thanks in advance,

    Pramod V