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:
  • Karthick S
    How to return array values in JS function in VBCS?17
    Topic posted June 29, 2019 by Karthick SRed Ribbon: 250+ Points, tagged Action Flows, Custom Code 
    Title:
    How to return array values in JS function in VBCS?
    Content:

    Hi Team,

    I am trying to return array in Javascript and split those array values and populate in text fields.
    But the array values which i return in JS couldnt able to get from the call module function result.
    Please find the sample code which i have tried.
    Kindly help us to do.

     

    Thanks,

    Karthick

    Version:
    19.1.3
    Code Snippet:
  • Stephen Bryant
    Update an Array from JavascriptAnswered165.0
    Topic posted May 1, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Action Flows, Custom Code, Layout, UI 
    Title:
    Update an Array from Javascript
    Summary:
    Update an Array from Javascript after assigning field values in one column
    Content:

    Hello,

    I create the following screen included below.

    I've created a function that iterates over the array and assigns a sequence number in one field for every row.  The sequence number is generated using a range.  This range will represent check numbers.  The idea is to update all payment rows with the check number.

    range -     10  to 20

    rows         check number

    1               10

    2                11

    3               12

    10             20

    I can get this to work in pure javascript in Sublime but I am unable to get it to work in VBCS.

    The function accept two parameters from the Page (paymentArray, lowNumber).

    In the action chain, I grab the variables, pass them to the function, and attempt to update the array, assign the result to the ADP and refresh the ADP but it is not working.  I am not sure how to reference the array nor update the array correctly.

    Here is my code for the function 

    PageModule.prototype.assignCheckNum = function (invArray, lowEnd) {
      
      var PaymentDescription = 0;
      
      for (var i = 1; i <= invArray.length; i++ ) {
        
        if ( i == 1) {
          
          invArray.PaymentDescription = lowEnd;       
          
        } else {
          
          invArray.PaymentDescription = lowEnd + 1;
          lowEnd += 1;            
        }      
        }    
        return invArray;

      };

    Any help is appreciated.

    Thanks,

    Steve

     

     

     

    ...

    Version:
    19.1.3
    Image:
  • Stephen Bryant
    Using a URL (as opposed to a selected row event) and...Answered145.0
    Topic posted July 19, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Action Flows, Business Objects, REST, UI, Web 
    Title:
    Using a URL (as opposed to a selected row event) and Passing parameters to filter the ADP
    Summary:
    click URL, pass parameters and filter an ADP
    Content:

    Hello again,

    I can certainly configure a selected-row event and pass parameters to filter an ADP and show records.

    Is it possible to do this with a link on say, a document number, and passing that document as a parameter to filter and ADP?

    The goal is to show document numbers with an underline indicating that they can be clicked to bring up the details of that document.  This works the traditional when using the select-row event but would like it as a url.

    Thanks,

    Steve

    Version:
    19.1.3
  • 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
  • Kapil Kapani
    Unable to start the PCS Process from VBCS using alias145.0
    Topic posted August 1, 2018 by Kapil KapaniBronze Medal: 1,250+ Points, tagged Action Flows, Process, REST 
    Title:
    Unable to start the PCS Process from VBCS using alias
    Summary:
    Unable to start the PCS Process from VBCS using alias
    Content:

    Hi 

    I have configured a PCS process as an Alias in VBCS

    Configured the Submit button in the page to Start the process

    But I get an error when I click on the Submit saying the Alias is invalid.

    Could you please help ? Below are the images that show the issue.

    Image:
    Document:
    Document:
    Document:
  • Shakila Murugan
    How to Generate PDF in Oracle VBCS?135.0
    Topic posted September 8, 2019 by Shakila MuruganBronze Medal: 1,250+ Points, tagged Action Flows, Business Objects, Custom Code, JET, UI 
    Title:
    How to Generate PDF in Oracle VBCS?
    Content:
    Hi Team
     
    I need to generate PDF file in VBCS.
     
    I have tried that in Oracle JET. In JET i have added library in main.js file
     
     'pdfmake': 'libs/Pdf/pdfmake',
        'vfs_fonts': 'libs/Pdf/vfs_fonts',
     
    and also extra 3 js files in src folder.
    It's worked fine in JET.
     
    Is this approach will work in VBCS?
    Is there any feature to add library in VBCS?
    Is there any other option available in VBCS to generate PDF? or i need to add pdfmaker library in vbcs to achieve this?
     
    Help me to solve this.
     
    Thanks
    Shakila Murugan
    Version:
    19.1.3
  • Shakila Murugan
    Business Object not getting updated?Answered125.0
    Topic posted August 27, 2019 by Shakila MuruganBronze Medal: 1,250+ Points, tagged Action Flows, Business Objects, Custom Code, UI, Validation 
    Title:
    Business Object not getting updated?
    Content:

    Hi all,

    I have created vbcs application and integrated it into fusion page.
    When i insert or update data in my application (after integrating my application into fusion)
     it's not getting reflected in my VBCS Business object.

    Do i need to add any anonymous access for this?

     

    Thanks

    Shakila Murugan

    Version:
    19.1.3
  • Nazeer Anantha
    Dependent LOV based Rest API(VBCS)Answered125.0
    Topic posted February 25, 2019 by Nazeer AnanthaBlue Ribbon: 750+ Points, tagged Action Flows, Business Objects, JET, REST, UI, Web 
    Title:
    Dependent LOV based Rest API(VBCS)
    Summary:
    Dependent LOV not Working which is based on Rest API(VBCS)
    Content:

    Hi All,

    I have a REST API. based on REST API, I have created 2 LOV's. which is dependent.

    I can see the data in both the LOV but filter is not working in child LOV.

     

    I followed same approach based BO for testing purpose. it's working as expected.

    is there any issue in Dependent LOV which is based on REST API. or anything I am missing here.

    can you please tell me. 

     

     

     

  • M Sridhar
    Error Calling Deeplink in VBCS125.0
    Topic posted February 15, 2019 by M SridharSilver Medal: 2,000+ Points, tagged Action Flows, JET, UI, Validation, Web 
    Title:
    Error Calling Deeplink in VBCS
    Summary:
    Error Calling Deeplink in VBCS
    Content:

     

    I am calling a deeplink of sales cloud in VBCS using navigate URL in action chain (or with hyperlink), but it is throwing below content......the URL I am trying is working in the browser directly....Please let me know any pointers..?

    {"type":"https:\/\/www.w3.org\/Protocols\/rfc2616\/rfc2616-sec10.html#sec10.4.5","title":"Not Found","detail":"webApps\/itemcreate\/<<myCloudURL>>\/fscmUI\/faces\/deeplink","status":404}