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
-
Migration of Custom Objects created using Application ComposerSummary: I want to migrate custom objects created in TEST instance to PRODUCTION instance. When I migrated from DEV to TEST manually, I noticed that the underlying table… -
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… -
How to schedule a BICC extract job from OICSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
OIC Gen3 > Instance aborted as it has reached maximum duration allowed for queued instancesSummary: OIC Gen3 > Instance aborted as it has reached maximum duration allowed for queued instances Content (please ensure you mask any confidential information): Hello… -
Is there an API to extract data from Oracle OTM/GTM tables?Hi, We are looking for an API or a method to extract data from OTM tables. If anyone can provide details on the appropriate API and the required request payload, it woul… -
Howto download log file placed on UCM after Import Journal ESS job via OIC ErpIntegrationServiceI build the OIC flow for Import Journal process where I placed the .zip file oon ucm server and trigger Load File Interface for Import Ess job and then run Import Journa… -
Calling Payables Interface Invoices REST Endpoints from OICHi, We would like to call the Payables Interface Invoices REST Endpoints ( REST API for Oracle Fusion Cloud Financials - Payables Interface Invoices REST Endpoints ) fro… -
How to update CBO record in oracle fusion using rest APISummary: A custom database object is created to store data (CBO). Where I should be able to update the any row using REST API. I am able to use GET and POST method to re… -
session user in custom ESS job parameterSummary: I'm creating a custom job. I have a parameter that references the logged-in user. I need to know how to make the parameter default to the logged-in user. Conten… -
OIC - Raise Time LimitWe are in the process of setting our first integration via Oracle Integration Cloud (OIC). We are hitting walls with the timeout when running an Invoke to run reports fr… -
Is there an Oracle business event for when a Receivable customer account or site is created/updated?Hi, We have a requirement to trigger an OIC integration whenever a new Receivable customer account or site is created or updated. To achieve this, we are looking for an … -
Resource creation defaulting organizationHi, We need to create 3000 user (Resources) to create the salesperson and we are using API. we have four BU and four legal entity. under resource information organizatio… -
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… -
REST CreateSimpleInvoice fails on invoices over 500 lines.Since 25B has been installed in our environment we have not been able to create an AR invoice using CreateSimpleInvoice with over 500 Lines. Is this a new limitation or … -
B2B messaging Rest API returns error "415 Response Unsupported Media Type"We are trying to receive inbound purchase order acknowledge message through CMK. REST API /fscmRestApi/resources/11.13.18.05/b2bMessages as documented in below link is n… -
Is there any way to export all the Requisition approval rule from R12?Summary: Is there any way to export all the Requisition approval rule from R12? My client is using EBS R12, with 2000 rules, and we want to see if we can export that to … -
How to change the color of the FND_BANNER_MESSAGE banner?Summary How to change the color of the FND_BANNER_MESSAGE banner?Content I want to change color of FND_BANNER_MESSAGE banner, is there any way to change its color while … -
How can we configure multiple OIC instances for a single integration (like a load balancer in OIC)How can we configure multiple OIC instances for a single integration, similar to using a load balancer with OIC? -
Documentation for how to define default ESS Job Parameters in a Job SetSummary: We are interested in creating a Job Set to run a collection of Jobs on an ad-hoc basis, by the end user. As such, we want the appropriate users to be able find … -
Purge ERP Financials Interface TablesContent Introduction Data from interface and error tables can be purged as part of the following processes: * Each File-Based Data Import (FBDI) process initiates a purg… -
filter expression for Account Updated EventHello Everyone, I have subscribed an Account Updated Event in my application based integration. I am trying to achieve a filter condition which only allows account which… -
erpintegrations rest api used submit ESS based custom BI report,multiple try to submit it giving -1HI, we are using Below rest api to submit custom bi report ESS job. we are trying submit sequentially twice. first request returning request id, second request it return… -
Ess JobSet Rest Api Sample Needed for submission via rest apiLooking for sample ESS JObSet to submit via REST API I do have sample for ESS Job as below { "OperationName": "submitESSJobRequest", "JobPackageName": "/oracle/apps/ess/… -
Is it possible to create Business Event in oracle fusion- Item Create/ Item UpdateWe have a requirement to create a business event for item creation and updation. It is presumed that OIC can subscribe to the following PIM Business Events: Item Create … -
How to set parameters in a Job SetSummary: Need advice on how to enter parameters for all processes within a Job Set. Content (please ensure you mask any confidential information): Version (include the v… -
How to default a value in a field using Page Composer PersonalizationSummary How to default a value in a field using Page Composer PersonalizationContent Hi there, I am trying to figure out how to default the current date into a date fiel… -
Audit Reports | How to apply data security rulesSummary: One of our client requirements is to extend Audit reports capabilities to add, Option to restrict Product LoV in Tools-> Audit Reports, based on the roles user … -
How can you Encode Binary Reference to Base64 for files greater than 10MB?We have a requirement where integration is downloading the contents of a file from a URL as Binary response(application/octet-stream) in a REST Invoke through GET operat… -
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… -
Moved: Use of uploading SSL certificates in Administration in System Maintenance in Oracle Fusion C…This discussion has been moved.