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… -
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…
-
Efficiently Handling DB Insert/Update Activity in OIC w/ No Response PayloadSummary DB Insert/Update Operations in OIC don't have a RESPONSE Payload confirming if the operation successfully applied to the DB, requiring special handling.Content H… -
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… -
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…
-
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…