Visual Builder

Get Involved. Join the Conversation.

Posts

  • 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
  • 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
  • Rajeev Singh
    Can we raise any event on click of menu items in...Answered2
    Topic posted November 8, 2019 by Rajeev SinghRed Ribbon: 250+ Points, tagged Action Flows, Tip, UI 
    Title:
    Can we raise any event on click of menu items in oj-menu-button
    Summary:
    Can we raise any event on click of menu items in oj-menu-button
    Content:

    Hi,

    I do not see any Event property for Menu Items under Menu button. I want to raise an Event on click of menu options. Is it not possible?

    For work around i have kept all my buttons under oj- menu button.

     

     

    Version:
    19.3.1
    Image:
    Code Snippet:
  • Kalpesh Darji
    When passing json response as input parameter >...
    Topic posted October 31, 2019 by Kalpesh DarjiGreen Ribbon: 100+ Points, tagged Action Flows, REST 
    Title:
    When passing json response as input parameter > DataCloneError: Failed to execute 'replaceState' on 'History': Headers object could not be cloned.
    Summary:
    When passing json response as input parameter > DataCloneError: Failed to execute 'replaceState' on 'History': Headers object could not be cloned.
    Content:

    Hi All,

    After entering value in input text box which is in SHELL page, i do a rest service call. In response i receive Json which i pass as a input parameter to another flow. while doing this I get following error and new page is not displayed. Any idea how to resolve this?

    log.js:22 [VB (ERROR), /oj]: DataCloneError: Failed to execute 'replaceState' on 'History': Headers object could not be cloned.

     

  • 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.

     

     

  • Nandan
    Non-passive event listener3
    Topic posted October 23, 2019 by Nandan, tagged Action Flows 
    Title:
    Non-passive event listener
    Summary:
    Non-passive event listener in Action Chain execution
    Content:

    Hi,

    I see the below console message whenever an action chain is executed. How can I mark an event handler as 'passive' in VBCS?

    I am yet to verify if this is happening for all action chains but I have noticed this in action chains written to handle value change in oj-combo-box and also in oj radio button.

    Log message:

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    oj3rdpartybundle.js:12465 [Violation] Added non-passive event listener to a scroll-blocking 'touchstart' event. Consider marking event handler as 'passive' to make the page more responsive. See https://www.chromestatus.com/feature/5745543795965952

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Regards,

    Nandan

     

    Version:
    19.3.1.2 Runtime version 19.3.1.12
  • Stephen Bryant
    Compound Filter Criterion Issue7
    Topic posted October 23, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Action Flows, Business Objects, Custom Code, UI 
    Title:
    Compound Filter Criterion Issue
    Summary:
    The filter criterion works if you provide the first two fields
    Content:

    Hello,

    I have the following 6 fields that are used as filter criteria on an SDP.

    Treasury Symbol, Fund, Doc Num, Status, fromDate, toDate

    Everything works as long as you provide the first two fields (Treasury Symbol, Fund).  It will not work without these two fields.  I am accounting for nulls using a function provided in Andre's blog at: http://andrejusb.blogspot.com/2019/01/search-form-in-oracle-visual-builder.html.  That works fine.

    The network tab in Chrome Tools indicates a bad request.  Here is the error message when providing only the Treasury Symbol (the first field):

    "detail" : "Failed to build ViewCriteria from expression \"((budgetLevelId = '1') and (treasurySymbol = 3) and (fundValue = '') and (docNumber = '') and (docStatus = '') and (transactionDate >= '') and (transactionDate <= ''))\" using view object DynamicResource. Literal value \"\" cannot be compared with attribute \"fundValue\" of type \"java.lang.Long\". ",

     

    Here is the q parameter when the above error ocurred:

    q: ((budgetLevelId = '1') and (treasurySymbol = 3) and (fundValue = '') and (docNumber = '') and (docStatus = '') and (transactionDate >= '') and (transactionDate <= ''))

    As you can see the query parameter looks fine.  One other bit of information is that Treasury Symbol and Fund are both passed as numbers (the id of the value in the table).  budgetLevelId is always provided.  Doc Number and Doc Status are text and the date fields, of course, are dates.  It seems when a null is passed to Treasury Symbol and/or Fund, the problems start.

    I would like to be able to enter one or many fields and bring back results accordingly.

    Any ideas?

    Thanks,

    Steve 

     

     

    Version:
    19.3.1.2
  • Venkata P
    Issue when clicking on Hyperlink associated with a column in...Answered1
    Topic posted October 20, 2019 by Venkata PGreen Ribbon: 100+ Points, tagged Action Flows, Business Objects, JET, UI 
    Title:
    Issue when clicking on Hyperlink associated with a column in a table
    Summary:
    Hyperlink is unable to obtain selected row.
    Content:

    Hi,

    I have a list view where one of the column is a hyperlink. And when I click on the hyperlink it will trigger an action chain. 

    Issue : When clicking on the hyperlink directly, action chain is unable to obtain the corresponding row data and process request

    Observation : The event selected in the action chain is "FirstRowSelected". So when I clicked on the row first and then clicking on hyperlink works.

    Can any one suggest how can we mitigate problem for click hyperlink without clicking on row first.

    Thanks in advance !!!

    Regards,

    Venkata Chakradhar P

    Version:
    19.3.1.2
  • 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:
  • ninian1927
    2 different response types from REST endpoint, how to...10
    Topic posted October 11, 2019 by ninian1927Red Ribbon: 250+ Points, tagged Action Flows 
    Title:
    2 different response types from REST endpoint, how to account for this?
    Content:

    Hi,

    I am creating a login page which calls a POST REST endpoint. I have create a type from the response when the login is successful, I receive a lot of data back about the user along with a token. However, if the authentication is not successful the response has completely different variables. Currently on my action for a button I have the call REST endpoint linked to the responseType of a call that is successful. However, if the login is not successful then those values aren't available to this responseType as they are stored in a different type. 

    Am I missing something obvious here?