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
-
How to invoke a custom Process Cloud Service" custom flow while submitting a requisition for approvaSummary: How to invoke a custom Process Cloud Service" custom flow while submitting a requisition for approval ? Content (please ensure you mask any confidential informa… -
OIC- Map empty json sub-node set to csvHi, I have the requirement to map input json data to csv output. In the input data we have Courses and for each course, we have a liste of existing sessions planned for …
-
Adding query parameter to a dynamic rest uri in OICSummary: we want to know how we can add query parameter to a external dynamic rest uri in rest adapter in OIC Content (please ensure you mask any confidential informatio…
-
Is it possible to see from which IP address an integration has been invokedIn the monitoring I can see the calls that have come in and the payload send by the calling system. Currently we are getting a lot of invokes, but they all fail and I ne… -
How to use worker rest api effective-ofSummary: Use of Worker Rest api to fetch workrelationship and assignment information for a particular effective date Content (please ensure you mask any confidential inf…
-
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…
-
OIC - Gen2 to Gen 3 Migration(Instance ID change from integer to string)Summary: This is regarding Gen2 to Gen3 Migration. In one of the pre-requisites there is point mention that Instance Id change from integration to String. Content (requi…
-
convert json to csvSummary: Hi, I 'm getting data fom an external REST API which retrieves data in Json format and I want to load them into a csv file. I added the input Json file into att…
-
default template for OIC notificationSummary: HI team we are writing many integrations and almost all of them finished with notification to some one's. and every time we need to insert data to FROM,BODY i.e…
-
What is the best practice to encrypt the files in Object Storage using OICSummary: There are couple of way to send a encrypted file in object storage. One is PGP encryption/decryption. One is using OCI Vault encrypt a file and send it to Objec… -
help with sample OIC integration to download/upload BIP report artifactsSummary: Please help with sample code to download BIP report artifacts like catalog, templates .. etc Please help with sample code to upload BIP report artifacts to anot…
-
OIC Message Pack - Compressed or uncompressed filesSummary: We are trying to determine how message pack unit usage is calculated? Documents indicate that it is in 50kb increments. If a file is loaded in a compressed mann…
-
How to keep track of children job statuses within the parent integrationHi all, I'm trying to have a main parent integration that then calls two other integrations within it. Since OIC doesn't let you schedule jobs after another, we are crea…
-
Invoke ERP Adapter- Receive requests from ERP Cloud Applications (Groovy scripts or Business Logic)Summary: Invoke ERP Adapter- Receive requests from ERP Cloud Applications (Groovy scripts or Business Logic). Any sample Integration using the above feature. Content (pl…
-
Using Expressions with AssignVars in an IntegrationHi Gurus Cannot find the IF or CASE function in list of functions, how can you simulate a condition ? tks Russell
-
How to use encodebase64reference function for more than 10 mb dataSummary: How to use encodebase64reference function for more than 10 mb data Content (please ensure you mask any confidential information): Hi experts, I am facing an iss…
-
can I create OIC instance in domain replication regionHi Experts, please advise, I'm in process of creating OIC instance under compartmentA and test domain. For test domain, home region is Germany Central (Frankfurt) and re…
-
Migrate the integration from one Project to AnotherSummary: We are using OIC Gen 3. Oracle is recommending that we use projects for better management. I created a project and created an integration inside the project. No…
-
How to get status of approver if i have 3 approvers for human taskSummary: Hi Experts I'm using OIC gen 3 Process automation, In my process i have added human task with 3 approvers to take action in sequence in same human task, here my…
-
how to make table scrollable in UI web form in oracle process automation version 3Summary: Hi Friends , I have drawn a table in my UI form in the PCS version 3 , but the table have multiple columns , I need to make the table scrollable so that the use…
-
sum function with big decimals numbersSummary: Hi, We have a validation in gl rates Integration for checksum of all the rates in the source file. But since gl rates have longer decimal values upto 40 decimal…
-
How to handle Source Null value in MapperSummary: Hi If i don't have any value in Expiry date column from source side then I want to remove this element from payload. How can we achieve this ? Content (please e…
-
TRANSLATION-ERROR-01# exception occurred while translating the response into the accepted media typeSummary: Hi While creating sample OIC i am getting below error. I am simply doing division of 2 numbers . please find screenshot for reference. { "type" : "10.5.3", "tit…
-
Sample OIC integration using DB package with plsql table type as in and out parametersSummary: Sample OIC integration using DB package with plsql table type of records as in and out parameters please share the DB package as well Thanks Content (please ens…
-
I want to get list of OPA tasks on behalf of a user who is accessing my VBCS page using OPA REST APISummary: Hi Experts I have created a page with which users can check the list of tasks assigned to them but the problem here is the authentication method for OPA REST AP…
-
Sample OIC integration using FINDER option ( instead of q) in REST apisSummary: Sample OIC integration using FINDER option ( instead of q) in REST apis for ex /fscmRestApi/resources/11.13.18.05/cashBanks in the query parameter , finder is o…
-
Call Oracle Fusion SOAP WS (ReceiveOrderRequestService) from OICSummary: Call Oracle Fusion SOAP WS (ReceiveOrderRequestService) from OIC Content (please ensure you mask any confidential information): I would like to call ReceiveOrde…
-
How to Connect SnowFlake DB in OICSummary: Not able to connect to SnowFlake from OIC DB adapter, Does Oic Support. Content (please ensure you mask any confidential information): Version (include the vers…
-
Create Requisition line REST API ErrorSummary: when invoke create Requisition line rest Api : /fscmRestApi/resources/11.13.18.05/purchaseRequisitions/300000902868669/child/lines from OIC3 got following error…
-
OIC stage file write operation to get md5 checksum is not workingSummary: Hi Team, We have an OIC integration that is receiving a file as binary attachments, we have a requirement to validate the checksum of the file, so we are writin…