Visual Builder

Get Involved. Join the Conversation.

Posts

  • Stephen Bryant
    Business Object Function - return array with multiple...1
    Topic posted 3:17 PM by Stephen BryantBronze Trophy: 5,000+ Points, tagged Action Flows, Business Objects, Custom Code, Groovy, REST, SaaS Integration 
    Title:
    Business Object Function - return array with multiple records
    Summary:
    Business Object Function - return array with multiple records to pass to web service
    Content:

    Hello,

    I have BO called, TrxHdrs, with multiple records.  I know I can create a BO Object Function to iterate over those records.

    What I would like to do is write records that, for example, have a Status of, "available", to an array.  I want to write the entire record where the criterion is met.  Then I would like to pass the result (with multiple rows) to a web service (integration cloud) that sends it to ERP Cloud.  The only thing I need help with is how to create an array with multiple records in groovy.  The array will be structured to match what is expected by the web service.

    I am thinking each record would be a list with key-value pairs and many records would be contained within a "parent array". That would be the result to pass to the web service.

    In VBCS, I am able to iterate over and ADP and pass a single result to the web service successfully.  I am looking to do the same thing but get the data from the BO. 

    Any help is appreciated.

    Steve    

    Version:
    19.3.1.2
  • Kalpesh Darji
    Oracle commerce cloud integration with Oracle VBCS1
    Topic posted November 11, 2019 by Kalpesh DarjiGreen Ribbon: 100+ Points, tagged REST, SaaS Integration 
    Title:
    Oracle commerce cloud integration with Oracle VBCS
    Summary:
    Oracle commerce cloud integration with Oracle VBCS
    Content:

    Hi All,

    Currently i am integrating oracle commerce cloud(OCC) with VBCS via Oracle Integration cloud connector, which gives access to business objects.

    Is it possible to directly access OCC business objects from VBCS via "Service Specification" in VBCS? 

  • vijay.kekane
    Display name instead of ID on main-start page1
    Topic posted November 1, 2019 by vijay.kekane Green Ribbon: 100+ Points, tagged Business Objects, JET, REST, UI 
    Title:
    Display name instead of ID on main-start page
    Summary:
    Display name instead of ID
    Content:

    Hi There,

    I have application with 3 pages, Main-Start, Main-Create, Main-Edit. Main-start is first page displayed when application is run. Data is created/saved using create page. Field "ledger" is shown on both pages. We use LOV for it, which show name but, store ID in VBCS BO.

    When application run it shows list of rows in main page (image of start-main is attached) using VBCS BO, We want to display name of ledger instead of ID.

    I am not sure which page level event will allow me to scan through each record to find name based on ID (using REST) and display name on Main-Start page.

    Thanks,

    Vijay

     

    Version:
    19.3.1.2
    Image:
  • Mohammed Baig
    Best approach to expose custom database...Answered4
    Topic posted October 31, 2019 by Mohammed Baig, tagged Custom Code, Database, REST, Tip 
    Title:
    Best approach to expose custom database objects/functionality as Rest service, to consume in VBCS
    Summary:
    Best approach to expose custom database objects/functionality as Rest service, to consume in VBCS
    Content:


    Experts,

    We need your help in identifying the best option to expose the custom database objects or custom functionality as a Rest service which can be consumed in VBCS application.

    1. ADF BC Rest - We don't have JCS at moment but if its best option we can get back to customer.
    2. OIC Integrations as Rest - Already subscribed along with VBCS
    3. ORDS - We have custom database of size 15gb 

    FYI, we have already developed an application which is in production now, where we used Oracle JET and ADB BC combination for another customer.

    For this new customer, we have adapted the VBCS and looking for best option to expose Rest services for custom db objects/functionality. 

    Appreciate your response with cons and pros for each of the above approaches Or any other approach apart from the above three. We don't have any skill set limitations.

    Thank you

  • Kalpesh Darji
    When passing json response as input parameter >...
    Topic posted October 31, 2019 by Kalpesh DarjiGreen Ribbon: 100+ Points, tagged Action Flows, REST 
    Title:
    When passing json response as input parameter > DataCloneError: Failed to execute 'replaceState' on 'History': Headers object could not be cloned.
    Summary:
    When passing json response as input parameter > DataCloneError: Failed to execute 'replaceState' on 'History': Headers object could not be cloned.
    Content:

    Hi All,

    After entering value in input text box which is in SHELL page, i do a rest service call. In response i receive Json which i pass as a input parameter to another flow. while doing this I get following error and new page is not displayed. Any idea how to resolve this?

    log.js:22 [VB (ERROR), /oj]: DataCloneError: Failed to execute 'replaceState' on 'History': Headers object could not be cloned.

     

  • Prudhvi Varma
    Invoking URL from SSO enabled application by entering the...3
    Topic posted October 30, 2019 by Prudhvi VarmaGreen Ribbon: 100+ Points, tagged REST 
    Title:
    Invoking URL from SSO enabled application by entering the value in text box in VBCS application
    Summary:
    Invoking URL from SSO enabled application by entering the value in text box in VBCS application
    Content:

    Hi,

    We built an application in VBCS and integrated with other applications.

    Now our requirement is to invoke a URL from the integrated application based on the input field in the text box in visual builder application dynamically.

    Any help in regarding this ?

     

    Thank You,
    Prudhvi

  • Sumana Bhattacharjee
    Improper filtering of adp by rest call6
    Topic posted October 30, 2019 by Sumana BhattacharjeeGreen Ribbon: 100+ Points, tagged REST, UI 
    Title:
    Improper filtering of adp by rest call
    Summary:
    I could find a strange issue if we are trying to filter an adp. In my case I am using a button to create a new search row at index 0 but in case there is same value at row 1 the adp isn't assgning.
    Content:

    I need to filter an adp based on the inputs selected/ provided on the first row. When I am selecting a select one value it is not assigning the filtered result back to the adp whenever the second row is having the same value entered in the search row/ row with index 0 and is stopping any other action. Has anyone faced this? What could be the possible solution for this abrupt behaviour?

    Version:
    19.3.1.3
    Image:
    Document:
    vbcs8.png (35KB)
    Document:
    vbcs10.png (22KB)
    Document:
    vbcs11.png (29KB)
  • Mohammed Kaja Nawaz L J
    Login and Logout fusion application from VBCS1
    Topic posted October 28, 2019 by Mohammed Kaja Nawaz L JBlue Ribbon: 750+ Points, tagged REST, SaaS Integration, Security, UI 
    Title:
    Login and Logout fusion application from VBCS
    Content:

    Looking for way to login and logout fusion application from VBCS screen by entering username and password of fusion application in VBCS.

  • Kalpesh Darji
    Custom login page in VBCS and query business object using...Answered2
    Topic posted October 25, 2019 by Kalpesh DarjiGreen Ribbon: 100+ Points, tagged Business Objects, REST, Services 
    Title:
    Custom login page in VBCS and query business object using REST API
    Summary:
    Custom login page in VBCS and query business object using REST API
    Content:

    Hi Shay,

    I would like to create custom login page with username and password in database. How can we proceed further? Can we use business function to achieve this or below link is the option to go?

    https://blogs.oracle.com/shay/conditional-navigation-based-on-queries-in-oracle-visual-builder-cloud-service

    Another question: How can we pass query parameter other than id in Rest endpoint of business objects? Is the ID as query parameter is limitation?

     

  • vijay.kekane
    Patch to custom Object created in SaaS failAnswered85.0
    Topic posted October 23, 2019 by vijay.kekane Green Ribbon: 100+ Points, tagged Business Objects, Custom Code, REST, SaaS Integration 
    Title:
    Patch to custom Object created in SaaS fail
    Summary:
    Patch operation fail
    Content:

    Hi There,

    We have custom object created in financial cloud. This object's row need to be updated when data changes in VBCS screen. I am getting error "[VB (ERROR), /vb/helpers/rest]: The response specifies content type application/json, but unable to parse response as JSON. Reading response as text SyntaxError: Unexpected token I in JSON at position 0".

    Patch operation work good from postman so patch is allowed and I have valid response. Same patch operation also work when setting up REST endpoint in VBCS. However it does not work when update screen is used to update actual row.

    I have created new data Type based on REST endpoint to get response from REST operation. I am not sure reason for above error.

    Version:
    19.3.1.2
    Code Snippet: