Visual Builder

Get Involved. Join the Conversation.

Posts

  • Deep Mandal
    Oracle VBCS Role Based Mail Send1
    Topic posted Yesterday 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...1
    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
  • Mohammed Baig
    Best approach to expose custom database...Answered4
    Topic posted October 31, 2019 by Mohammed Baig, tagged Custom Code, Database, REST, Tip 
    Title:
    Best approach to expose custom database objects/functionality as Rest service, to consume in VBCS
    Summary:
    Best approach to expose custom database objects/functionality as Rest service, to consume in VBCS
    Content:


    Experts,

    We need your help in identifying the best option to expose the custom database objects or custom functionality as a Rest service which can be consumed in VBCS application.

    1. ADF BC Rest - We don't have JCS at moment but if its best option we can get back to customer.
    2. OIC Integrations as Rest - Already subscribed along with VBCS
    3. ORDS - We have custom database of size 15gb 

    FYI, we have already developed an application which is in production now, where we used Oracle JET and ADB BC combination for another customer.

    For this new customer, we have adapted the VBCS and looking for best option to expose Rest services for custom db objects/functionality. 

    Appreciate your response with cons and pros for each of the above approaches Or any other approach apart from the above three. We don't have any skill set limitations.

    Thank you

  • Kalpesh Darji
    Add static text in expression editorAnswered3
    Topic posted October 24, 2019 by Kalpesh DarjiGreen Ribbon: 100+ Points, tagged Custom Code, Groovy 
    Title:
    Add static text in expression editor
    Summary:
    Add static text in expression editor
    Content:

    Hi All,

    I want to add some static text along with expression when response from service is returned. Below code gives me result id, however i want to add some text after result ID.   How can we achieve this?

     

    Code Snippet:
  • Gabriel G Huo
    SSO between VBCS and Fusion ERP Cloud1
    Topic posted October 23, 2019 by Gabriel G HuoBronze Medal: 1,250+ Points, tagged Custom Code, SaaS Integration, Security, UI 
    Title:
    SSO between VBCS and Fusion ERP Cloud
    Summary:
    SSO between VBCS and Fusion ERP Cloud
    Content:

    SSO between VBCS and Fusion ERP Cloud, is this achievable? We want user only have to log into ERP Cloud, and from there we provide a link to VBCS certain pages, is that viable? Any referencing steps

    Thnanks

    Gabriel

  • vijay.kekane
    Patch to custom Object created in SaaS failAnswered85.0
    Topic posted October 23, 2019 by vijay.kekane Green Ribbon: 100+ Points, tagged Business Objects, Custom Code, REST, SaaS Integration 
    Title:
    Patch to custom Object created in SaaS fail
    Summary:
    Patch operation fail
    Content:

    Hi There,

    We have custom object created in financial cloud. This object's row need to be updated when data changes in VBCS screen. I am getting error "[VB (ERROR), /vb/helpers/rest]: The response specifies content type application/json, but unable to parse response as JSON. Reading response as text SyntaxError: Unexpected token I in JSON at position 0".

    Patch operation work good from postman so patch is allowed and I have valid response. Same patch operation also work when setting up REST endpoint in VBCS. However it does not work when update screen is used to update actual row.

    I have created new data Type based on REST endpoint to get response from REST operation. I am not sure reason for above error.

    Version:
    19.3.1.2
    Code Snippet:
  • 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
  • Sweta Singh
    How to raise custom event from app-flow.js file in VBCS appn4
    Topic posted October 23, 2019 by Sweta SinghRed Ribbon: 250+ Points, tagged Custom Code 
    Title:
    How to raise custom event from app-flow.js file in VBCS appn
    Summary:
    How to raise custom event from app-flow.js file in VBCS appn
    Content:

    Hi,

    I want to programatically raise a custom event from app-flow.js file using below syntax.

     var AppModule = function AppModule(context) {

     this.eventHelper = context.getEventHelper();
     this.eventHelper.fireCustomEvent("setBrowserLocaleEvent", e);

    }

    But context object passed in the constructor shows as undefined.

    The same works if we raise the custom event from page level (context object gets the data).

    Could you please help here.

    Thanks,

    Sweta

    Version:
    19.3.1.3
  • Abhilasha Singh
    How to assign repeating element of a variable with values...5
    Topic posted October 23, 2019 by Abhilasha SinghRed Ribbon: 250+ Points, tagged Custom Code, Groovy, JET, REST, UI 
    Title:
    How to assign repeating element of a variable with values from an array in the action chain
    Summary:
    How to assign repeating element of a variable with values from an array in the action chain
    Content:

    I have a variable based on REST endpoint that has repeating element in it that needs to be assigned from the rows of an ADP variable. How do I do that in action chain. I don't see for available in assign. if I use for each in the action chain how do I iterate the target variable to assign to next row in the loop. 

    Document:
    assign.PNG (33KB)
  • Mayank Srivastava
    Use of Oracle Offline Persistence Toolkit in visual builder...5
    Topic posted October 23, 2019 by Mayank SrivastavaGreen Ribbon: 100+ Points, tagged Custom Code, JET 
    Title:
    Use of Oracle Offline Persistence Toolkit in visual builder for Caching
    Summary:
    Use of Oracle Offline Persistence Toolkit for Caching
    Content:

    I have a auto suggest textbox on multiple pages of my application. Content to be displayed for autosuggest is preloaded with the application load and gets displayed. I have added the action chain at the application level since user can load any page directly so adding the action chain to home page will not work.

    Now the problem is that on each page change that action chain gets called which results in some latency. Is there a way we can use oracle offline persistence toolkit in such case that once the content is loaded then service is not called each time on page change.

    Please let me know if any more details are required.