Database
Discussion List
-
DBCS cloud serviceSummary When you license DBCS cloud service do you get file storage and way to store in bound and outbound files ?Content We will be licensing OIC for Oracle Fusion SaaS…
-
Not able to update the status of a sales order via REST APISummary Getting Error when trying to update a status of an orrder via rest apiContent Hi , I am trying to change the status of a sales order using a rest api . (EndPoint…
-
Fusion HCM table which stores all the data present as part of .dat fileSummary Fusion HCM table which stores all the data present as part of .dat fileContent Hi, I need a HCM common tables name which stores all the data goes to HDL via .dat…
-
OIC REST Adapter Security as OAuth Resource Owner Password CredentialsSummary OIC REST Adapter Security as OAuth Resource Owner Password CredentialsContent I have configured REST Adapter connection Security as OAuth Resource Owner Password…
-
AQ Adapter (trigger) is not visible in inetgrationsSummary AQ Adapter (trigger) is not visible in inetgrationsContent Hi, I Created one AQ adpter with role as Trigger. When i am trying to configure in integration AQ Adap…
-
Oracle Database adapter showing error - The connection to the database has been refused.Summary The connection to the database has been refused. Please check connection parameters, ensure database is reachable and review the firewall.Content Hi, I have crea…
-
Unable to test connection "MYSQLCONNECT".Summary Unable to test connection "MYSQLCONNECT". [Cause: CLOUD-0005]Content Hi, i am trying to connect on-prem mysql db usign agent. i am getting below error. Unable to…
-
REST API Batch Processing To Create Multiple Records not workingSummary REST API Batch Processing To Create Multiple Records not workingContent HI Team, We have ingratiation between EBS(r12) to OEC, we have to do batch processing of …
-
OIC - Creating virtual primary key DB AdapterSummary OIC - Creating virtual primary key DB AdapterContent HI Team, I am trying to do a merge operation on a table(On Premise) which doesn't have any primary key const…
-
Error while translating message to native format.Summary Error while translating message to native format.Content Hi , I am trying to do write operation (CSV file) using the FTP adapter in OIC, I am getting below error…
-
Instance SchedulerSummary Does OIC have Instance SchedulerContent Hi Team, I am checking whether there is any instance scheduler to stop and start the OIC instances. I want to stop the OI…
-
How to call REST API using Http PATCH MethodSummary In Java how to call REST API (json) using http PATCH methodContent We have a requirement to update Planned orders in Cloud SCP from EBS. To update the planned or…
-
Ingest files to WebCenter Content WCC or UCMSummary How to override an existing content/file in WebCenter. any configuration?Content Scenario: we are using "GenericSoapPort" SOAP WebService to ingest files to WebC…
-
How to load large volume of CSV file to VBCS business object using OICSummary How to load large volume of CSV file to VBCS business object using OICContent I am developing inbound interface in OIC. I am going to get large volume of CSV fil…
-
Connectivity issue between SOACS and Pluggable DatabaseSummary We receive Resource Dead Exception for the Datasource that we use to connect PDB from SOACSContent Hi Team, We are connecting to Pluggable Database from SOACS. R…Arvind Mathivanan-171297 12 views 3 comments 0 points Most recent by Arvind Mathivanan-171297 Integration
-
Invoice Extraction using EBSSummary What are the ways Invoice can be extracted using EBS in OICContent What are the ways Invoice can be extracted using EBS in OIC. i know using Business event is an…
-
Read File in Segments to REST Service insert to ATP databaseSummary Read File in Segments to REST Service insert to database results in all rows written in each segment readContent I have a very large file to import to my integra…
-
Perform On Table - Select operation is not working as expectedSummary Perform On Table - Select operation is not working as expectedContent Hi , I am trying to fetch data from two tables. I am doing it with "Perform operation on ta…
-
Can OIC consume BLOB or CLOBSummary 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 P…
-
What's the difference of "For Each" action and adding for-each during mappingContent 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 paramete…
-
Oracle DBaaS Adopter to ATP Adopter MigrationSummary Oracle DBaaS Adopter to ATP Adopter MigrationContent Hi All, We are in the process of Upgrading the Classic Database to ATP Cloud Service. In this DB, we have an…
-
Using Integration Service with Azure and AwsSummary Connectivity with Azure and AWS with Oracle Integration CloudContent My customer is interested to Integration Service. They are considering to implement datalake…
-
Remove trailing zerosSummary Remove trailing zeros of numberContent Hi, I have my input text as 0000001780936400. I should remove leading and trailing zeros in the number and the result shou…
-
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…
-
Error Creating Connection for Oracle DBCSContent 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 connect…
-
Accessing Integration User Name in OrchestartionSummary Logged in user infromationContent Hi, Use Case: In ad-hoc run of scheduled integration I am populating a Database table and I also want to populate the username …Digvijay Chauhan-163068 23 views 9 comments 1 point Most recent by Digvijay Chauhan-163068 Integration
-
OIC connection to Database VM on CloudSummary Multi tenancy connectionContent 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 …Digvijay Chauhan-163068 17 views 4 comments 1 point Most recent by Vijayaragavan Ramasamy Integration
-
OIC Agent Installation - UnknownHostException from DbaaS serverSummary OIC Agent Installation - UnknownHostException from DbaaS serverContent We had followed https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/…
-
IntegrationContent 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 = :activ…
-
OIC Timeout connecting to Database on CloudSummary OIC Timeout connecting to Database on CloudContent Hi All, I have heard new DB adapter is being rolled out that won't need an agent to be installed on Cloud DB, …