Visual Builder

Get Involved. Join the Conversation.

Posts

  • Digvijay Chauhan
    Insert data to database using VBCS excel Plugin3
    Topic posted Yesterday by Digvijay ChauhanBronze Trophy: 5,000+ Points, tagged Database, REST, Web 
    Title:
    Insert data to database using VBCS excel Plugin
    Summary:
    VBCS excel Plugin
    Content:

    Hi Experts,

    We have a requirement to insert data into database using excel(used by users). I am evaluating the option of using VBCS excel plug-In for the purpose. I have installed the Excel plugin and able to insert/update data into a business object in the VBCS. Can we also use the same approach to insert the data directly into Database table instead of business object?

    Another approach I was thinking if I create an OIC integration exposed as REST to do the actual insert to DB and VBCS excel plug-in to use OIC REST endpoint? Is that a viable option?

    What are other possible ways to achieve this?

    Thanks

    Dvi

  • Rahul L
    Capture values in comma separated, selected from Select...1
    Topic posted December 5, 2019 by Rahul LGreen Ribbon: 100+ Points, tagged Composite Component, Custom Code, Database, JET, Layout, Style, UI, Validation 
    Title:
    Capture values in comma separated, selected from Select Many Component
    Content:
    Hi, I am using a Select Many Component to select multiple values from LOV listed from Rest. Now i wanted to store the selected values in custom table with comma separated values. Can someone please help me with this. Thanks Rahul
  • Stephanie Leung
    Security questions on VB and DBCS connectivity
    Topic posted November 25, 2019 by Stephanie Leung, tagged Database, Security 
    Title:
    Security questions on VB and DBCS connectivity
    Summary:
    Security questions on VB and DBCS connectivity
    Content:

    We are planning to use the new feature VBCS to add tenant database on external DBaaS.  

    We had the below questions from a security and network perspective -
    a) The database should have a Public IP is a requirement. So does the communication between VBCS and DBaaS happen over Oracle backbone or public internet?
    b) The communication between VBCS and DBaaS is using JDBC. Does it use SSL in between?

    Version:
    19.1.3
  • Mohammed Baig
    Best approach to expose custom database...Answered4
    Topic posted October 31, 2019 by Mohammed BaigGreen Ribbon: 100+ Points, 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

  • Muralidharan Kanagaraj
    NoFields5
    Topic posted October 11, 2019 by Muralidharan KanagarajRed Ribbon: 250+ Points, tagged Business Objects, Custom Code, Database, JET, Validation 
    Title:
    Search Criteria for particular user?
    Content:

    Hi,
    We have developed an application in vbcs 
    When logged into the application using username and password in which we get details related to that employee
    We use business object to get table data, service data provider for filterCriteria.(Please find image for ref)
    We have a search page in our application. 
    When we give values for search criteria it works fine, but when we click button without
    giving any criteria all the data are fetched.
    We need only data related to that particular user.
     
    How to achieve this.

    Image:
  • 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:
  • Guy Lior
    List Pagination with custom REST endpointAnswered4
    Topic posted September 24, 2019 by Guy LiorBronze Medal: 1,250+ Points, tagged Custom Code, Database, Mobile, REST, Services 
    Title:
    List Pagination with custom REST endpoint
    Summary:
    List Pagination with custom REST endpoint
    Content:

    Hi,

    I have custom REST API that support limit and offset parameters for pagination.

    How to implement list pagination with SDP and custom REST endpoint using the transform javascript function?

    Do I have to implement also list scrolling event ?

    Any working example or document?

    Thanks

  • Vijayakumar Jayamani
    Whether VBCS can pull from any of database?Answered2
    Topic posted September 19, 2019 by Vijayakumar JayamaniRed Ribbon: 250+ Points, tagged Database, Web 
    Title:
    Whether VBCS can pull from any of database?
    Summary:
    Can we build custom form based on database data?
    Content:

    Would like to understand whether we can build custom application based on data resides in Database like Oracle Database, DB2, sql etc..

    Version:
    19.1.3
  • Shakila Murugan
    WSDL generate in VBCS application?3
    Topic posted September 16, 2019 by Shakila MuruganBronze Medal: 1,250+ Points, tagged Action Flows, Business Objects, Custom Code, Database, Services, Web 
    Title:
    WSDL generate in VBCS application?
    Content:

    Hi Team,

    We have developed an application in VBCS, in which we have business objects and we need to generate wsdl using that business objects data.

    How to achieve this?

    Thanks

    Version:
    19.1.3
  • Muralidharan Kanagaraj
    How to download uploaded file in button action?4
    Topic posted September 3, 2019 by Muralidharan KanagarajRed Ribbon: 250+ Points, tagged Business Objects, Custom Code, Database, UI 
    Title:
    How to download uploaded file in button action?
    Content:

    Hi All,

    We have file upload functionality in our VBCS page. 
    Uploaded file will be of in any format i.e (PDF, txt, Document, excel, image etc.) we show that file in table as shown in below image.
    We get the upoladed file as a link(URL) in a column and we display the link as a button for the good UI. When we click that button, that uploaded file gets downloaded.
    i.e when we click a button that uploaded file has to be downloaded.

    Is it possible to downolad the file in the same uploaded format?

    Thanks

    Version:
    19.1.3
    Image: