The Cool Fox

Importing Payables invoices is a common requirement in every Oracle Fusion implementation — especially during data migration or when integrating with external systems like OIC, third-party ERPs, or legacy platforms. In this post, I’ll walk you through the complete process of importing Payables invoices , including key interface tables , required jobs , and troubleshooting tips . 🧩 Step 1: Load Data into Interface Tables Before importing, your invoice data must be inserted into the Payables Open Interface Tables : Table Name Purpose AP_INVOICES_INTERFACE Holds invoice header information such as Supplier, Invoice Number, Invoice Date, Amount, etc. AP_INVOICE_LINES_INTERFACE Holds invoice line-level details such as Item, Description, Amount, Distribution Account, Tax, etc. These ta...

Understanding .properties file for ERP Bulk Import Jobs in Oracle Integration Cloud (OIC)

In this post, we will understand how to import FBDI files using OIC and how to create .properties file for the process. To import FBDI file using OIC we need two files: FBDI zip file .properties file While working with ERP Adapter in OIC, we select the below option to Import FBDI in Oracle Fusion Cloud. Then we select the Bulk Import Process name Here we selected Import Journals process. Make a note of Import Job Name and...

[OIC] Purge Oracle Fusion Interface Data using OIC

This post will show how to Purge Oracle Fusion Interface Data using OIC. Scenario - Consider a scenario that you have created OIC Interface to Import Journals into Oracle Fusion ERP. Now, you want that once import is completed, interface tables should purge automatically. So, follow the below steps to implement this: Callback integration of type Application Driven will be created which will be accepting the callback once " Import Journals " job will be completed. We will be using Oracle ERP Cloud Adapter Connection as trigger point of the integration with below configuration. Add another Oracle ERP Cloud Adapter Connection, just to get interface ID of import job Also, get details for Purge job from Fusion by going to Setup and Maintenance -> Search -> Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications InterfaceLoaderPurge Purge Interface Tables /oracle/apps/ess/financials/commonMo...

[OIC] Trigger OIC REST Integration from Oracle Fusion BIP Report

In this post we will see how to trigger the OIC REST Integration from Oracle Fusion BIP Report. Prerequisites: Access to OIC Console to create integration. Make sure you have ServiceDeveloper or ServiceAdministrator access. OIC REST Integration which can be invoked by using Basic Authentication. Make sure you have one generic OIC user which can be used to setup OIC Connection in Oracle Fusion BIP. For this generic user we need to have username and password available and it should not be SSO user, i.e. it should be of type non-federated account. Access to Oracle Fusion BIP with Admin access to add new data sources, i.e. user must have BI Administrator Role Steps: Create an OIC REST Based Integration with Parameters and which returns XML type response. Create a Data Source for OIC Integration instance in which you need to put hostname of OIC Intance and generic user credentials Create an Oracle Fusion BIP Report with XML Feed type data set to trigger the integrat...

[EBS] SOLVED - Customer Not Visible in Oracle Apps R12

When working with Oracle E-Business Suite R12, especially in Receivables (AR) or Trading Community Architecture (TCA) , you might encounter a situation where you create a new customer , but it doesn't show up in the Customer Search screen . Several things could be causing this. Here's a checklist to help you troubleshoot: ✅ 1. Customer Status Ensure the customer account is active . ✅ 2. Customer Site and Site Use Ensure at least one customer site exists for the customer. Also ensure site use is defined – e.g., "Bill To", "Ship To". Without proper site and site use, the customer might not appear in downstream flows or searches. ✅ 3. Party vs Account Confusion Oracle uses Trading Community Architecture (TCA) , where a party (in HZ_PARTIES) may exist without a customer account (in HZ_CUST_ACCOUNTS). Verify that the customer has a customer account created (not just a party). Check HZ_CUST_ACCOUNTS table for the party ID. ✅ 4. Search...

Powered by Blogger