Category 222
Discussion List
-
Oracle DBaaS send query parameters in SELECTHi, I'm trying to send query parameters in my SELECT statement but it keeps returning in syntax error: I have thought we use # to define variables? I let the Query gener… -
need help to understand xpath error -OICSummary: Hi Guys. I am geting this xpath error, however I have no Idea how to "bebug" it. Content (required): Version (include the version you are using, if applicable):…Rodrigo L Sartorato 7.1K views 23 comments 0 points Most recent by Venkat Chakradhar P-Oracle Integration -
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 …
-
How to do error handling in Oracle Process Automation OPASummary: Hi Experts I have process application built using OPA, where i'm calling web service and it is failing. How can i design the process to catch the runtime error …
-
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 … -
How to register JWT post endpoint API gateway use in OICI have a token rest URL having x-www-form-urlencoded body parameters "client_id" : "****, "client_secret" : "xxxaavvbb", "scope" : "service.monitoringxxx", "grant_type" … -
How to establish connectivity with ADP WFN in OIC Gen3Summary: Hello, I am working on requirement to integrate HCM related information from ADF WFN with Oracle Fusion Cloud using OIC Gen3. ADP WFN provides REST APIs to acce…
-
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…
-
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…
-
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…
-
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… -
Few files not being listed in OIC List files until touched or saved againSummary: We have Fusion scheduler placing file on to FTP folder, which in turn will be listed and processed by OIC , we do not see those files listed in OIC. But when tr…
-
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…
-
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)?… -
How to Import Bulk Customers with FBDI Template using OIC ERP Adapter and receive a CallbackSummary: How to Import Bulk Customers with FBDI Template using OIC ERP Adapter and receive a Callback Content (required): Version (include the version you are using, if …
-
Implementing Decline reason requirement in OTM as Mandatory?Summary: What is the approach in implementing the decline reason requirement as mandatory when the shipment is declined, and what are the ways to develop the solution? C…
-
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 - 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…
-
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 …
-
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…
-
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…
-
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…
-
Upcoming event (3/23): Accelerating Modernization and Innovation with OCI Application IntegrationJoin us on Thursday, March 23rd at 8:00 am PT to see how you can accelerate your application extension and connection projects while avoiding upgrade issues. Join our pr…
-
XML-22900Summary: Error Summary: XPath expression failed to execute. An error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc('resources/…
-
How to connect to Active Directory on-prem from OIC using agents?We need to connect to the Active Directory. Any documentation on how to connect to Active Directory on-prem from OIC using agents?
-
Create flex fields for an existing sales orderSummary: Hello everyone, I have the following problem that requires your support: I have a sales order created in the ERP A context has already been created with the fle… -
How to submit ESS job and subscribe to callback event raised by Fusion with OIC using ErpIntegrationSummary: How to submit ESS job and subscribe to callback event raised by Fusion with OIC using ErpIntegration with submitESSJobRequest Content (required): I need to invo…
-
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…
-
Oracle HCM Fusion API OAuth with Entra IDSummary: Does Oracle only support JWT Assertion Grant Type? I am asking this because it seems to depend on Trusted Public Certificates from MS Azure/ EntraID and those a…