Visual Builder

Get Involved. Join the Conversation.

Posts

  • Andy May-Coates
    How to handle multiple nested collections in Visual Builder...7
    Topic posted Yesterday 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:
  • Ashu Raj
    Call a SaaS service and pass user's SSO credentials2
    Topic posted Yesterday by Ashu RajRed Ribbon: 250+ Points 
    Title:
    Call a SaaS service and pass user's SSO credentials
    Summary:
    We have a UI that calls an Oracle SaaS PO approval service. We already have SSO implemented. Please advise how can we use the same credentials to call the SaaS service.
  • Subramanian K V
    Downloading multiple tables from UI to CSV3
    Topic posted November 15, 2019 by Subramanian K V, tagged JET, Layout, UI, Web 
    Title:
    Downloading multiple tables from UI to CSV
    Summary:
    How to download multiple tables in a single cvs
    Content:

    Hi All,

    I have requirement to download multiple table data into CVS. The table structure is as below,

    One Parent table.

    5 child tables available in under "TABS WITH CONTENT" and another child table next to the parent one.

    Additionally one more child table but not available in the UI.

    Totally 7 tables(6 visible in the UI & 1 not available in UI but child records present in the respective BO)  

     

    The child tables will be refreshed when I toggle between Parent table records. So in a button action, I need to get the current parent and its child related data as separate tables, 7 child tables and one table with one row which should have the selected parent record information. All these in single csv file.

    Experts please provide your inputs.

    Regards

    Subramanian.K.V

     

     

    Version:
    19.3.1.4
  • Subramanian K V
    How to include "NOT IN" clause in query parameter...3
    Topic posted November 15, 2019 by Subramanian K V 
    Title:
    How to include "NOT IN" clause in query parameter of VBCS REST SERVICE
    Summary:
    I have master BO and its child BO. I need to show a column from master BO in an LOV for which there is not record in its Child BO. How to achieve this? Appreciate qucik help
  • Laura Moreno
    Fields Order in Custom Type3
    Topic posted November 15, 2019 by Laura MorenoRed Ribbon: 250+ Points 
    Title:
    Fields Order in Custom Type
    Summary:
    Fields Order in Custom Type
    Content:

    Hi Experts,

    We are developing a VB app that consumes BIP reports from ERP.

    The issue we are dealing with is that we´ve created a custom type:

    vType, which consists of an array of an object that has 2 fields: FIELD1 and FIELD2

    After consuming the ERP report we parse the response to this vType we created.

    The problem is that the ERP report returns the data with this order, FIELD2, FIELD1, but our vType orders its fields alphabetically: FIELD1, FIELD2. That's why the mapping is not working.

    Is there a way to do this or do we need to ask the ERP team to order their tags, alphabetically.

    Thanks in advance.

    Laura

     

     

    Version:
    19.3.1.2
  • Stephen Bryant
    Field Level Update Trigger updates field only onceAnswered6
    Topic posted November 15, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Business Objects, Custom Code, Groovy 
    Title:
    Field Level Update Trigger updates field only once
    Summary:
    Field Level Update Trigger on BO only updates field when record is created
    Content:

    Hello,

    I have a very simple trigger in one BO that executes always.  When a field is updated (treasurySymbol), I grab another field from a related BO (attributeOne).

    This works fine when the record is created but updates do not work.

    It is an update trigger so I am a little confused here.  When I change the treasurySymbol field, the attribute1 field does not change.

    Here is the simple code generated:

    // Field Trigger Beginning 
    println 'Field Trigger started: testUpdateTrigger, business object: fvBeTrxHdrs, field: treasurySymbol';

    try {

      // Always Execute Criterion (Always Execute)
      alwaysExecuteCriterion_1: {
        // Action Group (Action Group)
        test = {
        treasurySymbolObject.attributeOne
        }.call();

      }

    } finally {

      // Field Trigger End 
      println 'Field Trigger ended: testUpdateTrigger';

    }

    Am I missing anything?  I've tried setAttribute, isAttributeChanged without success.

     

    Thank you,

    Steve

    Version:
    19.3.1.2
  • Sombit Chakraborty
    Issue with logout from the VBCS application2
    Topic posted November 15, 2019 by Sombit ChakrabortyBlue Ribbon: 750+ Points, tagged Security 
    Title:
    Issue with logout from the VBCS application
    Content:

    Hi,

    We have built a vbcs application where the identity is provided from an IDCS instance.
    We are unable to the logout from the VBCS application even after we click the standard logout link.

    Error : There is a problem with your account. Please contact Support

    I believe this could be related to the SLO url for the IDCS but not sure how to determine the same.

    Thank You,
    Sombit

  • Deep Mandal
    Oracle VBCS Role Based Mail Send6
    Topic posted November 14, 2019 by Deep Mandal, tagged Action Flows, Business Objects, Custom Code, Groovy 
    Title:
    Oracle VBCS Role Based Mail Send
    Summary:
    Oracle VBCS Role Based Mail Send
    Content:

    In Oracle VBCS how can we send mail to the Users attached to particular VBCS Role.

    For Example:

    Suppose I have two Roles Creator and Approver. So, when users having "Creator" Role creates some record in VBCS BO then I want to send mail to the users having "Approver" role. How this business scenario can be achieved.

    Version:
    19.3.1.2
  • Himanshu Sethi
    I want to redirect to a page after previous page is fully...7
    Topic posted November 14, 2019 by Himanshu SethiBlue Ribbon: 750+ Points 
    Title:
    I want to redirect to a page after previous page is fully loaded
    Content:

    Hi

    I have put a condition , where if an article is not found in the existing page , then it should show the message page not found and then it should redirect to home page.

    But in my case it is directly going to home page even after I have given a delay of sometime so that it should hold on to Page not Found message , it is not happening.

    I am using below command for giving some delay and then I am giving redirect to home page, but it's not working

    "setTimeout(function() {}, 160000);" 

    Please let me know what to add to make it work.

    Thanks,

    Himanshu Sethi

  • Stephen Bryant
    Business Object Function - return array with multiple...2
    Topic posted November 13, 2019 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