Integration
Discussion List
-
has anyone integrated project numbers to general ledgerSummary: Our implementer created a segment in the COA for project number. Since go live, we've had to maintain that in the COA. Content (please ensure you mask any confi… -
500 server error while calling inventory API inventoryCompletedTransactionsSummary: Hi, I am trying to call following Oracle Fusion Inventory API but it is giving error 500 Internal Server Error in postman, /fscmRestApi/resources/11.13.18.05/in… -
Sequential Processing of Inbound MessagesSummary: Hello, for a business requirement, we need to process received messages 1 by 1 for a specific integration, so we need to process them sequentially and not in pa… -
How to get unique values from a column using OICWe are trying to read a file and convert it into a FBDI file so that it's loaded into Oracle Fusion. Our Initial file will look like below Name City Country Phone Suki M… -
Operation submitESSJobRequest API 11.13.18.05/erpintegrations in CSV output formatSummary: Hi experts, I have a postman test in order to submit a ESS job for "General Ledger Trial Balance report". By default this ESS job generate output file in PDF fo… -
Data got corrupted while processing through stage file segments actionHello All, Using Opaque schema we are converting the BIP encoded file into text data and storing in memory using stage file action. We are reading using stage file - rea… -
Common Decryption Encryption ServiceSummary: Hi Team, We want to build one common service that: Decrypts a file using a specific boundary application key. Encrypts the same file using a different set of PG…Abhilash K - Deloitte USI 15 views 0 comments 0 points Started by Abhilash K - Deloitte USI Integration -
List folders from OIC SFTPSummary: I want to get all folders in OIC SFTP (not files). i.e Root folder, it's subfolder, it's sub sub folder . How to get the same using integration? Content (please… -
Can OIC detect files in SFTP folder?I created an app driven event that detects files on our local server where a connectivity agent is installed and it works. I want to do the same but this time detect a f…
-
I have connection reset issue when doing a Merge operation in SQL Server tableSummary: I have an integration that extract data from Fusion and loads the data into SQL server table. I can insert a new record or update an existing record in the SQL …
-
EPM Integration Agent On-Premise FileHi All, We have created an integration using On-premise file Data source as source application and when tried to run the integration is failing with below error. 2025-10…
-
EPM integration agent multi period import from on-premise file to data exchangeHi All, I am trying to do multi-period load using On-Premise File Data Source Application, but getting below error when it is trying to import dat file. Application Sub …Prem Siva Kumar Reddy Rami Reddy 21 views 4 comments 0 points Most recent by NarayananS EPM Platform and Freeform
-
Non-SSO Login for OIC UISummary: We have an audit requirement to track production activities with certain roles. Our tracking software requires a local login screen with username/password rathe…
-
Another user has changed the row with primary key oracle.jbo.Key AttributeSummary: Another user has changed the row with primary key oracle.jbo.Key Attribute Content (please ensure you mask any confidential information): Hi Experts, I oftenly …
-
How to enable Oracle managed DR in OIC Gen3.Summary: Requirement is to enable oracle managed DR in OIC Gen3. But unable to find DR option while provisioning OIC instance. Did the process change? What are the steps…
-
Turn a Comma Separated string into multiple parametersSummary: I have an API that takes 1 or more query parameters called base. These appear in the URL as ?base=GBP?base=USD?base=EUR for example. I want my integration to ta…Scott Hillier Accelalpha 43 views 8 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Issue with "Enable Localization System Options" (empty dropdown in the UI).Hello, We are trying to enable Global Descriptive Flex fields GDF for testing purposes. Specifically Malaysia. Our understanding is that to use GDF country specific loca…
-
Strengthening Oracle Integration Security: Automating Password Rotation in IDCSIntroduction In modern enterprise environments, Oracle Integration Cloud (OIC) acts as the central nervous system for data flow across SaaS and on-premises systems. Howe…
-
Error while invoking OIC REST API from POSTMANSummary: Hi Team, Iam facing issue while calling the OIC - Integration REST API from POSTMAN. It fails with error 401 unauthorized.
-
Certificates in Setting OIC3Summary: There number of certificates under setting >certificates in OIC. Need help in understanding what are these certificates. One of the certificate is set to expire…
-
OIC Multipart/Form-Data Attachment (CSV) Fails with 500 ErrorSummary: I am using OIC to send data out to another system which accepts Multipart/Form-Data. It works fine in Postman but error out in OIC. I have followed documentatio…
-
Convert CSV string to Array in Mapping - create-nodeset-from-delimited-string ?Summary: I've got an API which requires an array of string into a parameter called base. I want to use a Comma Separated Value passed into my integration which I convert…Scott Hillier Accelalpha 21 views 3 comments 0 points Most recent by Scott Hillier Accelalpha Integration
-
"There is no RPA flow in the Project". Cannot see RPA BOT in dropdown list to call from IntegrationSummary: We have created a RPA bot in the project and its in activated state. However when we try to configure, to call it from Integration we cannot find it in the list… -
Excluding whole rows from being staged based on certain criteria - mapper?Summary: In OIC Gen 3 I have the response from an API call being mapped directly to a stage file write. So ALL the rows returned are immediately written. I want to exclu…
-
can we use private endpoint of OIC gen3 used to connect to atp database in private networkSummary: can we use private endpoint of OIC gen3 used to connect to atp serverless database in private network without using OIC agent to connect to atp database. Conten…
-
When attempting to load grade rate through HDL, some error are occured.Summary: When attempting to load grade rate through HDL, following Error was thrown: Error 1:An error occurred. To review details of the error run the HCM Data Loader Er…
-
Translation to native failed. Element 'EnteredDebitAmount' not expected..Hi Expert, I am creating integration for bulk data import to journal import, while running integration getting following error. Error Summary: oracle.fabric.common.Fabri… -
OIC mapping based on a source fieldHi All, Source XML is in a repeating group but target structure is flattened as per below I have tried to use…. IF role = 'remitTo' then map name to IF role = 'shipTo' …
-
Getting permission issue while opening the task in OPA even with adminSummary: Hi Experts I'm assigned to the group in IAM which is attached as admin for OPA instance, but when i try to open the task to see the deatils in the workspace tra…
-
Oracle Integration Administrative API to stop or start an OIC instanceI want to be able to stop (an start) a DEV/TEST OIC Gen 3 instance using the Oracle Integration Administrative API; initially using POSTMAN but eventually from an integr…