- Add Function Security Policy :
- Name: Manage Webservices catalog Code: FND_MANAGE_CATALOG_SERVICE_PRIV : Privilege to Manage Web service Catalog.
- Add Role:
- Role1: Name: Integration Specialist Code:ORA_FND_INTEGRATION_SPECIALIST_JOB : it is a job role which inherits Oracle ERP Cloud roles but does not include any data access. Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems.
- Role 2: Name: SOA Operator Role , Code: SOAOperator: SOA application operator, for common operational tasks like start, stop monitor, backups.
- Role3: Name: Attachments User , Code: AttachmentsUser: provides access to the Attachments Security which enables user to download log or output file using ERP Integration service.
- Role 4: Name: Employee , Code: ORA_PER_EMPLOYEE_ABSTRACT
- Role5: Name: SOA_ADMIN_ROLE, Code: SOA_ADMIN_ROLE : this is needed to access the SOA composer to register the CSF key.
Friday, March 3, 2023
Oracle Cloud ERP - Create an Integration user with adequate roles and Priviledges | Assign Required roles to an Integration User
Thursday, March 2, 2023
OIC - Design time audit logs | How to monitor design time audit logs
We can track or monitor the design time audits from monitoring dashboards. That means we can track who has activated, deactivated or locked the integrations etc. We can also download all the audit logs or report for the retention period.
Navigation:
OIC console >> Monitoring >> Integrations >> Dashboards >> Change the view to Design time Audit
Wednesday, March 1, 2023
ERP - Import AP Invoice using FBDI files from ERP scheduled Processes
In this post, I will show you how to import payable invoice(zip of invoice header and Line) from ERP scheduled Processes.
Highlevel steps:
- Download the invoice file(.zip file which contains ApInvoicesInterface.csv and ApInvoiceLinesInterface.csv) from Oracle enterprise repository.
- Upload the file to UCM and submit the process "Load Interface File for Import"
- Onve the data loaded from the zip file to the interface tables(AP_INVOICES_INTERFACE AND AP_INVOICE_LINES_INTERFACE), run the process "Import Payables Invoices" to load data to bases tables.
Step1: Get the FBDI file from OER (Oracle Enterprise Repository)
https://docs.oracle.com/en/cloud/saas/financials/23a/oefbf/index.html
Download the XLSX template and Generate the CSV files as .zip file.
Step2: Transfer the file to UCM and load the file to Interface tables:
Navigate to Tools >> Scheduled Processes
Step3: Run the payable import job to load the data from interface tables to Base tables.
From Payable >> Invoice page we can also check the created invoice:
Note :
We can also verify the interface table data by running below BI queries:
Select * from AP_INVOICES_INTERFACE order by creation_date desc
Select * from AP_INVOICE_LINES_INTERFACE order by creation_date desc
Featured Post
OIC - Moving a File using FTP connection now throws IO operation failed error
Error usecase: Moving a File using FTP connection now throws IO operation failed error. The integration has been working for weeks, with a f...

-
Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
-
OIC interview Q & A: 1. FBDI approach with an example https://soalicious.blogspot.com/2022/02/oic-erp-supplier-bulk-import-and.html 2. ...
-
Stage or vfs or virtual file system is a temporary location in the oic local file system which stores temporary files required for processin...
-
Usecase: Here, we will extract the data from HCM and then download the data from UCM uaing Flow Actions Service and Generic Soap Service To...
-
Usecase: Here, we will see how we can download the import Payables Invoices report. That is we will download report equivalent .xml file w...
-
UseCase: Here, we will show you how to split an input, received as comma separated string values( here, emails) into array of values using c...
-
What is Throttling: Throttling is termed as "regulate the flow". Oracle Service Bus has throttling feature and by using that f...
-
Usecase: Here, we will demonstrate the detailed implementation steps for AP Invoice FBD Import from polling the file from source >> cr...
-
UseCase: While mapping the elements in the mapper using XSD structure of the file contents, getting below 2 types of translation errors: Err...
-
Credential Store Framework (CSF) is used in OWSM to manage the secure credentials. CSF provides a way to store, retrieve, and delete cred...