Visual Builder

Get Involved. Join the Conversation.

Posts

  • Vinod Kumar Kv
    How to use conditional compound filter for below criteria:...25
    Topic posted November 9, 2018 by Vinod Kumar KvBronze Medal: 1,250+ Points, tagged Business Objects, Database 
    Title:
    How to use conditional compound filter for below criteria: Service Data Provider (on table)
    Summary:
    How to use conditional compound filter for below criteria: Source: Service Data Provider (on table)
    Content:

    How to use conditional compound filter for below criteria:

    Source: Service Data Provider (on table)

    Scenario:

    By default show query all records for object with sid==$page.variables.pk

    OR

    There is filter by name text box on page: if user wants to search records based on name then use criteria
    sid==$page.variables.pk AND firstName LIKE $page.variables.nameFilter

    Basically we want to have primary key filter always. If there is value in filter text box then apply AND operator with PRIMARY KEY value

    CRITERIA: (sid==$page.variables.pk) OR (sid==$page.variables.pk AND firstName LIKE $page.variables.nameFilter)
    At any point of time only one should work.

    As of now we have below mentioned filter criteria but this code is listing all records always with .
    {
     "criteria": [
      {
       "attribute": "{{ \"sId\" }}",
       "op": "{{ \"$eq\" }}",
       "value": "{{ $page.variables.pk }}"
      },
      {
         "op": "{{ \"$and\" }}",
         "criteria": [
          {
           "attribute": "{{ \"firstName\" }}",
           "op": "{{ \"$co\" }}",
           "value": "{{  \"$page.variables.nameFilter\" }}"
          },
          {
           "attribute": "{{ \"sId\" }}",
           "op": "{{ \"$eq\" }}",
           "value": "{{ $page.variables.pk }}"
          }
         ]
      }
     ],
     "op": "{{ \"$or\" }}"
    }

     

  • Jgn P
    Business Objects Lookup using RESTAnswered225.0
    Topic posted December 11, 2018 by Jgn PBlue Ribbon: 750+ Points, tagged Business Objects, REST 
    Title:
    Business Objects Lookup using REST
    Summary:
    Business Objects Lookup using REST
    Content:

    is there a way to create a Rest End point to look up a business object row by a custom created field and not by the id field of a newly created Business Object in VBCS. I can see that by default it gives me the option to look up by id parameter but i am looking to see if it can be looked up by another custom field. 

  • 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:
  • Wahab Ladjeroud
    error satus 403 cannot svave record14
    Topic posted October 7, 2019 by Wahab LadjeroudGreen Ribbon: 100+ Points, tagged Business Objects, Stage / Publish / DevOps 
    Title:
    error satus 403 cannot svave record
    Summary:
    Saving a newly created record gives 403: save faild
    Content:

    HI,

    I am building an application.

    I can preview, add data, delete and update data.

    When i staged the application

    i anam not able to see tha few records i had previously

    and when i try to add new one and press save

    i have the following error:

    Thank you in advance

    Version:
    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
  • Kashyap Raghavendra
    List of Values in Visual Builder Excel Plug in13
    Topic posted December 6, 2019 by Kashyap RaghavendraRed Ribbon: 250+ Points, tagged Business Objects, REST 
    Title:
    List of Values in Visual Builder Excel Plug in
    Summary:
    Setting filter in List of Value object based on the Excel cell value or by the referenced field name of the business object
    Content:

    Hi,

    Can the filter for the List of Values  of a field be set based on the value of an other field in the  in the table . 

    e.g. q=ID = $D2.Value to get value of D2 column in excel or by the  referenced column of the business object .

     

    Thanks and regards

    Kashyap

     

     

     

  • Andy May-Coates
    How to handle multiple nested collections in Visual Builder...Answered135.0
    Topic posted November 18, 2019 by Andy May-CoatesBronze Trophy: 5,000+ Points, tagged Business Objects, Layout, REST 
    Title:
    How to handle multiple nested collections in Visual Builder add-in for Excel
    Summary:
    How to handle multiple nested collections in Visual Builder add-in for Excel
    Content:

    In the Oracle Visual Builder add-in for Excel, a form-over-table layout can be used to support parent-child business object relationships e.g. supplier and supplier site.

    However, we have a REST API where there are multiple nested child collections, and properties need to be supplied at each level to be of any use. For example:-

    https://***.oraclecloud.com/fscmRestApi/resources/11.13.18.05/financialProjectPlans

    This has several nested levels of child collections, and properties from each level need to be included to bulk update a financial project plan resource assignment. For example:-

    Project level detail would come from the top level "financialProjectPlans"
    Task and resource detail would come from the next level "ResourceAssignments"
    Currency and plan amount totals come from the next level "PlanningAmounts"
    Periodic plan amounts come from the lowest level "PlanAmountDetail"

    What we really need is a table layout containing properties from all four levels above, where parent properties would simply fill down/duplicate.

    On a related note, when we import the swagger for the above service, the plugin only shows the top three levels (see image below). This seems to be the case for other REST APIs. Is this a product limitation? Is there any workaround to this either?

    Any help greatly appreciated.

    Version:
    Oracle Visual Builder Add-in for Excel 2.0.0.20643
    Image:
    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