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.
ERP Integrations
Discussion List
-
How to hold 100 OIC jobs on hold at onceHello Gurus, Whenever there is a patch or upgrade on OIC instance, how can we put all OIC jobs on hold at once? And after that we want to resume the schedule of all thes… -
Access data from a External Data Source (Sharepoint, Azure, AWS, Local Files)Summary: Hi Expert, I have a requirement to access the data from external systems like (Sharepoint, Azure, AWS, and Local Files) and show it in OTBI custom reporting doc…
-
SERIAL_NUMBER attribute on Invoice Lines APISummary: Im using /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}/child/invoiceLines API to create ap invoices from Oracle APEX but im trying to find a way … -
how to Load Image greater than 10 MB size to ATP Database in OICWe are facing issue when we try to load an image which has size greater than 10 MB in ATP Database table as the ATP Database adapter has file limitation of 10 MB in OIC.…
-
Purging files and Archival approach on ORACLE SFTPSummary: We are looking for an approach to purge files present in Archival folder in the ORACLE SFTP. Could you provide some suggestions? We need to clear old files base… -
Getting 404 error while submitting RollupCosts ess job using erpintegration Rest APISummary: Getting 404 error while submitting RollupCosts ess job using erpintegration Rest API API details Rest Method: POST https://>/fscmRestApi/resources/11.13.18.05/e…
-
Privileges to Execute Value Set Values APISummary: Privileges to Execute Value Set Values API Content (required): Hello We are looking for privileges need to execute/get the Values of value set. We are using the…
-
How to Purge files from UCM server uploaded by import/exportSummary: we are looking for a clear process of to Purge files from UCM server uploaded by import/export, appreciate if any one of you can provide some ideas also, is the… -
Is is possible to hide Icons on application UI?Can we hide the icons on application > Maintenance management > Tasks > Asset and Work Definition > Manage Asset page
-
Which role/privilage required to access erpintegrations REST ServiceSummary: We wanted to know which role/privilage required to run this REST Service. REST End point:/fscmRestApi/resources/11.13.18.05/erpintegrations "OperationName":"upl…
-
Custom Object - Access RelatedSummary: I have a requirement where we are creating a custom object to store some sensitive data. We want to restrict access to data based on some roles/privileges. How … -
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…
-
Is there any API to access table validated value set valuesSummary: we want to access table validate value set values using REST API, Please suggest the endpoints to use for the same. Content (please ensure you mask any confiden…
-
invoices API ERROR AP-810770Summary: 1.- im trying to create an AP invoice using the source "Electronic Invoice" but apparently is not allowed to be used on this way. The output message im getting …
-
How to create a Conditionally Required DFF in Fusion ReceivabaleSummary We want to create a DFF at Receivable Invoice Line to capture a Project numberContent Dear All please help... Scenario We want to create a DFF at Receivable Invo…
-
Solution to get all data for the receivingTransactionsHistory REST APISolution to get all data for the receivingTransactionsHistory REST API While executing this API https://Credential/fscmRestApi/resources/11.13.18.05/receivingTransaction…
-
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…
-
How to create custom popup notifications from Oracle Paas to Oracle FusionSummary: Hi Team , we have a requirement to create custom pop up notifications from Oracle Paas to Oracle fusion with action buttons. We are able to follow the recipe sh…
-
Call API from BPMContent Hi, just wondering if it's possible to call a REST API from a business rule in BPM for approvals? We have a REST service that will tell you who the approver(s) i… -
How do the Finder search parameters work in a REST API CallSummary: I am curious about how the finder functionality works during a REST API call and would like an official response on it. Having worked with them for awhile it se…
-
How to restrict a user to enter only in EnglishSummary: How to restrict a user to enter only in English Content (please ensure you mask any confidential information): Hi All, We got a requirement to customize the Reg…
-
Tips & Tricks Testing Oracle HCMSummary Testing Oracle HCM during project mode and post release quarterly updatesContent Businesses around the world of all sizes are going through a massive transformat…
-
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.
-
CMK: Database Table and Column for Application Partner Code in Supplier B2B ConfigurationSummary: We need to write a BI Report to display Application Partner Code setup from Supplier B2B Configuration when using Collaboration Messaging Framework (CMK). We ne…
-
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…
-
Is there any API to add or remove users from BPM Approval Group?Summary: Is there any REST API to add or remove users from BPM Approval Group? Content (required): We have got almost all of our User Provisioning fully automated over E…
-
Is there anyone able to implement the Oracle Cloud as data source for MS PowerBIHello, We are trying to verify if Oracle Cloud can act as data source for MS PowerBI? If someone able to implement this, we would like to check how you able to implement…
-
Which table in fusion captures the outcome of ess jobSummary: Hi Experts I have created ess job to schedule a bip report, i want to know if there is any table in fusion which captures the outcome/status and other data of t…
-
We are facing an issue with uploading attachments through the ERP Object Attachment Service.Summary: We are facing an issue with uploading attachments through the ERP Object Attachment Service when the FILE_NAME column length exceeds 80 characters. Content (ple…