Visual Builder

Get Involved. Join the Conversation.

Posts

  • Subramanian K V
    Downloading multiple tables from UI to CSV2
    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
  • Mohammed Kaja Nawaz L J
    Staged/Live Published application URL has version number3
    Topic posted October 30, 2019 by Mohammed Kaja Nawaz L JBronze Medal: 1,250+ Points, tagged Action Flows, Composite Component, Services, Stage / Publish / DevOps, UI, Web 
    Title:
    Staged/Live Published application URL has version number
    Content:

    Hi all,

    During development stage, when we check the application the URL doesn't contain any version number but when we stage or publish the application, the URL is appended with version number as like below:

    Development URL:

    https://<pod>/ic/builder/design/<project>/1.1/preview/webApps/<application>/test.html

    Staged/Published URL:

    https://<pod>/ic/builder/design/<project>/1.1/live/webApps/<application>/version_7175212418406661417/test.html

    How to remove version number in the staged/published URL.

     

     

  • Venkata P
    Dialog box is auto closing and not opening againAnswered2
    Topic posted October 26, 2019 by Venkata PGreen Ribbon: 100+ Points, tagged JET, Layout, UI, Web 
    Title:
    Dialog box is auto closing and not opening again
    Summary:
    Page has a dialog box which opens on click of button and closing automatically
    Content:

    Hi All,

    My page has a dialogbox which opens on click of button. First it opens as expected. When you click on the button again it auto closes and never opens again.

    Could you let me know what went wrong here. Below is html code and and java script.

    HTML Code :

            <div id="dialogWrapper">
              <oj-dialog style="display:none" id="modalDialog1" title="Modal Dialog">
                <div slot="body">
                   The dialog window can be moved, resized and closed with the 'x' icon.
                   Arbitrary content can be added to the the body and footer sections.
                </div>
                <div slot="footer">
                  <oj-button id="okButton" data-bind="click: function() {
                      document.querySelector('#modalDialog1').close();
                    }">  OK
                  </oj-button>
                </div>
              </oj-dialog>
              <oj-button id="buttonOpener" data-bind="click: function() {
                  document.querySelector('#modalDialog1').open();
                }">
                Open Modal Dialog
              </oj-button>
            </div>

    Java Script:

    define([], function() {
      'use strict';

      var PageModule = function PageModule() {};

      return PageModule;
    });

     

     

    Version:
    19.3.1.2
    Image:
    Code Snippet:
  • Ziv Rubin
    External POST Request Timeouts4
    Topic posted October 22, 2019 by Ziv RubinBronze Medal: 1,250+ Points, tagged Business Objects, REST, Web 
    Title:
    External POST Request Timeouts
    Summary:
    External POST request returning timeout error
    Content:

    Hi All,

    I created a mid-tier Java app that sends POST requests to my VBCS business object.

    After 30 to 80 requests, its returning "Connection timed out: connect" error. I increased and decreased the connection timeout and read timeout parameters, still no change.

    Consider that I did not have any issues with 500 POST requests using internal VBCS flow functionalities; Are there any limitations of VBCS while making external REST API POST requests? 

    Regards,

    Ziv

  • Nazeer Anantha
    Access ERP Role in VBCS1
    Topic posted October 22, 2019 by Nazeer AnanthaRed Ribbon: 250+ Points, tagged JET, REST, SaaS Integration, Security, Services, UI, Validation, Web 
    Title:
    Access ERP Role in VBCS
    Summary:
    Access ERP Role in VBCS
    Content:

    Hi All,

    Is it possible to access the ERP role in VBCS?

    Note; I want to disable buttons on the VBCS screen based on the ERP role.

    Thanks,

    Nazeer.

  • Omar El-Elaimy
    WebViews for VBCSAnswered2
    Topic posted October 18, 2019 by Omar El-Elaimy, tagged Action Flows, Services, Web 
    Title:
    WebViews for VBCS
    Summary:
    I want to create a web view in a VBCS app to be used within my digital assistant.
    Content:

    Everything is good with the digital assistant component is good and done. Now my problem is in action chains and how to pass variables from a page to another in VBCS.

    I was following this tutorial:

    https://docs.oracle.com/en/cloud/paas/digital-assistant/tutorial-host-vb/index.html

    However, the problem is i can't find the FinancialDispute starter application for VBCS as the tutorial states. So I'm kind of doing everything on the app by myself.

    I need to know how the input texts (Name and amount) are loaded from the code that's written in the HTML index file.

    https://docs.oracle.com/en/cloud/paas/digital-assistant/tutorial-host-vb/img/vbcs_11.png

     

    Also, how to pass the radio set value chosen to the action chain of the button that has a module function with postbackURL and data to be submitted which is the radioset's value.

     

     

    Image:
  • Venkata P
    How to get table data on click of a button and update some...Answered3
    Topic posted October 17, 2019 by Venkata PGreen Ribbon: 100+ Points, tagged Custom Code, JET, Layout, UI, Web 
    Title:
    How to get table data on click of a button and update some columns in another table
    Summary:
    Get table data on click of a button and update some columns in another table
    Content:

    Hi All,

    I have the below requirement,

    1. I have a BC with name parameters and it is displayed in table with another new columns which are not part of BC fields as below

    • Name
    • Id
    • Type
    • Remarks --> This is a input text column which is not part of BC fields

    2. Now user will update multiple rows in the remarks column and click on save button on the bottom of the table

    3. Now these remarks should be updated to another BC named RemarkDetails with the remarks data inserted into it. Remarks details has below columns

    • Id
    • ParameterReportID --> This is same as ID in parameters BC
    • Remarks -> This is entered by user in the UI table 

    Ask is to how I can capture the table data in the webpage into a variable and loop over it and insert remarks into another BC ? 

    Thanks in Advance !!!

    Regards,

    Venkat P

     

     

      

     

     

    Version:
    19.3.1.2
  • Pawan Gupta
    VBCS mobile app, embedding oracle digital assistant cloud...1
    Topic posted October 11, 2019 by Pawan GuptaBlue Ribbon: 750+ Points, tagged JET, Mobile, UI, Web 
    Title:
    VBCS mobile app, embedding oracle digital assistant cloud skills
    Summary:
    VBCS mobile app, embedding oracle digital assistant cloud skills
    Content:
    Any guidance, reference or documentation to do following. Create mobile or pwa app in vbcs Embed web channel javascript sdk based oda skills Appreciate your help.
  • Hugo Zandt
    How to make a VBCS login page that uses Oracle Identity...35.0
    Topic posted October 8, 2019 by Hugo ZandtGreen Ribbon: 100+ Points, tagged Action Flows, REST, SaaS Integration, Security, Services, Style, UI, Web 
    Title:
    How to make a VBCS login page that uses Oracle Identity cloud
    Summary:
    How to create a login page in VBCS that uses the default oracle identity cloud service to authenticate users.
    Content:

    Hello,

    Goal

    We would like to create a login page in VBCS that uses the default oracle identity cloud service to authenticate users. We want to customize the look and feel of the login page for only the users of one particular VBCS application.

    Approach

    • We have created the customized login page which contains text fields for username and password and a login button.
    • The login button has an action chain.
    • The userconfig in our app-flow.json is as follows (unaltered default values):

     "userConfig" : {

        "type" : "vb/DefaultSecurityProvider",

        "configuration" : {

          "authentication" : {

            "type" : "oraclecloud"

          }

        },

     

    Problem

    It is unclear to us how to configure an action chain that passes the username and password to the oracle identity cloud service to authenticate a user.

    We do not want to develop the actual authentication logic in VBCS, as was done in: https://cloudcustomerconnect.oracle.com/posts/6bc348535f and https://blogs.oracle.com/shay/conditional-navigation-based-on-queries-in-oracle-visual-builder-cloud-service .

    Question

    How to configure an action chain that passes a username and password to the oracle identity service to authenticate a user.

    Thanks,

    Hugo

     

    Version:
    19.3.1.2.
  • Ronald Konijnenberg
    Internal server error 500 when creating a complex business...1
    Topic posted September 26, 2019 by Ronald KonijnenbergGreen Ribbon: 100+ Points, tagged Action Flows, Business Objects, Database, REST, Security, Web 
    Title:
    Internal server error 500 when creating a complex business object using REST call
    Summary:
    Internal server error 500 when creating a complex business object using REST call.
    Content:

    Goal
    We would like to store a page variable, whose type is based on the POST request of the REST endpoint of one of our business objects, in our businessobjects. The business object is a complex type referencing another business object, that in its turn references two other business objects. See attached Image.

    Approach
    We've recreated our approach in an example application which produces similar behaviour:

    1. We defined a request and response type based on a 'complex' business object. In the example app this is the "Driver" object.
    2. We've set appropriate values in pages variable and assigned those to the newDriver variable which is based on the request type. The request variable contains a new driver, new combination of a new trailer and a new truck (we do not want to use existing trailer and truck objects in this scenario).
    3. In an action chain we added a REST call action which performs a POST on the businessobject's REST endpoint. We assign the page variable newDriver to the body of the POST call.

    Problem

    1. We get an internal server error (500) when we attempt to post the driver_request variable. Error details show numerous exceptions, all showing:

    arguments: [Exception: TypeError: 'caller', 'callee', and 'arguments' properties may not be accessed on strict mode functions or the arguments objects for calls to them at Function.invokeGetter (<anonymous>:2:14)]

    This looks similar to the error discussed in post: https://cloudcustomerconnect.oracle.com/posts/a1e366f640 this post however does not present a solution.

    1. When we try to store only the 'combination' object within the driver_request variable, by calling the Combination endpoint instead of the Driver endpoint, we do NOT get this error. However, 'trailer'  and 'truck' object are saved successfully and ID's are generated, but these generated ID's are not used as foreign keys in the new 'combination' object and results in an empty Combination object.

    Question

    1. How can the internal server error be resolved?

    2. How can we make sure that the foreign keys of the Trailer and Truck are also stored when the Combination is being created?

    Example

    See attached file for an example project that contains two buttons to reproduce these two problems.

    Version:
    19.1.3
    Image: