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...

[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...

Import Segment Values and Segment Value Hierarchy in Oracle Fusion Cloud

To import Segment Values and Hierarchies using FBDI process in Oracle Fusion follow the below steps: In Google search engine search for " oracle fusion fbdi 23a ", as our version is 23a, and open the first link ( https://docs.oracle.com/en/cloud/saas/financials/23a/oefbf/index.html ) In the left pane go to the Payables section and select Import Segment Values and Hierarchies and then download the XLSM Template When you open the XLSM file, in case you get the below error : Right-click the file and open the properties. Select the Unblock option and apply. When you open the XLSM file, it already has the data in it. You can clear all the sheets and start inserting your own data Before getting into to insert data in this FBDI sheet, let's understand a few things about Account Hierarchy. Trees are hierarchical data models that you can use to organize data, apply business rules, control data access, and improve perform...

SQL Query to fetch Exchange Rates/Daily Rates (using GL_DAILY_RATES and GL_DAILY_CONVERSION_TYPES) in Oracle Fusion Financials

In Oracle Fusion, GL_DAILY_RATES contains the daily conversion rates for foreign currency transactions. It replaces the GL_DAILY_CONVERSION_RATES table available in Oracle Apps. GL_DAILY_RATES contains the rate to use when converting between two currencies for a given conversion date and conversion type. Each row in this table has a corresponding inverse row in which the from and to currencies are switched. For example, if this table contains a row with a from_currency of YEN, a to_currency of CND, a conversion_type of Spot, and a conversion_date of January 1, 1997, it will also contain a row with a from_currency of CND, a to_currency of YEN, a conversion_type of Spot, and a conversion_date of January 1, 1997. GL_DAILY_CONVERSION_TYPES contains daily conversion rate types and their descriptions. This table corresponds to the Conversion Rate Types form. Use the below query to fetch Exchange Rates/Daily Rates in Oracle Fusion Financials SELECT r...

Powered by Blogger