Posts

Posts

  • Rahul L
    Capture values in comma separated, selected from Select...
    Topic posted 12:36 PM by Rahul LGreen Ribbon: 100+ Points, tagged Composite Component, Custom Code, Database, JET, Layout, Style, UI, Validation in Application Development > Visual Builder public
    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
  • B Carson
    Read File in Segments to REST Service insert to ATP database6
    Topic posted November 15, 2019 by B Carson, tagged Database, Integration, Mapping, Orchestration, REST in Integration > Integration public
    Title:
    Read File in Segments to REST Service insert to ATP database
    Summary:
    Read File in Segments to REST Service insert to database results in all rows written in each segment read
    Content:

    I have a very large file to import to my integration.  I am using FTP download and then Stage Read File in Segments to access the data that will be inserted into a database table in our Cloud ATP Oracle database.  The REST call is set up to utilize Batchload in order to post the 200 rows that each read in segment will pull.

    The result is that for each read, All rows in the inbound file are written to the database.  I believe the problem is in the way the elements are defined but cannot see that actual problem.  I am very new to OIC and am learning on the fly.  Any assistance will be appreciated.

    iar is attached.

    Version:
    19.3.3.190924.1600-31522
    Image:
    Document:
  • Priyanka Mishra
    Perform On Table - Select operation is not working as...4
    Topic posted November 27, 2019 by Priyanka MishraGreen Ribbon: 100+ Points, tagged Adapters, Database, Integration, Mapping, PaaS, xml in Integration > Integration public
    Title:
    Perform On Table - Select operation is not working as expected
    Summary:
    Perform On Table - Select operation is not working as expected
    Content:

    Hi ,

    I am trying to fetch data from two tables. I am doing it with "Perform operation on table " option with select operation. 

    Problem is it's always fetching the child table data for 1st parent table record. For other Parent table records, I am getting child table data as blank.

    Data is available in the table.

    Attaching a sample file. invBalanceTxnsLotIntCollection_2 is coming as NULL for snapshotId '60509'. Data is availble in child table.

     

    Thanks,

    Priyanka

     

    Is there any setting needs to be done while configuring t he DB adapter? Kindly provide your inputs.

     

     

    Document:
  • Stephanie Leung
    Security questions on VB and DBCS connectivity
    Topic posted November 25, 2019 by Stephanie Leung, tagged Database, Security in Application Development > Visual Builder public
    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
  • 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

  • sandeep karanth
    Invoice Extraction using EBS2
    Topic posted November 20, 2019 by sandeep karanth, tagged Adapters, Connection, Database, E-Business Suite, Integration, REST, SOACS in Integration > Integration public
    Title:
    Invoice Extraction using EBS
    Summary:
    What are the ways Invoice can be extracted using EBS in OIC
    Content:

    What are the ways Invoice can be extracted using EBS in OIC.

    i know using Business event is an option apart from this do we have any other way we can extract invoices please share your thoughts 

  • Sumanth Kunimakki
    Can OIC consume BLOB or CLOB2
    Topic posted November 14, 2019 by Sumanth KunimakkiGreen Ribbon: 100+ Points, tagged Adapters, Cloud, Database, Integration, PaaS in Integration > Integration public
    Title:
    Can OIC consume BLOB or CLOB
    Summary:
    DB Adapter is invoking a PL/Sql Procedure which is returning CLOB/BLOB as out parameter, Can we consume the same in OIC.
    Content:

    DB Adapter is invoking a PL/Sql Procedure in DBCS which is returning  CLOB/BLOB as out parameter, Can we consume the same in OIC.

  • Sridhar Yerram
    Error While Configuring Oracle DBaaS Connection1
    Topic posted November 12, 2019 by Sridhar YerramRed Ribbon: 250+ Points, tagged Connection, Database, Integration in Integration > Integration public
    Title:
    Error While Configuring Oracle DBaaS Connection
    Summary:
    Error While Configuring Oracle DBaaS Connection
    Content:

    Hello,

    Iam getting the below issue, while configuring the Oracle DBaaS connection.

    Unable to test connection "ORACLEDBAASCONN". [Cause: CLOUD-0005]

    • CLOUD-0005 : Unable to establish connection. Please check connection parameters
    • Network Adapter could not establish the connection. Please check the wallet credentials and ensure database is reachable.

    Pl

     

    Please let me know what is the reason and how to rectify this issue.

    -Sridhar 

    Image:
    Document:
    DBaaS2.PNG (27KB)
  • 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 in Application Development > Visual Builder public
    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

  • Karthick S
    How to join two tables in vbcs?5
    Topic posted July 23, 2019 by Karthick SRed Ribbon: 250+ Points, tagged Business Objects, Database in Application Development > Visual Builder public
    Title:
    How to join two tables in vbcs?
    Content:

    How to create realationship in BO between two Tables.

    For example: 

    I have two tables.
     Employee Table.  Primary Key: Request_Num
     Course Reference Table. Foreign Key: Request_Num
     
     Common column in both tables: Request_Num
     
    I want to create relationship between two tables based on Request_Num.

    Version:
    19.1.3