Integration

Get Involved. Join the Conversation.

Posts

  • 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 
    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:
  • sandeep karanth
    Invoice Extraction using EBS3
    Topic posted November 20, 2019 by sandeep karanth, tagged Adapters, Connection, Database, E-Business Suite, Integration, REST, SOACS 
    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 

  • 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 
    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:
  • 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 
    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 
    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)
  • Gabriel G Huo
    What's the difference of "For Each" action and...6
    Topic posted October 28, 2019 by Gabriel G HuoBronze Medal: 1,250+ Points, tagged Adapters, Connection, Database, Integration, Mapping, Orchestration, PaaS 
    Title:
    What's the difference of "For Each" action and adding for-each during mapping
    Content:

    Hi experts,

    In integration we are reading one file which has multiple lines, after that we want to call a DB procedure for each line(line value as input parameter or procedure).

    One way is in integration we use For Each action and call the procedure within the loop

    The other way looks to be during mapping, add for-each(mapping readfile lines) at the top of procedure call request

    Will they behave the same? Is that the 1st one will call DB agent multiple times but the 2nd one will only call DB agent once?

    Suppose there are 20000 records from source file, which one would be better?

    The procedure here we want to use is to update one DB table based on the input records.

    Thanks in advance!

  • Katsushi Kagami
    Using Integration Service with Azure and Aws
    Topic posted October 24, 2019 by Katsushi Kagami, tagged Cloud, Connection, Database, SOACS 
    Title:
    Using Integration Service with Azure and Aws
    Summary:
    Connectivity with Azure and AWS with Oracle Integration Cloud
    Content:

    My customer is interested to Integration Service.

    They are considering to implement datalake in the company.
    They have a lot of data from multiple sources.
    The website or public information describes how to integration within Oracle Cloud. But in the multi-cloud era, the customer needs to think about other data source including Azure or AWS (using SQL Server or Redshift or S3 etc).

    I am not sure the integrity of the Service of these vendors.

    Code Snippet:
  • Arvind Mathivanan
    Connectivity issue between SOACS and Pluggable Database2
    Topic posted October 21, 2019 by Arvind MathivananBronze Medal: 1,250+ Points, tagged Cloud, Connection, Database, Integration, PaaS, SOACS 
    Title:
    Connectivity issue between SOACS and Pluggable Database
    Summary:
    We receive Resource Dead Exception for the Datasource that we use to connect PDB from SOACS
    Content:

    Hi Team,

    We are connecting to Pluggable Database from SOACS. Recently the PDB was upgraded to the latest version. From then, we see resource dead exceptions on the connectivity from SOACS. Support team tried reseting the connections, restarted the datasource, restarted the admin,managed servers.  The ACLs were also checked and made sure to be opened between SOA and PDB. I am able to connect to PDB seamless from outside SOACS.

    1. What could be the issue in this case in SOACS? 

    2. What are the admin related activities that you expect to be checked/done in SOACS whenever a pluggable database is upgraded?

    Error Received in SOA :

    Exception occurred when binding was invoked.
    Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: Could not create/access the TopLink Session.
    This session is used to connect to the datastore.
    Caused by weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection for datasource 'ErpSaaSExtnNonXA'. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection.
    You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server.  This exception is considered retriable, likely due to a communication failure.
    
  • Karthick R
    How to load overtime information into Oracle HCM?35.0
    Topic posted October 20, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, Database, Integration, Mapping, Orchestration, PaaS, REST, SOAP, Web Services, xml 
    Title:
    How to load overtime information into Oracle HCM?
    Summary:
    How to load overtime information into Oracle HCM?
    Content:

    Hi Everyone,

    I have a requirement to load overtime information of an employee from a 3rd party system to Oracle Fusion HCM.

    Can you point out any Oracle documentation or blog material that discusses about SOAP service or HDL or FBDI to load Overtime information into Fusion HCM?

    Regards,

    Karthick.R

  • Sridhar Yerram
    Error Creating Connection for Oracle DBCS4
    Topic posted October 12, 2019 by Sridhar YerramRed Ribbon: 250+ Points, tagged Connection, Database, Integration 
    Title:
    Error Creating Connection for Oracle DBCS
    Content:

    Hi All,

    Can you please guide me how to create a connection for Oracle Database Connection with DBCS.

    PFA Screenshot of the details entered while creating connecting, but it is giving the error as below : 

    The connection test failed. Check your connection and use agent from agent group.

    -Sridhar

    Image: