Application Development

Overview of Discussion Forums

This is a public Group  public

Posts

  • Andy May-Coates
    How to handle multiple nested collections in Visual Builder...Answered135.0
    Topic last edited November 18, 2019 by Andy May-CoatesBronze Trophy: 5,000+ Points, tagged Business Objects, Layout, REST in Visual Builder public
    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:
  • vijay.kekane
    VBCS BO REST endpoint with query (q) for multiple...Answered2
    Topic posted November 20, 2019 by vijay.kekane Red Ribbon: 250+ Points, tagged Business Objects, REST in Visual Builder public
    Title:
    VBCS BO REST endpoint with query (q) for multiple fields
    Summary:
    REST end point give error (400 bad request) for multiple fields
    Content:

    Hi There,

    I created BO in VBCS with multiple fields. We need to query this BO, then based on return perform insert (post) or update (patch). I need to check data based on two fields. So I am using REST endpoint getAll for BO with query (q) parameter. My problem is REST call for 2 fields give error. Here is syntax of my call

    https://<domain>/ic/builder/design/<VBCS app name>/1.0.1/resources/data/GLCOASegmentValues?q=lookupValue='1000000';lookupName='Account HS'

    which give 400 bad request error.

    For more information, both fields have searchable checked. Above call work with 1 field (either lookupValue or lookupName) but, not for both. I check syntax for REST endpoint for 2 columns and they are separated by semi colon (;), used above. It work for REST endpoint from SaaS (financial cloud). Do I need to use any different syntax or any change in BO, fields definition?

    I am performing REST endpoint testing in Postman.

    Thanks,

    Vijay

    Version:
    19.3.1.2
  • Vishnu Mishra
    ApplicationCommon.js Not Found in Staged ApplicationAnswered8
    Topic posted November 21, 2019 by Vishnu MishraRed Ribbon: 250+ Points, tagged Stage / Publish / DevOps in Visual Builder public
    Title:
    ApplicationCommon.js Not Found in Staged Application
    Summary:
    ApplicationCommon.js Not Found in Staged Application
    Content:

    Hi,

    I am making use of the ApplicationCommon.js to call some in-built functions. The application runs fine when I use the "run" button but when I stage it, the application simply doesn't run. In the network logs, I can see that ApplicationCommon.js is not found. I am attaching my JSON file where you can see I am importing the JS file.
    I have another staged application from a different instance which also uses the ApplicationCommon.js and it runs perfectly fine. If I hit the URL of the JS file (https://<INSTANCE URL>/ic/builder/rt/Myoderm_Customer_Portal/1.0/webApps/dcs/version_513882908295687382/build/components/oj-odcs/2.4.2/knowledge-common/KnowledgeCommon.js) for this staged application, I can see the JS file. But if I use the URL for my another application -- which doesn't work -- I get a 404 Error. How can this be rectified?

    Regards,
    Vishnu

    Version:
    19.3.1.4
    Document:
    Portal JSON.json (869 Bytes)
  • Stephen Bryant
    Field Level Update Trigger updates field only onceAnswered6
    Topic last edited November 15, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Business Objects, Custom Code, Groovy in Visual Builder public
    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
  • Pawan Gupta
    Microsoft Teams to ODA (how to pass username)Answered85.0
    Topic posted November 6, 2019 by Pawan GuptaBlue Ribbon: 750+ Points, tagged Conversational AI, Virtual Assistant, VPA in Digital Assistant and Mobile public
    Title:
    Microsoft Teams to ODA (how to pass username)
    Summary:
    Microsoft Teams to ODA (how to pass username)
    Content:

    In enterprise digital assistant use case, MS Teams is going to be the blockbuster channel for accessing the digital assistants. I am trying to enable the DAs in MS team though need some help in documentation or any blog, article on how can we pass user details from MS Teams to ODA. Appreciate your help.

  • Deep Mandal
    Oracle VBCS Role Based Mail SendAnswered65.0
    Topic posted November 14, 2019 by Deep MandalGreen Ribbon: 100+ Points, tagged Action Flows, Business Objects, Custom Code, Groovy in Visual Builder public
    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
  • Sten
    How to create VBCS responsive designAnswered95.0
    Topic posted November 8, 2018 by Sten Red Ribbon: 250+ Points, tagged UI in Visual Builder public
    Title:
    How to create VBCS responsive design
    Summary:
    We used to have a tab where you could select which fields to show in which resolutions. That seems to be gone in 18.4?
    Content:

    We used to have a tab where you could select which columns in a table would be displayed in which layouts (iphone, tablet, horizontal/vertical). I can't find that option in 18.4 - was it taken out or did it move to somewhere that I can't find?

    Best regards
    Sten Vesterli

    Version:
    Version: 18.4.1 Build Number: c1b87e0cb22e2ba5b70706fc9bfa3c4b0f58351a (2018-10-09 23:07:49) Runtime Version: 18.4.1.5 JET runtime version: v5.2.2
  • John Wilson Cusi
    List View on VBCS Version: 19.3.1.4Answered115.0
    Topic last edited November 12, 2019 by John Wilson CusiBronze Medal: 1,250+ Points in Visual Builder public
    Title:
    List View on VBCS Version: 19.3.1.4
    Summary:
    Is there a defect on List View on VBCS Version: 19.3.1.4
    Content:

    What has been change from the List View component from VBCS version 19.1.3 and version 19.3.1.4?

    I am displaying the attached json response (the service info part only) to a List View. It works on the older version however no data is being displayed in the new version.

    The REST web service was tested successfully on both versions and are returning values. There is also no difference on how I implemented it on each versions. I retested even in Table View but the new version is not displaying any data, works well in the old.

    Help!

    note: json response data are all tests and are not live/real data

    Version:
    VBCS 19.3.1.4
    Document:
    Document:
    SDP.jpg (36KB)
    Video:
  • Abhilasha Singh
    Open Modal Dialog not working on second call from an action...Answered6
    Topic posted October 10, 2019 by Abhilasha SinghRed Ribbon: 250+ Points, tagged JET in Visual Builder public
    Title:
    Open Modal Dialog not working on second call from an action chain.
    Summary:
    Open Modal Dialog not working on second call from an action chain.
    Content:

    Requirement is to display values returned from a rest service in a dialog containing table with the details. this action is implemented on value change event of an input text. it works well for the first time. wherein for the second time it opens the dialog for a sec and gets closed with a warning. Below is the code snippet from JS and JET.

    JS: PageModule.prototype.openDialog=function(){
                  document.querySelector('#modalDialog1').open();
                  };
        PageModule.prototype.closeDialog = function(){
                  document.querySelector('#modalDialog1').close();
                  };

    JET: 

    <div id="dialogWrapper">
      <oj-dialog style="display:none" id="modalDialog1" dialog-title="Item" autoopen="false" dir="auto">
        <div slot="body">
    <div class="oj-flex">
      <oj-table summary="Sample Table" scroll-policy="loadMoreOnScroll" id="oj-table--1889302292-1" class="oj-flex-item oj-sm-12 oj-md-12" data="[[$page.variables.getItemsQueryListSDP]]" columns='[{"headerText":"ItemNumber","field":"ItemNumber"},{"headerText":"ItemDescription","field":"ItemDescription"},{"headerText":"OrganizationCode","field":"OrganizationCode"}]' selection-mode.row="single" selection-mode.column="single" on-first-selected-row-changed="[[$listeners.ojTable18893022921FirstSelectedRow]]"></oj-table>
    </div>
        </div>
        <div slot="footer">
          <oj-button id="okButton" on-oj-action="[[$listeners.buttonOpenerOjAction]]">OK
          </oj-button>
        </div>
      </oj-dialog>
    </div>

     

  • Abhilasha Singh
    Table columns move from its position when some value is...Answered6
    Topic posted October 21, 2019 by Abhilasha SinghRed Ribbon: 250+ Points, tagged JET, Layout, UI in Visual Builder public
    Title:
    Table columns move from its position when some value is being entered in the editable fields in the table
    Summary:
    Table columns move from its position when some value is being entered in the editable fields in the table
    Content:

    I have an editable table in the page. when I enter some value in the editable field, the table columns move from its position while I type. This doesn't look good to the users. Please let me know if any of you have faced this and have a solution.