Integrated Cloud Services
Discussion List
-
OIC to read/write file as BLOB in Oracle DB tableSummary: Hi Team, We are looking for details like how to use OIC to read/write file as BLOB in Oracle DB table. Thanks, Rahul Content (required): Version (include the ve… -
OIC Create or update item eventHi guys, I need to use create item event and update item event triggers, when one item created or updated i need to invoke another web service and get the latest infos a…
-
Oracle ADF Desktop Integration Add-in plugin is not reflecting on ExcelHi Team, ADF plugin is not reflecting on Excel for HSDL Uploading, we have followed the below series of steps, mentioned in this KM document: Please let us know what we … -
EPM Integration Agent Query data from JDEThe EPM Integration Agent was built and the data was queried from JDE. Our requirement is to TRIM and concatenate the data using a CASE expression. Are there any suggest…Dharanidharan M 71 views 13 comments 0 points Most recent by NarayananS Financial Consolidation and Close
-
Triggering OIC using ESS without BIP routeSummary: This is requirement from client where they dont want to give access to OIC to business users and want to trigger the OIC integration by passing parameter using … -
migrate sandbox to another from an instance to anotherWe need to migrate just some sandboxes, not all. Is it possible ? if yes, how?
-
Need to set OIC password to never expireWe have an OIC user that’s utilized for an automated solution via Visual Builder Studio (VBS). The password for this user is expiring automatically, which results in a 4…
-
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…Abhilash K - Deloitte USI 28 views 0 comments 1 point Started by Abhilash K - Deloitte USI Integration -
How can we prevent duplicate entries in a OIC Lookup?Currently OIC lookup allows duplicate values. Is there a way to prevent duplicate entries in the lookup?Abhilash K - Deloitte USI 12 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI ERP Integrations
-
How to pass query parameter to child objectsSummary: Hi Team, we have a child object "receivablesInvoiceDFF" in "receivablesInvoices" REST service and would like to pass a DFF value as query parameter. Trying with…
-
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… -
Integration Oracle Fusion ERP to Oracle RightNowSummary: Hi, I would like to know, is there a possibility to connect Oracle Fusion Cloud ERP with Oracle RigthNow (Services)? Are there apis or services to build an inte…
-
oic escape xml parsing for special character when getting data from database adapterWe do not want to put escape character generated during select operation on database adapter. OIC is adding escape character to few special character not all. We dont wa… -
In case of 2 OIC Instances, how to start OIC Instance ID with a provided sequenceHello Team, Customer is planning to have 2 OIC instances and use OIC instance ID as primary identifier for many integrations. In some instances OIC instance id can be sa…
-
OIC Gen3: What are the Merits of using Event Based Integration than the normal Integration callSummary: What are the merits of using Event based PUB/SUB Integrations than calling the App-driven Integrations multiple times . Content (please ensure you mask any conf…
-
Reassign or Action button missing in Process cloud serviceThere is a custom component in VBCS and approval process is designed in PCS, need to reassign one approval to another user, we normally log in via admin user in OIC and …
-
How to integrate Jaggaer Purchase Requisitions to Oracle ERP Cloud and perform a funds check?Hi Team, We are trying to evaluate an OIC integration process to fetch Purchase Requisitions from Jaggaer and integrate with Oracle ERP Cloud. We will also perform a fun…Abhilash K - Deloitte USI 103 views 0 comments 1 point Started by Abhilash K - Deloitte USI Integration
-
Is there a way to trigger an OIC Integration to process a file as soon as it is placed by SRC systemSummary: We are looking for advise on if we have any approach to trigger an OIC integration as soon as file is placed by Source system. We are using OIC SFTP as a file s…Abhilash K - Deloitte USI 124 views 1 comment 0 points Most recent by Julio C. Lois ERP Integrations
-
Need an ical expression for OIC to schedule an integration on thursday in 1st week of each monthNeed an ical expression for Oracle Integration Cloud to schedule an integration on Thursday in 1st week of each month at 8 am in morning. I tried this FREQ=MONTHLY;BYDAY…
-
If We have any integration scheduled for 10 min. when we run integration we want only updated data?Summary: If We have any integration scheduled for 10 min. when we run integration we want only updated data within last 10 min. We are fetchind data using BIP report ,in…
-
Filter data based on Last Integration Run in OICWe are trying to get only updated records from last integration run. But we are using BIP report to fetch records based on from date and to date and if we have not pass …
-
OIC - Assign custom roles to run specific integrationsSummary: We have a requirement for HR Admins to access OIC and view/run only HR Integrations. Can this requirement be achieved through custom security roles ? Content (p…
-
Need guidance for upgrading Oracle Integration cloud instance from Gen2 to Gen3I am planning to upgrade OIC instance from Gen2 to Gen3. For this what are the pre requisites to be done and how it can be done. Kindly guide me.
-
Error 401 from postman when call job on OICSummary: We have created an integration where we are calling REST API and load GL file on Fusion. However while calling the integration flow from Postman, we are getting…
-
ERP Integration Services - Export DataSummary Automate ERP Outbound Bulk Export Integration in R11Content Introduction Oracle Enterprise Resource Planning (ERP) Cloud provides a comprehensive set of modern c…
-
Invoking AIC Integration from CMK B2B Electronic MessagingSummary Getting oracle.j2ee.ws.saaj.soap.SOAPVersionMismatchException: Mime Header Content-Type: text/xml requires SOAP envelope namespace: http://schemas.xmlsoap.org/so…Shubhashree R Rajanna 75 views 3 comments 1 point Most recent by Preetesh Dongre-Oracle ERP Integrations
-
Recipe for VBCS Form to submit any Oracle Application REST APIsDo we have any Recipe/Sample built for VBCS Form where in we can just go and select or change the Module and run the related REST APIs? For Example, VBCS Screen/Form wil…
-
ERP Object DFF Update Web Service - Receivables Invoice OnlyContent Overview The ERP Object DFF Update Service is a utility web service that provides an external operation to perform the automatic update of descriptive flexfield …
-
Exposing Oracle Cloud API to external systemsSummary: We are working on an enterprise level decision on a requirement to expose the ERP Cloud API to external system/Applications. Content (please ensure you mask any…
-
Why am I receiving BINDING.JCA-15013 & FTP_MOVE_SAME_FILE_MOVE_ERROR using FTP Adapter in OICgen3Summary: Receiving error message when moving file from 1 directory to another using FTP Adapter. Full Error below. I have Overwrite File box checked and have changed nam…