Orchestration
Discussion List
-
Oracle Integration Cloud 3: For-each repeating element is read onlySummary: Am I missing something obvious? When configuring a for-each loop in OIC 3, the field to configure a repeating element is read-only so I can't pass it any values… -
Use the replace or replace String functions to remove special charactersSummary: Hi everyone, I need to remove special characters from a string for example: "A.*BC(D E+FGH?/IJK L#M%&//#?¡'¡N~OP" I have tried to apply the functions without su… -
OIC Inconsistency in Extending Data TypesSummary OIC Inconsistency in Extending Data TypesContent Hello! We have an app-driven integration that invokes a "Publish to OIC" integration, and a Subscribe integratio…
-
Integration Error: Error in listing files in the remote directoryContent Hello! We encounter the following error when making FTP call (List Files operation) in one of our orchestrations. Anyone familiar or has encountered this issue b…
-
Search for text across and within OIC orchestrationsSummary: We would like to understand if there is a way to search text within an OIC (gen3) environment to find if any orchestrations might be hardcoding a particular val…
-
OIC: Import Trading Community Data in Bulk Process CallbackSummary: We are processing the Import Trading Community Data in Bulk job from the OIC with the callback option enabled. The job is triggering and completing correctly in…
-
How add multiple predicates in expresionSummary: How add multiple predicates in expresion Content (please ensure you mask any confidential information): Hi experts, I try to combine two predicates, it does not…
-
Filter information using predicates, when two or more nodes have the same keySummary: Filter information using predicates, when two or more nodes have the same key Content (please ensure you mask any confidential information): Hi experts, I'm wor…
-
OIC Mapper Error : Cannot read the array length because the return value of "oracle.cloud.connectorSummary: Hi Team, We wanted to pass the Nil true to mapper in oracle SF adapter. Below is the error receiving. Tried all options but it is not working. It is in OIC. Err…
-
Large volume file processing OICSummary: OIC Integration takes very long time to process (> 8 hours for 50k records in the input source file). Looking forward for suggestions or corrections to improvis… -
Best Practice for OIC to Cloud DB: DB Adapter or RESTful Services?Summary Better way to connect in Oracle DBCS from Integration Cloud (OIC/AIC)Content Hi, I'd like to hear your inputs as to which approach is better in terms of efficien… -
fetch refresh token in REST callSummary How to fetch refresh token in OIC REST callContent Hi All, We have configured REST OAUTH as Resource owner password credential with access token URI in connectio…
-
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…
-
ICS-10064 error when calling a stored procedure with the ADW adapterContent I'm having trouble invoking a stored procedure using the ADW adapter in a scheduled orchestration. My procedure is very simple: create or replace PROCEDURE proce…
-
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…
-
How to map multiple values of complex nodes using for each loops within data mappingSummary: I am using OIC version 3 Content (please ensure you mask any confidential information): I have an XML input in which I have complex nodes: I need write a CSV fi…
-
How to map a request value by filtering the information by the current value of a for eachSummary: Content (please ensure you mask any confidential information): Hi experts, I have an XML structure, I have created a for each on a certain node where I need to …
-
Item Update Event is not triggering upon applying filter conditionContent we are trying to capture Item Update business event in OIC with a specific condition. i.e capture only Master organization related events and neglect rest of the…
-
Approch to build the REST end Point For thired Party Integration in HCMSummary:We have requirement where we have to build the HCM API for the Client.Justed wanted to understand what kind of approch we have to follow Ex: The API inculdes 40+…
-
sending xml response for each fileWe are working on system integration using OIC for ERP. The third party system which will send a file on SFTP server (Oracle cloud based server) expects a XML response f…
-
Send data from OIC to https locationHi There, I need to send a response from OIC to the https location. Client provided the location (https://abccomp.com/getResp/receiveData.dll ) along with username, pass…
-
Async Stored Procedure Call from OIC through Oracle ATP AdapterSummary: Currently, we are having timeout issue (exceeding 240 seconds) when executing a Stored Procedure through ATP Adapter. I don't think there's any problem on the D…
-
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… -
Attaching PDFs to Multiple InvoicesSummary: Content (please ensure you mask any confidential information): Hi all, I am attempting to attach PDFs to multiple invoices (a one to one). The way things are se… -
List files OIC not workingSummary: NA Content (required): Hi Team, We were trying to list the files from a FTP server which is on Port 21 and observed that List files is not working and it is not…
-
OTBI Report to VBCS Rest Endpoint **SOLVED**Summary Extracted OTBI Report - map to POST to store in VBCS Business ObjectContent Hello, I've successfully extracted the contents of an OTBI Report from our ERP Cloud … -
AP Invoice business events filter expressionSummary AP Invoice business events filter expressionContent Hi, We are trying to filter out ap invoices using the below filter expression while using receive business ev…
-
Supported Business Events > Supply Chain Exec > Maintenance Management > Report Resource TransactionSummary: Supported Business Events > Supply Chain Execution > Maintenance Management > Review Maintenance Dispatch List > Report Resource Transaction Content (please ens…
-
Estimate End Time/Duration of a Scheduled IntegrationSummary: We have scheduled integrations that would process multiple files in a single instance. Is there a way we can identify the estimated end time/duration of the run…
-
How to schedule OIC integration to run every 10th business day of month?Summary: How can we schedule the OIC Integration for such complex run frequencies? 10th Business day of month (Eg. 8/14/2023, 9/14/2023, 10/13/2023) 23rd day of month wi…