Visual Builder

Get Involved. Join the Conversation.

Posts

  • Mark Chappell
    How to read from 2 Business Object in 1 Action Chain18
    Topic posted June 22, 2019 by Mark ChappellBronze Medal: 1,250+ Points, tagged Action Flows, Business Objects, REST, SaaS Integration 
    Title:
    How to read from 2 Business Object in 1 Action Chain
    Summary:
    How to read from 2 Business Object (parent and child) in 1 Action Chain and contruct a single payload?
    Content:

    Hi OVBCS Guru’s

    I need some help with my OVBCS Application. I am a novice with OVBCS, and I am sure my question is a simple enough task / standard design pattern for the more experienced OVBCS practitioners out there ?? How can I construct a single payload (i.e. variable) from 2 business objects (parent and child), within the same action chain, so I can then call an external REST API passing the parent child payload to it?

    I have built a simple Sales Order application, with 1 Sales Order header and 1 Sales Order Lines table. These are based on separate Header and Lines Business Objects. I’ve created a relationship between them and have functionality to restrict the line records based on the header record selected.  I have a button within the header record table, which when pressed, gets the header record via the BO REST Endpoint, and populates a variable I’ve created. 

    This variable is based on a Service Connection I’ve created, which is based on an external REST API I want to call. This is an OICS Integration I’ve built. I can assign the data from my Header Table into my variable, and then call my Integration via an Action Chain triggered on the Button press, all good so far.

    However, my problem is, I need to also obtain the Line data on my button press action. I have attempted to update my Action Chain, to first call the REST Endpoint of the Header BO, passing to it the current action chain key value. I am then assigning the returned values to my variable. 

    My intention was then to call the REST Endpoint for my child BO and then have another Assign action to map, all of the Lines returned, to the Line Array in the same variable as above… Is this the correct approach?

    If so, how to I call the Lines BO REST Endpoint, to return only those lines associated with the Header record? As the REST Endpoints are by default taking the BO ID value? I’ve attached my VB APP, and Word Doc with additional screen shots. 

    Any help with this will be greatly appreciated.

    Thank you

    Mark.

    Document:
  • Cesar Tepetla Corte
    Security when embedding a Visual Builder application in...15
    Topic posted November 27, 2018 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Groovy, SaaS Integration, Security, Services, Stage / Publish / DevOps, UI, Validation, Web 
    Title:
    Security when embedding a Visual Builder application in Oracle Fusion page integrator
    Summary:
    Security when embedding a Visual Builder application in Oracle Fusion page integrator
    Content:

    Hi

    I have embedded an application of Autonomous Visual Builder with page integrator in Oracle Fusion the problem is that I have to log in to Visual Builder to view the page in Fusion otherwise nothing will be shown.

    In what way can I avoid this? What I'm looking for is for the user to log in only on Fusion and see the application.

    Any comments and guidance is grateful.

    Thanks

  • Stephen Bryant
    Posting VBCS Screen (header and lines) to REST...14
    Topic posted July 12, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Action Flows, Business Objects, REST, SaaS Integration, UI 
    Title:
    Posting VBCS Screen (header and lines) to REST Service in ICS (upload to FTP)
    Summary:
    One Header Record, Many Lines
    Content:

    Hello,

    I have a VBCS screen composed of a Header section and a Lines Section.  The header section is tied to a BO while the lines section is based on an ADP.  There will always be one header record to many Lines records.

    I've created an integration in ICS to upload the screen data to two files on an FTP Server where the files will be picked up and processed via FBDI.

    The payload is collected in a vbcs variable based on a variable type tied to the ICS REST endpoint.

    It all works as long as I have one header (no problem) and one line.  It does not work if I have many lines as it simply just adds the first line.  The REST Service does not seem to take the array or recognize that item[i] is an array in the payload.

    I have correctly mapped the Lines Array to the endpoint via the variable created based on the endpoint.

    Headers works fine but I cannot get multiple lines generated.

    Also, I've tested the endpoint in VBCS on the services page with the JSON and that works fine posting multiple lines for each header.  So I am at a loss as to why the array is not recognized.  This is a POST action but to ICS to create the two files.  The service does not error due to content type but works regardless of how many lines I have by creating only one line.  Please advise.

    Am I missing anything?

     

    here is the JSON that works when testing directly from VBCS in the Services Page for the app:

    {  
       "hdrItems":  
          {  
             "docNumber":"123456",
             "fromDocNumber":"123456",
             "budgetLevelId":"1",
             "treasurySymbol":"000-00-0000",
             "fundValue":"0000",
             "publicLawCode":"001-001",
             "transactionDate":"2019-04-24",
             "docTotal":"123456789",
             "fahEvent":"APPROP",
             "hdrDescription":"abcdefg"
          },

       "lineItems":[  
          {  
             "lineDocNum":"123456",
             "glDate":"2019-04-24",
             "glAccountString":"000000000",
             "segment1":"0000",
             "segment2":"000000.00",
             "segment3":"000000",
             "segment4":"0000",
             "segment5":"000000",
             "segment6":"2019",
             "segment7":"000",
             "transactionType":"Appropriation",
             "lineAmount":"123456789",
             "lineDescription":"abcdefg",
             "lineNum":"1",
             "id":"123456",
             "headerId":"123456"
          },

         {  
             "lineDocNum":"123456",
             "glDate":"2019-04-24",
             "glAccountString":"000000000",
             "segment1":"0000",
             "segment2":"000000.00",
             "segment3":"000000",
             "segment4":"0000",
             "segment5":"000000",
             "segment6":"2019",
             "segment7":"000",
             "transactionType":"Appropriation",
             "lineAmount":"123456789",
             "lineDescription":"abcdefg",
             "lineNum":"2",
             "id":"123456",
             "headerId":"123456"
          }
       ]
    }

    Thanks,

    Steve

    Version:
    19.1.3
  • Karthick S
    How to bypass login form of instance after deploy the...Answered135.0
    Topic posted July 4, 2019 by Karthick SRed Ribbon: 250+ Points, tagged SaaS Integration, Security, Services, Stage / Publish / DevOps 
    Title:
    How to bypass login form of instance after deploy the application.
    Content:

    Hi All,

    We are integrating our VBCS application into our Fusion.
    Whenever i opened the application it asking user crenditial for VBCS instance.
    How to overcome from this.
    Kindly assist us.

    Thanks,
    Karthick

    Version:
    19.1.3
  • Stephen Bryant
    upsert based on another field10
    Topic posted June 27, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Business Objects, Custom Code, REST, SaaS Integration, Validation 
    Title:
    upsert based on another field
    Summary:
    Posting to Business Object from ICS
    Content:

    Hello,

    I am extracting data from our SaaS system via an OTBI Report.  This works nicely.  However, I have an identifying field in the report called, CCID.  This is an id present in the SaaS system that I would like to use as the field for upsert to check.  So, is there a way to base upsert on another field?  The id generated in the Business Object will not work in this case.  If there is another way to check not using upsert, that works too.

    Thanks,

    Steve

    Version:
    19.1.3
  • Subba Bhamidipati
    How to call long running sync job (ADF BC method) on...Answered95.0
    Topic posted December 18, 2018 by Subba BhamidipatiBronze Medal: 1,250+ Points, tagged REST, SaaS Integration, UI 
    Title:
    How to call long running sync job (ADF BC method) on page load in VBCS
    Summary:
    Need to call Java method(exposed in AMImpl) on VBCS page load and show busy / loading icon
    Content:

    Hi,

    We have a requirement to process and load batch of invoices from Fusion SaaS (ERP Cloud) before VBCS page loads. This is a functional requirement from business to refresh / sync latest batch of invoices from Fusion SaaS, everytime they launch the UI.

    Previously, we built ADF BC logic and handled this using method call in taks-flow before page renders. Till that method completes we showed ADF busy icon on UI, 

    How can we achieve this same in VBCS UI? If we expose the Java method as REST using ADF BC:

    Would we be able to call the method before VBCS page loads?

    If Yes, how can we show busy / spinning icon till that method completes? 

    Are there any limitation on the amount of time REST API call would wait in VBCS before it times out?

    Any suggestions would be appreciated.

    Thanks,

    Subba

  • vijay.kekane
    Patch to custom Object created in SaaS failAnswered85.0
    Topic posted October 23, 2019 by vijay.kekane Red Ribbon: 250+ 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:
  • Rajeev Singh
    Remove the header title bars and navigation from the VBCS...8
    Topic posted September 20, 2019 by Rajeev SinghRed Ribbon: 250+ Points, tagged SaaS Integration 
    Title:
    Remove the header title bars and navigation from the VBCS application
    Summary:
    Remove the header title bars and navigation from the VBCS application
    Content:

    Hi,

    I have embedded my VBCS App in Oracle Fusion. How can I remove the header title bars and navigation from the VBCS application. it tried passing URL parameter nonav in the embed URL. But it does not work. I used below video as reference.

    https://www.youtube.com/watch?v=HyGJ2paYrcw&feature=youtu.be&t=156

    Also the embedded vbcs app is getting rendered in a very limited space inside SaaS. it adds a scrollbar at the right side.

    Version:
    19.3.1.1
    Code Snippet:
  • Federico Samyn Dowie
    VBAFE-00105 error in Visual Builder Excel Add-In when using...8
    Topic posted June 20, 2019 by Federico Samyn DowieBronze Medal: 1,250+ Points, tagged REST, SaaS Integration, Services 
    Title:
    VBAFE-00105 error in Visual Builder Excel Add-In when using Common APIs in Oracle Apps Cloud
    Summary:
    Getting an error when using REST APIs for Common Features in Oracle Applications Cloud
    Content:

    Hello

    I'm trying to use Visual Builder Add-In for Oracle ERP Cloud 19b to retrieve user Roles but I'm getting the following error:

    "The operation failed due to missing or incomplete data in the response returned from the server. Contact the system administrator. (VBAFE-00105)"

    I am able to call REST APIs for other areas (financials, scm) but not the Common Features. Here's the metadata API I'm using for the Roles API (the one I'm getting an error) which according to this link is the end point for retrieving all roles :

    https://xxxx-test.fa.us2.oraclecloud.com/hcmRestApi/scim/Roles

     

     And below is one example of an API that I'm able to successfully call:

     https://xxxx-test.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/suppliers

     

    Any ideas why I'm struggling with the first API?

    Thanks.

    Fede

     

    Version:
    19B
    Image:
  • absalvi
    How to pull Cloud ERP Report data in VBCSAnswered8
    Topic posted June 13, 2019 by absalvi Red Ribbon: 250+ Points, tagged Business Objects, REST, SaaS Integration 
    Title:
    How to pull Cloud ERP Report data in VBCS
    Summary:
    How to pull Cloud ERP Report data in VBCS
    Content:

    Hi,

    We are trying to create a service connection via REST end point to Cloud ERP SaaS which would fetch BI Report data into VBCS.

    The REST service we are using is /xmlpserver/services/rest/v1/reports/<reportpath> (documentation: https://docs.oracle.com/middleware/12212/bip/BIPAP/rest-endpoints.html )

    However, this REST service is valid for BIP version 12c whereas SaaS BIP version is 11g till now.

    In this case how do we create a service connection which would fetch SaaS BIP data into VBCS?

     

    Thanks,

    Abhishek