Database
Discussion List
-
how can we read the data of pdf file from Stage File ReferenceSummary we have Base64Encode value of pdf file and we have to store those pdf file into AWS s3 bucket.Content Hi, we have Base64Encode value of pdf file and we have to s…
-
Select records in Batches from DB.Content We have a requirement to pull records from DBCS. The data/volume is very high and its required to pick records in batches. Example we have 200K rows of data in a…
-
Deploy NodejS AngularJs with Mysql on Compute InstanceContent Hello, i have an application, done with nodejs Angularjs and Mongodb and i want to deploy it on oracle. But i want to deploy it on my compute instance and have a…User_2025-02-08-04-00-49-804 13 views 0 comments 0 points Most recent by User_2025-02-08-04-00-49-804 Integration
-
How can we Store PDF file in AWS S3 using OIC REST ADapterSummary we have requirement for file should stored in S3 as pdf fileContent HI, we have requirement for file should stored in S3 as pdf file we have s3 rest url awsXXXXX…
-
Error IN/OUT Paraamter in DBaaS adapterContent Hey, I'm using a dbaas adapter to perfom a query on a database. I will get this error currently: Error message is - DBReadInteractionSpec Execute Failed Exceptio…
-
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…
-
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…
-
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…
-
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…Hemen Shah-90655 64 views 7 comments 0 points Most recent by User_2025-02-06-07-13-00-563 Integration
-
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…
-
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…User_2025-02-05-14-51-55-798 63 views 6 comments 0 points Most recent by User_2025-02-05-14-51-55-798 Integration
-
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…
-
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…User_2025-01-31-15-27-19-928 37 views 10 comments 2 points Most recent by User_2025-01-31-15-27-19-928 Integration
-
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 …User_2025-02-05-11-44-44-738 33 views 9 comments 1 point Most recent by User_2025-02-05-11-44-44-738 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…User_2025-02-05-09-32-34-013 36 views 3 comments 0 points Most recent by User_2025-02-05-09-32-34-013 Integration
-
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, …User_2025-02-05-11-44-44-738 20 views 0 comments 2 points Most recent by User_2025-02-05-11-44-44-738 Integration