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
-
Stage file Write operation is not recognising new line character from string variableSummary Stage file Write operation is not recognising new line character from string variableContent Hi All, I have requirement to read CSV file from UCM and send data i… -
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…
-
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…
-
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. …
-
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 …
-
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… -
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 …
-
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…
-
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…
-
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…
-
Query parameter concat value is not being appended to the REST URL after upgrading OIC Gen2 to GEN3We recently migrated from OIC Gen2 to Gen3, and one of our integrations uses a REST API to connect with Oracle Cloud Infrastructure (OCI) to get users. When we pass valu… -
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…
-
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…
-
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… -
Is there a way to export out of office setting from Oracle CX Cloud and import it in Oracle PCS?Summary: User's are looking for a option to export the OOO setting that is configured in Oracle CX to be imported in Oracle Gen 2 - Process, please let us know if this p…
-
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…
-
Error in Supplier Bank Account PayloadHi, Payload:{ "CountryCode": "GB", "BankAccountNumber": "93896412", "BankBranchName": "121199-LONDON", "BankName": "HSBC", "CurrencyCode": "GBP", "AccountType": "SAVINGS… -
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 …
-
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…