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
-
Import Journal Integration combining & loading zip files in 1 batch instead of individual filesSummary: Created an integration for FBDI files to load from FTP Server to OIC Gen 3. FBDI Files are zipped and are already in the proper format with csv and property fil…
-
How to Secure OIC REST API with API Key (x-api-key) Instead of OAuth?Summary: I need to expose an Oracle Integration Cloud (OIC) REST API endpoint that is secured using API key authentication. Requirement: The client invoking the OIC API …
-
Read a UCM fileSummary: Hi How to read any UCM file Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snip…
-
Flow Action Service is not listed in OIC Oracle HCM Cloud ConnectionSummary: We have requirement to invoke Payroll Flow from OIC using HCM Cloud Adapter. The Flow Action service is not listed under services section. Is there any specific…
-
How to Include Full Task History in Notification Emails in OIC Process Cloud Service Gen2I'm working on customizing notification emails for human tasks in Oracle Integration Cloud (Process Cloud Service). So far, I've managed to display task comments based o…
-
dvm:lookupValue function in OIC Gen3Summary: I have an existing lookup logic in mapper in OIC Gen2 which is now moved to OIC Gen3. dvm:lookupValue ("Lookup_PROFITCENTER", "ODM2", /nssrcmpr:execute/ns18:req…
-
Trigger integration for files over 50 MBHello, I was wondering if someone could give an idea of this. In OIC SFTP, we have files incoming to a particular folder. I created a trigger based integration for files…
-
Import Trading Community Data in Bulk Process Callback NOT triggerUse import Trading Community Data in Bulk Process in OIC for import CUSTOMER data, trigger the job successful, BUT the call back tiger the same job not be trigger. Anyon…
-
url instance oic provisioning from user with domain (no default domain) in iamSummary: When provisioning an OIC instance into a custom IAM domain (not the default), is the domain name ever shown in the instance URL (either design-time or runtime)?…
-
Bank Integration with SNB bank in Saudi ArabiaHi Team, We are trying to integrate with SNB Bank for a client using OIC. They will be whitelisting the IP addresses for OIC as we will be accessing REST APIs of Bank fr…
-
Gen3 Shared Lookup for ProjectsSummary: Hello, I wanted to know how others are handling a "Shared Lookup" mechanism in Gen3 through Projects? If you start an OIC Gen3 instance: With Projects: Lookups …
-
pdf attachment failing for AR debit memo with ErpObjectAttachmentService web serviceHi Team, We are tring to attach pdf to AR Debit memo with ErpObjectAttachmentService soap web service gettting an error.
-
Cannot use REST Adapter - relative path must not contain a query stringSummary: Hello, was there a new update or patch to REST Adapters in GEN3 that changed their behavior to no longer allow relative paths to contain a query string? I have …
-
ATP Database connection timed out in OIC when using the connection with "perform operation on table"We have a database connection setup with ATP database and it is tested and save fine and is in configured status. When using this connection in OIC integration as an inv…
-
OIC - Snowflake adapter - How to prevent token expiring?Hello, I am using Snowflake adapter with OIC and so far it looks promising. I just have one issue - the token keeps expiring. We setup everything as per Using the Snowfl…
-
OIC REST - invoke getting errored out if receive empty responseSummary: REST_RES_PLD_ERR error throws when OIC invoke request-response setup, if empty response in service then 204 response core success is coming with empty payload t…
-
OIC REST - accept ignore case query parameterSummary: For OIC, query parameter should accept ignore case parameter, is this possible example: policyId=123 or PolicyId=123, here P is small and uppercase, but this is…
-
Request Query parameters are missing while creating service connection in VBCS for fscmRestApiHi, I am creating service connection (defined by end point) in vbcs by using /fscmRestApi/resources/11.13.18.05/valueSets rest api. Below is the Rest Api documentation. …
-
Shopify to AR invoice integration - Possible using Shopify adapter?Summary: We need to integrate Shopify data with Oracle Fusion AR invoices. We saw that a Shopify adapter is present and has many capabilities, but doesn't specifically s…
-
Is there any way through which we can take out QR Code in png/jpeg format from a PDF through OIC?Is there any way through which we can take out QR Code in png/jpeg format from a PDF through OIC? We are getting the PDF using an API 'Get E-Invoice PDF'-https://docs.cl…
-
Call Integration after ESS JobSummary: Hi I want to trigger integration after ESS job . Please let me know how to configure trigger point connection for this. Content (please ensure you mask any conf…
-
XML-22900Summary: Error Summary: XPath expression failed to execute. An error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc('resources/…
-
With OIC, how to process a inbound ap file in the peppol format?Summary: With OIC 3, how to process an inbound ap file in the peppol xml format? OIC gives an error that it has too many namespaces when I specify the structure with "Sa…
-
the request is not valid: create stream request has invalid retention hours : 24Summary: Trying to setup stream Keep getting the following error: the request is not valid: create stream request has invalid retention hours : 24 I have left the retent…
-
OIC is adding text at the beginning and end of a text file - why?Hello OIC friends, Using OIC, we are using a REST connection with PUT statement to upload a file. I have managed to upload the file to target system using OIC. However, …
-
OIC Orchestration Waiting for Callback from EPM Cloud (Like SOA Correlation)Summary: We have an integration requirement with Oracle EPM Cloud, where we need to: Invoke a REST API to trigger metadata load jobs. Monitor the job status every 5 minu…
-
Converting URL to PDF in OIC for Integration Between Fusion and OFSHi team, We’re working on an integration between Oracle Fusion and Oracle Field Service (OFS). The source system (Fusion) sends a URL pointing to a document, and our goa…
-
Switch Oracle DBaaS adapter to Oracle ATP via Configuration EditorSummary: We're looking on an initiative to migrate our OIC database connections on existing integrations from DBCS to ATP. In the Integration > Configure section, does t…
-
how much it will cost per day for oracle integration instance for learning purposeSummary: Hi Experts Currently i have a free tier OCI account and i have provisioned Integration instance and enabled OPA and VB. I wanted to know if 2.116 SGD is the max…
-
Unable to assign the response of ScheduleReport service for ScheduleReportWSSSerivce in OICSummary: Unable to use the response of scheduleReport operation for ScheduleReportWSSSerivce in OIC in assigning it to either a variable or mapper. Content (please ensur…