Visual Builder

Get Involved. Join the Conversation.

Posts

  • 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 Red Ribbon: 250+ 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 Red Ribbon: 250+ 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 Red Ribbon: 250+ 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
  • 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

  • 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
  • shankar vonguri
    How to deploy VBCs app to Onprem server1
    Topic posted October 19, 2019 by shankar vonguri, tagged Business Objects 
    Title:
    How to deploy VBCs app to Onprem server
    Content:

    Hi,

    I have followed the below post for running VBCs app on other servers.

    https://blogs.oracle.com/vbcs/running-visual-builder-apps-on-other-servers-and-on-premises

    I am developing some POC  and need to try out in other servers

    I have used some business objects and Iam trying to provide rest endpoints for the same.

    Can i deploy this app in other servers as posted in the above forum.

    The above post is leveraging the cloud infrastructure in building the app using vb-build step.

    How do i build the zip to be ready to be deployed to Other servers  with out using that Infrastructure

     

    Please provide some pointers how this can be done to try out.