To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Integration
Discussion List
-
ESS Job failingSummary: Hi I am trying to submit ESS job from OIC, but it is failing. Content (please ensure you mask any confidential information): Version (include the version you ar… -
Using OIC to get files from Oracle database as BLOB or from file systemSummary: We have a requirement to fetch files stored in Oracle database blob column and save to another application. Content (please ensure you mask any confidential inf…
-
Duplicated error when zipping fileHi all, I'm facing an issue in the OIC Gen3 24.08. When the code will zip the folder with the CSV files to load into Cloud (in FBDI format), the code failed and return t…
-
Common Alert if any of the Integration is erroring more than 10 times.Summary: We want to have a common alert OOTB which can trigger a notification if there is an error on any one of the integration for more than 'n' number of times (eg: 1…
-
Stage File Action Error occurred while processing activity stageWritesf0.Summary: We had a StageFile action to write a file and it was working fine in OIC Gen 2 (and lower environment of OIC GEN3 when we tested it). When our production OIC in… -
Xslt 2.0 to remove duplicates in oicSummary: What is the fastest possible way to use in xslt 2.0 in oic gen 3 to remove the duplicates from the file size of 17 MB? I have used for-each-group function to re…
-
Identify OIC connections to ATP database using unexpected database serviceSummary: We have hundreds of OIC flows that connect to our ATP database. We only have 1 OIC connection defined to the database, and it is using the service "_tp". Howeve… -
How to enable OAuth 2.0 in OIC Gen3? What roles are needed to make this work?Summary: We are trying to enable authentication using OAuth2.0 in our Gen3. We wanted to have individual tokens for each of our Boundary Systems (BSYS). Our PaaS team ap… -
GEN3 update ftp connection with REST apiSummary: Hi all, I would thank any help with the following. I have seen the doc. to update connections using REST. I have seen how to modify user/pwd, as shown. My quest…
-
How to process more than 1000 feeds from OIC HCM Adapter Atom FeedSummary: We have a requirement to process more than 1000 feeds for a single run through HCM Adapter Atom feeds. But in the HCM Adapter under Max entries to process list …
-
unable to edit the integrationSummary: Hi Experts I'm seeing a strange issue in integration where i'm unable to edit the actions in the flow even i enter the integration in edit mode as shown below. …
-
How to use Bulk Import option in Snowflake adapter in OICSummary: I am trying to load bulk data into Snowflake tables from Fusion using OIC, I see in the documentation we have an option to bulk import data using internal or ex…
-
Running vacation rule report via OICSummary: We are trying to run the EmployeeVacationAndDelegationRulesReport via OIC and getting the following error from the SOAP adapter. We want to extract the data fro…
-
Failed to obtain DT URL. Response code is 502. Error reported is Bad Gateway.Error messageSummary: We upgraded our production OIC instance from GEN 2 to GEN 3. We reinstalled a new connectivity agent (binaries) and InstallerProfile.cfg file from gen 3 instanc…
-
Switch from ATP Adapter to DBaaS adapterSummary: Is there an easier way to change the connection in the integration canvas from ATP connection to a DBaaS Connection? We have about 12 integrations that are now …
-
Best Practices for Scheduling Integrations in OICSummary: We aim to create a real-time integration between HCM and Active Directory so that any involuntary termination in HCM with "Revoke Access" set to "Immediately" i… -
Issue while fetching REST API dataSummary: Hi We have lookup code like "6002LC10262/2026" in fusion. Get - /fscmRestApi/resources/11.13.18.05/commonLookups/{LookupType}/child/lookupCodes When i am trying…
-
Are there available business events for creation/modification of key flexfield values?Summary: Are there available business events for creation/modification of key flexfield values? Content (please ensure you mask any confidential information): Version (i…
-
Salesforce Adapter OAAuth2Summary: Hi Team, we are configured the OIC Salesforce adapter as below documentation and everything seems to be ok. Oracle also confirmed same on configuration. However…
-
We are facing an issue where the OIC integration is failing to activateSummary: We are facing an issue where the OIC integration we built to import OTL time entries into HCM Cloud is failing to activate with the below error. There were no c…
-
How to get authentication token used to invoke the integrationSummary: Hi Experts Is there a way to get the authentication token of user used to invoke the integration, as i need this to pass to other service while calling i.e. pas…
-
how to replace schema name in db procedure invocation in OIC GEN3Summary: We have a requirement where the schema name need be changed when we move the code from Non-prod to prod instance. Please let us know how the schema name change …
-
How to Get UCM File Details By Bi ReportInfo in Soap Web ServicesI Ran Bi Report in Oracle Fusion The delivery channel is UCM later i want to get that report file from ucm by passing inputs as Bi Rpeort Details Like Report Name, Path …
-
ERP OIC Callback Error - TBA Token Received In FA EHF Callback Request Is Not ValidSummary: We have a Receive Callback Message upon completion of FBDI bulk Import Job in OIC which stopped working after we migrated to Cloud Console. We have allowlisted …
-
Error in Supplier Bank Account PayloadHi, Payload:{ "CountryCode": "GB", "BankAccountNumber": "93896412", "BankBranchName": "121199-LONDON", "BankName": "HSBC", "CurrencyCode": "GBP", "AccountType": "SAVINGS… -
in OPA want to proceed ahead if any one approver approves the taskSummary: Hi Experts In OPA if i'm selecting all assignee in parallel then i want the flow to proceed ahead if any one among the assignee approves the request. In my case…
-
does the api gateway on public subnet redirect route to the URL in private subnetSummary: In the OCI, I have a API service located in private instance on private subnet. But I would like to share this API to internet. Can I setup API gateway on publi…
-
Fetching Shipment information before Ship confirmSummary: So I have a requirement where I need to screen a shipment via a third party tool before having it is pick confirmed and ship confirmed. Currently I am planning …
-
Redshift connection in OICSummary: Currently, there is no standard Redshift connection in OIC. Is there a road map for this connection? Any other workarounds other than S3? Content (please ensure…
-
Updating IAR due to multiple ATP nodes affected by alphanumeric switchSummary: We are currently in the progress of an OIC Gen3 upgrade and essentially all of our integrations are affected by the instance ID switch from numeric to alphanume…