Visual Builder

Get Involved. Join the Conversation.

Posts

  • Stephen Bryant
    Business Object Function - return array with multiple...1
    Topic posted Yesterday 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
  • vijay.kekane
    Select One LOV in edit page2
    Topic posted November 12, 2019 by vijay.kekane Green Ribbon: 100+ Points, tagged Business Objects 
    Title:
    Select One LOV in edit page
    Summary:
    Select One field does not populate value in edit page
    Content:

    Added HTML of edit page.

    Hi There,

    I followed simple steps in apps related to select one field, which shows LOV based on local VBCS BO,

    1) Create BO in VBCS (customers) and populate it with data.

    2) Create Save page. It save data into another VBCS BO (SubsidiaryLedger). Save page has Select(One) type field called customerNumber. It shows lov based on customers BO. LOV shows expected values and populate VBCS BO field (customerNumber) in SubsidiaryLedger successfully.

    3) Edit page is created to edit records created above. This page also has Select(One) type field and shows lov based on customers BO.My problem is when edit page is loaded, it does not show value in customerNumber field.

    I have main page which list all records and navigate to create or edit. I can navigate to edit page from main page after selecting record (standard functionality). I can see this value in Input Text type field but, not in Select(One) on edit page.

    Not sure if q parameter is solution but, I tried to use it in customersListSDP (used for LOV) page level variable but, it does not work.

    Any idea how to make it show value in edit page using Select(One) type field?

    Thanks,

    Vijay

    Version:
    19.3.1.2
    Document:
  • Nisheeth Ranjan
    Not able to access Business Object within VBCS application2
    Topic posted November 11, 2019 by Nisheeth RanjanSilver Medal: 2,000+ Points, tagged Business Objects, Security 
    Title:
    Not able to access Business Object within VBCS application
    Content:

    Hi Experts, 

    We are having an issue while accessing the business object within a VBCS application. It's giving 500 internal error(). 

    Have tried accessing the same using the Postman as well however getting the issues.

    Please note that it was working fine in September, stopped working from the first week of October. Can any recent upgrades cause this? we haven't made any changes to the application or configurations at all.

    Any suggestions or guidance would be highly appreciated.

    Thanks,

    Nisheeth

  • Vivek Pathak
    Integrating PaaS and SaaS1
    Topic posted November 6, 2019 by Vivek Pathak, tagged Business Objects, SaaS Integration 
    Title:
    Integrating PaaS and SaaS
    Summary:
    Application on VBCS based on data from Procurement Cloud
    Content:

    I am developing an application on VBCS which will have a dashboard which will have a section which will display quotes data in tabular form form from Procurement Cloud.

    Any suggestions?

  • vijay.kekane
    Display name instead of ID on main-start page1
    Topic posted November 1, 2019 by vijay.kekane Green Ribbon: 100+ Points, tagged Business Objects, JET, REST, UI 
    Title:
    Display name instead of ID on main-start page
    Summary:
    Display name instead of ID
    Content:

    Hi There,

    I have application with 3 pages, Main-Start, Main-Create, Main-Edit. Main-start is first page displayed when application is run. Data is created/saved using create page. Field "ledger" is shown on both pages. We use LOV for it, which show name but, store ID in VBCS BO.

    When application run it shows list of rows in main page (image of start-main is attached) using VBCS BO, We want to display name of ledger instead of ID.

    I am not sure which page level event will allow me to scan through each record to find name based on ID (using REST) and display name on Main-Start page.

    Thanks,

    Vijay

     

    Version:
    19.3.1.2
    Image:
  • aaina Khan
    Issue with dropdown - options taken from SDP
    Topic posted October 30, 2019 by aaina KhanRed Ribbon: 250+ Points, tagged Business Objects, JET, Services, UI 
    Title:
    Issue with dropdown - options taken from SDP
    Summary:
    Default value not getting loaded in dropdown when i take the options from an SDP
    Content:

    I have created a service connector (describe) for connecting a business object and the key and values from the BO would be taken to display options for a drop down. The dropdown is working fine. 

    But the real issue comes when I assign the Value of the drop down to a valid value from the results obtained from the above said SDP. For example if the option name is India and option value is IN, and I am setting the value attribute of the dropdown option (oj-select-one) to IN, the default value India should be displayed but its not. I am using similar  dropdown in the same page that will fetch value from some other similar service. It fetches and displays values correctly. Kindly help me to figure out what I made wrong. Am attaching the console data FYR.

    Attaching both which is behaving correct correctOne.png and wrong one wrongOne.png also.

     

    Image:
    Document:
  • Kalpesh Darji
    Custom login page in VBCS and query business object using...Answered2
    Topic posted October 25, 2019 by Kalpesh DarjiGreen Ribbon: 100+ Points, tagged Business Objects, REST, Services 
    Title:
    Custom login page in VBCS and query business object using REST API
    Summary:
    Custom login page in VBCS and query business object using REST API
    Content:

    Hi Shay,

    I would like to create custom login page with username and password in database. How can we proceed further? Can we use business function to achieve this or below link is the option to go?

    https://blogs.oracle.com/shay/conditional-navigation-based-on-queries-in-oracle-visual-builder-cloud-service

    Another question: How can we pass query parameter other than id in Rest endpoint of business objects? Is the ID as query parameter is limitation?

     

  • vijay.kekane
    LOV reverse translation4
    Topic posted October 24, 2019 by vijay.kekane Green Ribbon: 100+ Points, tagged Business Objects 
    Title:
    LOV reverse translation
    Summary:
    Get value based on ID
    Content:

    Hi There,

    We have requirement to display name in LOV but, store ID in business object. It is easy to implement in Create page. During update, it is required to get name based on ID. Users need to see name and not ID. Let me know if anyone has done it in past or has any idea to get it done.

    Thanks.

  • 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