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
-
Need REST API to bulk delete data from custom objectSummary: For 1 of our integration we need to delete records from custom object in bulk based on some condition. We were able to find REST API and payload for bulk insert… -
Why is the Fusion system significantly slower when searching the process 'Import Requisitions'?Is there a reason or a way for us to decrease the time it takes when we run Load Interface File for Import, and we select 'Import Requisitions'? It takes approximately 2… -
Use BPM Task API authenticated by integration userSummary: Hello , Need to call bpm/api/4.0/tasks API to approve or reject notification which assigned to dynamic users, how to call it and which authentication should I u…
-
Custom Object REST APISummary: Getting 401 unauthorized error while access Custom Object REST API. Content (please ensure you mask any confidential information): Hi All, We have a custom obje…
-
Can you integrate Oracle Fusion Projects and Assets modules master data into Oracle EDMCS?My client wants to use EDMCS as a master for mastering the dimensionality. Some master data needs to come in from the ERP Fusion Projects & Assets modules. Is there a wa…
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…
-
looking for sample query to extract data using BIP report from ERP to EPM QuestionSummary: We are proposing a custom integration instead of current native integration to extract data from GL into our EPM applications to solve the volume issue with dat…
-
Cloud instance nameSummary Query to fetch cloud instance nameContent Table: ASK_DEPLOYED_DOMAINS Schema: FUSION_SETUP The field EXTERNAL_VIRTUAL_HOST stores the external link Condition: DE…
-
Patch Impact Analysis for Oracle Fusion CloudSummary Patch Impact Analysis for Oracle Fusion CloudContent We have a scheduled maintenance every quarter with Oracle Cloud support for the quaterly patching cycle.Thou… -
How to get ESS job output file in its original format rather than xml file though web service?Hi All, I am trying to get the output file of an ESS job using webservice 'downloadESSJobExecutionDetails' metioned in this doc:https://docs.oracle.com/en/cloud/saas/fin…
-
import document sequences in BULKSummary: We have a requirement to have document sequencing to be defined based on Ledger and We have approx 3k+ Document sequences to be assigned to multiple categories.…
-
Time it takes for an erp event based OIC integration to runIn an OIC integration per erp event, how long is the estimated time it may take to execute? Is there a way to update that configuration? -
Password Synchronization between ERP and EPMSummary: We would like to be able to synchronize passwords between EPM and ERP. Content (please ensure you mask any confidential information): We would like to be able t…
-
How to change Movement Request status from 'Incomplete' to 'Preapproved' status using Rest API.Summary: I have a requirement to create movement request in preapproved status using rest API via OIC tool. I have found one note for this Doc ID 2558576.1. By following…
-
How to Integration between Oracle Cloud ERP fusion with Power BISummary: Do we have a direct way to enable Power BI to access directly DB tables in oracle ERP as select other than webservices? Also there is a tool for integration cal…
-
API for Chart of Accounts Segment Values?Summary: Looking for an API to pull Chart of Account segment values Content (required): I see the ChartofAccountsLOV API, however we're looking to pull the actual segmen…
-
Creation of Fusion API Token to access from Third Party systemSummary: Hi Team, We are using below Rest API for upload the GL Journal data to UCM Server. I am successfully able to Upload the GL Journal data into UCM Server. /fscmRe…
-
Reverse backflush not completing in MFG Cloud through OIC interfaceWhat does the error mean ? You must enter a transaction date for material return that's after the transaction date of last issue transaction -
Using Contains function in SwitchHello , Trying to use contains function in Switch route in OIC , want to understand how it works We need provide like fn:contains(col1,'value') = 'TRUE' ? Please confirm -
BPM Rest Api Add a Task Attachment payloadSummary: I'm not able to find how to send a payload for this Service. The description says that the service does not have a request body. Can anyone tell me how do i upl…
-
How to create Deep Link for a ERP and SCM Custom Object in App ComposerSummary Can we create Deep Links for custom Objects created under the ERP and SCM Area in App ComposerContent Hi, I have created a custom object in the ERP and SCM domai… -
How to retrieve Generic Lookup code using REST APIOracle provides 3 REST API types namely Common, generic and Standard lookups to retrieve respective lookup values. I need to search for lookup codes under lookup type "P…
-
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 … -
Oracle Fusion ERP User Login BannerUpon login, the user is presented with a “banner” stating their name and the last time they logged in.
-
Can we write a validation for a custom dimension - NAME (Projects). to avoid alphabets in nameSummary: Member Core. Name we have created (Projects) Custom dimension. The probability of node (String) and node name should be only Number and can starts with letter "…
-
Client success stories or real-world examples where the Digital Assistant or skill was extended?Would love to hear any and every example of where the out-of-box digital assistant (FADigitalAssistant) and its skills were extended. Specifically, the ERP & EPM skills …
-
Oracle APEX embedded in Oracle FusionSummary: Hello, I developed an application in Oracle APEX and I want to integrate it with Oracle Fusion. What would be the steps to achieve this? Content (please ensure …
-
How to push data to Azure from Oracle CloudSummary: How to push data to Azure from Oracle Cloud Content (please ensure you mask any confidential information): We are looking to push data to Azure from Oracle Clou…
-
REST API - how to create multiple records in one payload?Summary: I tried to use REST API to create multiple learning content in one Payload, I did exactly the same as Oracle support document 2644754.1 or 2746047.1, but I got … -
OIC-FBDI-Supplier creation with existing RegistryID failing with Invalid value.Hi, We are trying to create supplier using FBDI by providing the existing Registry ID of existing customer of type Person. On Import we are receiving an error as "You mu…