Posts

Posts

  • Abhinav Kumar
    Integration3
    Topic posted September 28, 2019 by Abhinav KumarRed Ribbon: 250+ Points, tagged Database, Integration in Integration > Integration public
    Title:
    Integration
    Content:

    I have to update the a staging table with the values from the input file. I  have to run the following query in AIC.

    UPDATE staging_table
        SET active_flag = :active_flag
           ,last_update_date = SYSDATE
           ,last_updated_by = :user_name
      WHERE target_value1 = :target_value1
        AND NVL(active_flag,'Y') <> :active_flag
        AND NVL(target_segment1, 'DEFAULT') = NVL(:x_segment1, 'DEFAULT')
        AND NVL(target_segment2, 'DEFAULT') = NVL(:x_segment2, 'DEFAULT')
        AND NVL(target_segment3, 'DEFAULT') = NVL(:x_segment3, 'DEFAULT')
        AND NVL(target_segment4, 'DEFAULT') = NVL(:x_segment4, 'DEFAULT')
        AND NVL(target_segment5, 'DEFAULT') = NVL(:x_segment5, 'DEFAULT')
        AND NVL(target_segment6, 'DEFAULT') = NVL(:x_segment6, 'DEFAULT')
        AND NVL(target_segment7, 'DEFAULT') = NVL(:x_segment7, 'DEFAULT')
        AND NVL(target_segment8, 'DEFAULT') = NVL(:x_segment8, 'DEFAULT')
        AND NVL(target_segment9, 'DEFAULT') = NVL(:x_segment9, 'DEFAULT')
        AND NVL(target_segment10, 'DEFAULT') = NVL(:x_segment10, 'DEFAULT')
        AND NVL(target_segment11, 'DEFAULT') = NVL(:x_segment11, 'DEFAULT')
        AND NVL(target_segment12, 'DEFAULT') = NVL(:x_segment12, 'DEFAULT')

    I am using a DB adapter in the AIC, to run this query and giving this query in AIC.

    UPDATE staging_table
        SET active_flag = #active_flag
           ,last_update_date = SYSDATE
           ,last_updated_by = #user_name
      WHERE target_value1 = #target_value1
        AND NVL(active_flag,'Y') <> #active_flag
        AND NVL(target_segment1, 'DEFAULT') = NVL(:x_segment1, 'DEFAULT')
        AND NVL(target_segment2, 'DEFAULT') = NVL(:x_segment2, 'DEFAULT')
        AND NVL(target_segment3, 'DEFAULT') = NVL(:x_segment3, 'DEFAULT')
        AND NVL(target_segment4, 'DEFAULT') = NVL(:x_segment4, 'DEFAULT')
        AND NVL(target_segment5, 'DEFAULT') = NVL(:x_segment5, 'DEFAULT')
        AND NVL(target_segment6, 'DEFAULT') = NVL(:x_segment6, 'DEFAULT')
        AND NVL(target_segment7, 'DEFAULT') = NVL(:x_segment7, 'DEFAULT')
        AND NVL(target_segment8, 'DEFAULT') = NVL(:x_segment8, 'DEFAULT')
        AND NVL(target_segment9, 'DEFAULT') = NVL(:x_segment9, 'DEFAULT')
        AND NVL(target_segment10, 'DEFAULT') = NVL(:x_segment10, 'DEFAULT')
        AND NVL(target_segment11, 'DEFAULT') = NVL(:x_segment11, 'DEFAULT')
        AND NVL(target_segment12, 'DEFAULT') = NVL(:x_segment12, 'DEFAULT')

     

    But I am getting error while running.

  • Venkat Ramakrishnan
    JCS-SaaS Extension / APEX DB Connectivity from Java using...2
    Topic posted September 27, 2019 by Venkat RamakrishnanRed Ribbon: 250+ Points, tagged ADF, Database, JDeveloper in Application Development > Java public
    Title:
    JCS-SaaS Extension / APEX DB Connectivity from Java using JNDI
    Summary:
    JCS-SaaS Extension / APEX DB Connectivity from Java using JNDI
    Content:

    Hello,

    I am trying to connect to JCS-SaaS extension/APEX DB from a Java program using JNDI. I referred to the blog with link https://blogs.oracle.com/saaspaas/using-database-objects-in-a-java-cloud-application. This blog is mentioned in Oracle Support note 2418002.1. I am getting an error "Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial". Can anyone please tell me how to connect to JCS-SaaS Extension/APEX DB from a Java code using JNDI alias?

    Thanks,

    Venkat Ramakrishnan

  • Digvijay Chauhan
    OIC connection to Database VM on Cloud45.0
    Topic posted September 27, 2019 by Digvijay ChauhanBronze Trophy: 5,000+ Points, tagged Adapters, Cloud, Database, Integration in Integration > Integration public
    Title:
    OIC connection to Database VM on Cloud
    Summary:
    Multi tenancy connection
    Content:

    Hi All,

    I have OIC in one Cloud tenant and Oracle databse VM on different Cloud tenant. Both of them are in OCI bit on different tenants, What would I need to establish a connection from OIC to Database and vice-versa.

    Thanks

    Dvi

  • 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 in Application Development > Visual Builder public
    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 in Application Development > Visual Builder public
    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 in Application Development > Visual Builder public
    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 in Application Development > Visual Builder public
    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
  • Digvijay Chauhan
    OIC Timeout connecting to Database on Cloud5.0
    Topic posted September 11, 2019 by Digvijay ChauhanBronze Trophy: 5,000+ Points, tagged Adapters, Agent, Database, Integration in Integration > Integration public
    Title:
    OIC Timeout connecting to Database on Cloud
    Summary:
    OIC Timeout connecting to Database on Cloud
    Content:

    Hi All,

    I have heard new DB adapter is being rolled out that won't need an agent to be installed on Cloud DB, Does that mean that DB agent timeout of 240 seconds won't be valid going further?

    Have any have tried this new DB adapter?

    Thanks

    Dvi

  • 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 in Application Development > Visual Builder public
    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:
  • Nirmal Kumar
    How to catch the error message in response of Fault Details2
    Topic posted August 20, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged API, Cloud, Database, E-Business Suite, Integration, REST in Integration > Integration public
    Title:
    How to catch the error message in response of Fault Details
    Summary:
    How to catch the error message in response of Fault Details
    Content:

    Hi All,

    I had an unhandled error in one of my integration. Please see the highlighted in my attachment.

    I want to capture the exact error message coming in the response of Fault and store it in a custom table. Is it possible to extract the message detail from response under error handling? Please advise.

     

    Thanks,

    Nirmal

    Document: