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
-
Upgrade OIC Gen3 Standard version to Enterprise versionWe need information related to OIC Gen3 version upgrade. Currently Standard version is being used. Can standard version be upgraded for current instance to Enterprise ve… -
Does Oracle fusion have any event for Initiate Stop action to a Payment?Summary: Hi Team, We are looking for a real time event from ERP Cloud if it exists when an Initiate Stop action is applied to a Payment in Fusion? We could see events fo… -
Why REST API for Supplier asks supplier id instead of supplier number for get request.Can you please let us know for get request why REST API asks for Supplier ID but not Supplier Number for Supplier? https://docs.oracle.com/en/cloud/saas/procurement/25a/…
-
Case Sensitive File NameSummary: Case Sensitive File Name Content (please ensure you mask any confidential information): We have file XYZ.zip in SFTP , in Integration we're passing file extensi… -
UNZIP and WRITE FILESummary: UNZIP and WRITE FILE in SFTP Content (please ensure you mask any confidential information): We have a zip file (which contains multiple folders —> each folder h…
-
How to create a custom ESS Job for a BI Publisher report to upload the report output to UCMHow can I get the ESSJOB output report from UCM? I want to output the report file directly to UCM without downloading it.
-
Anyone with Documentation on Exchange rate integration.Summary:We are looking to automate the daily exchange rate without any manual intervention. Content (required): Version (include the version you are using, if applicable…
-
What is the maximum attachment size allowed for rest the AP Invoice Creation REST APISummary: Hi, We are using the REST API "/fscmRestApi/resources/11.13.18.05/invoices" to create Invoices along with attachment, but the REST API is failing when the file …
-
How can we create a custom events to trigger the integration flowSummary: How can we create a custom events to trigger the integration flow. if we click a release button for a project the integration need to trigger but i am unable to…Veera venkata satya Ranga Prasad 25 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI
-
How to schedule a BICC extract job from OIC and ftp the corresponding output fileSummary: We are planning to use OIC to extract data from Cloud ERP and load our data warehouse in Azure cloud SQL Server database. We would like to Use BICC extracts to …
-
Unable to pass comma in REST API Call for submitESSJobRequest in erpintegrations serviceWe're using erpintegrations REST service to submit ESS jobs using submitESSJobRequest operation. Sample Payload: { "OperationName":"submitESSJobRequest", "JobPackageName…
-
Unable to store response payload from OIC to a databaseI am creating an OIC app driven integration using rest adapter where I need to store the final response payload into a Data base table .is there any way to achieve this
-
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…
-
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…