Integration
Discussion List
-
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… -
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… -
Unable to send an attachment in the notification Gen3Summary: Unable to send an attachment in the notification Gen3 Content (please ensure you mask any confidential information): Unable to send an attachment in the notific…
-
Business event is Not triggering in OICSummary: we have a requirement of capturing the business event payload when the Sales Order line status changed to 'awaiting Shipping'.. we have done required Setups in …
-
OIC - Is there any other option apart from agents to connect to on-premise database?Summary: OIC Connectivity option to on-premise database apart from agents Content (please ensure you mask any confidential information): Would like to know if we can use…
-
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…
-
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…
-
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 … -
Journal Callback in OIC Gen-3 is failingSummary: Journal Callback in OIC Gen-3 is failing Content (required): We have migrated our Journal Callback Integration from OIC Gen-2 to Gen-3. Callback is getting trig…
-
Instance name is not shown in GEN3 Service Console URLSummary: Instance name is not shown in GEN3 Service Console URL Content (please ensure you mask any confidential information): We have multiple OIC instances and it is r… -
Unable to setup OAuth in OIC Gen3 instanceSummary: After creating an OAuth application with Authorization Code, getting this error, when trying create a REST API Connection to OIC Instance. "{"error":"invalid_re…
-
OIC - Gen2 to Gen3 Migration QuestionsSummary: We are planning to migrate our existing OIC Gen2 version to Gen3. We have couple of questions . could you please help us with the same? Content (required): 1) W…
-
oic Gen-3 payload request received from trigger can use into integrationSummary: if I have an integration with a Rest Adapter trigger and as a request body I have a json, now I would like to be able to register on ATP the json that arrives a… -
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…
-
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…
-
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 …
-
Possible OIC 24.06 Bug GEN3Summary: Stop action not available. Content (please ensure you mask any confidential information): On a scheduled integration the stop action is available inside a switc… -
OIC Gen 3 Upgrade (Things to look out for)?Summary: Hi Experts, We have upgraded our non-production OIC instances from Gen 2 to Gen 3 (A few weeks now) with Production instance in exactly a week from today. We ha…
-
set ical scheduleSummary: Content (please ensure you mask any confidential information): I am trying to write an ical schedule where I am given a set schedule for the rest of the year. T… -
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…
-
xslt transformation logic to replace the xml element name/tag dynamicallySummary: xslt transformation logic to replace the xml element name/tag dynamically Content (please ensure you mask any confidential information): xslt transformation log…
-
CUPS server configuration in BIP & Webservice to invokeSummary: Hi Team, we have below requirement and need to understand. Can some one please help on this. The print server has been installed in Azure with the CUPS service …
-
Outbound Interfaces : Oracle API ApproachHi Team, As oracle suggested now not to use any BIP report approach for outbound interfaces. We are having below requirement and it includes different API's to be invoke…
-
UniversalConnectionPoolException Error for Database Connection on OCI ConsoleSummary: UniversalConnectionPoolException Error for Database Connection on OCI Console Content (please ensure you mask any confidential information): Hi Team, Greetings!… -
How to check the maximum number of OIC instances running simultaneously?Summary: I'm investigating an issue in OIC for our job that is queueing intermittently for some time before running. I need to know if there's any resource issue or if t…
-
Extracting the result returned from the service responseHello, the response returned from the REST service that I called within the integration I prepared in Oracle Integration Cloud is as follows. Here, I want to take each …
-
How to upload a new revision to UCM with the same content IDWe are integrating UCM and Oracle Fusion application[Sales] to upload and read files. We are looking out for a webservices[SOAP/REST] to upload the file to UCM where it …
-
ORABPEL-11101 - oracle.fabric.common.FabricInvocationException in stagefile Write operation in OICSummary: Error in Stage file Write operation in OIC Content (please ensure you mask any confidential information): Error Summary: oracle.fabric.common.FabricInvocationEx…