Oracle Key Tables in Oracle Fusion Payables

This post provides you some of the sample queries for the payables in Oracle fusion.

Here’s an example of how you might query invoice data:

Key Tables in Oracle Fusion Payables

1. Invoice Tables
AP_INVOICES_ALL: Stores invoice header information. Key columns include INVOICE_ID, INVOICE_NUM, VENDOR_ID, INVOICE_DATE, and INVOICE_AMOUNT.
AP_INVOICE_LINES_ALL: Stores invoice line-level details. Links to AP_INVOICES_ALL via INVOICE_ID.
AP_INVOICE_PAYMENTS_ALL: Contains information about payments applied to invoices. Links to AP_INVOICES_ALL via INVOICE_ID.
AP_INVOICE_DISTRIBUTIONS_ALL: Holds the accounting distribution details for each invoice. Links to AP_INVOICES_ALL via INVOICE_ID.
2. Payment Tables
AP_PAYMENT_SCHEDULES_ALL: Contains invoice payment schedule information. Links to AP_INVOICES_ALL via INVOICE_ID.
AP_PAYMENTS_ALL: Stores payment batch or manual payment header details.
AP_PAYMENT_HISTORY_ALL: Maintains a history of payment-related activities.
AP_CHECKS_ALL: Stores check-related payment information (e.g., check number, payment date).
3. Supplier Tables
PO_VENDORS: Stores supplier (vendor) information. Key columns include VENDOR_ID, VENDOR_NAME, and VENDOR_TYPE.
PO_VENDOR_SITES_ALL: Holds supplier site-related data. Links to PO_VENDORS via VENDOR_ID.
PO_VENDOR_CONTACTS: Contains supplier contact details.

















4. Accounting Tables
GL_IMPORT_REFERENCES: Links subledger transactions (like payables invoices) to general ledger journals.
XLA_AE_HEADERS: Holds accounting entry header data.
XLA_AE_LINES: Stores accounting entry lines for subledger transactions.
XLA_DISTRIBUTION_LINKS: Links subledger distributions to journal lines.
5. Miscellaneous Tables
FND_LOOKUPS: Stores lookup codes used across modules, including payables.
FND_USER: Maintains user-related information for access and approvals.
HZ_PARTIES: Contains party information (used for suppliers, customers, etc.).
HZ_LOCATIONS: Stores location details associated with parties.