Posts

Posts

  • Sridhar Yerram
    Error While Configuring Oracle DBaaS Connection1
    Topic posted Yesterday 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 Baig, 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
  • 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 in Integration > Integration public
    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!

  • 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 in Integration > Integration public
    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.
    
  • Arunkumar
    Oracle DBaaS Adopter to ATP Adopter MigrationAnswered105.0
    Topic posted August 6, 2019 by ArunkumarRed Ribbon: 250+ Points, tagged Adapters, Database in Integration > Integration public
    Title:
    Oracle DBaaS Adopter to ATP Adopter Migration
    Summary:
    Oracle DBaaS Adopter to ATP Adopter Migration
    Content:

    Hi All,

     

    We are in the process of Upgrading the Classic Database to ATP Cloud Service. In this DB, we have an OIC Integrations Tracking tables.

    Now we have connected to ATP through ATP adopter. change in the adopter requires all integration to be rebuilt.

    Is there any alternative solution to migrate the integration without changing the mapping for the Oracle DBaaS adopter to ATP adopter?

    Thanks in Advance.

    Arun

     

     

    Version:
    Autonomous Oracle Integration Cloud Service
  • Katsushi Kagami
    Using Integration Service with Azure and Aws
    Topic posted October 24, 2019 by Katsushi Kagami, tagged Cloud, Connection, Database, SOACS in Integration > Integration public
    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:
  • Jaeyshree Kumaran
    Remove trailing zerosAnswered2
    Topic posted October 8, 2019 by Jaeyshree KumaranRed Ribbon: 250+ Points, tagged Adapters, API, Connection, Database, Integration, Orchestration, PaaS, REST, Web Services, xml in Integration > Integration public
    Title:
    Remove trailing zeros
    Summary:
    Remove trailing zeros of number
    Content:

    Hi,

    I have my input text as 0000001780936400. I should remove leading and trailing zeros in the number and the result should be as 17809364. I removed the leading zeros using number() fn. Please suggest a way to remove trailing zeros

  • 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 in Integration > Integration public
    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 in Integration > Integration public
    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: