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 use ERP Object DFF Update Web Service for updating DFF in receipt Application level?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Does FBDI support importing new lines characters ?Hi All Does FBDI support importing new lines characters ? We want to import description via AR FBDI and ensure the formatting on the Invoice print is as expected. Thanks -
Oracle FBDI > Journal Import > Journal Import FBDI Template > Journal Entry FlexfieldSummary: Oracle FBDI > Journal Import > Journal Import FBDI Template > Journal Entry Flexfield Content (required): Hello All, Is it possible to send in the Journal Impor…
-
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…
-
Unable to connect to SFTPHi Team, We're trying to get bank statement from OIC SFTP server, and we setup transmission as following steps: Create transmission rule using the account provided by SF…
-
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…
-
oic gen3 vs. gen2 listFiles in FTP connectionHi, I have an integration that checks if files are present on an external server before downloading…This works flawlessly in OIC gen2. However when migrating the same in…
-
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 "…