Tables of Accounts Payable In Oracle R12

In Oracle R12, the Accounts Payable (AP) module involves various tables that store data related to supplier invoices, payments, liabilities, and other financial transactions. Below is a table with the key Oracle R12 Accounts Payable tables, including a brief description of each:

Table Name

Description

AP_INVOICES_ALL

Stores information about supplier invoices. Each row includes details such as invoice number, invoice date, supplier information, and payment terms.

AP_INVOICE_LINES_ALL

Contains individual invoice line details, including descriptions, amounts, distributions, and accounting information for each line of an invoice.

AP_INVOICE_DISTRIBUTIONS_ALL

Stores distribution information for supplier invoices, such as accounting flexfields, line amounts, and GL accounts.

AP_PAYMENT_SCHEDULES_ALL

Holds information about payment schedules for invoices, including due dates, amounts, discounts, and status.

AP_PAYMENTS_ALL

Contains data on payments made to suppliers, including payment amounts, payment methods, bank accounts, and payment statuses.

AP_PAYMENT_DISTRIBUTIONS_ALL

Stores distribution information for payments, including how payments are applied to invoices, prepayments, or other distributions.

AP_CHECKS_ALL

Holds information about checks issued to suppliers, including check numbers, dates, and payment details.

AP_SUPPLIERS

Stores supplier information, including names, addresses, contacts, and payment terms.

AP_SUPPLIER_SITES_ALL

Contains details about supplier sites, including location-specific payment terms, tax information, and bank accounts.

AP_BANK_ACCOUNTS_ALL

Stores information about bank accounts used by suppliers, including account numbers, bank names, and routing information.

AP_BANK_BRANCHES

Holds information about bank branches associated with supplier bank accounts, including branch codes and addresses.

AP_HOLDS_ALL

Stores information about holds placed on supplier invoices, including the type of hold, reason, and resolution status.

AP_TERMS

Contains standard payment terms available in the system, which can be applied to supplier invoices and payment schedules.

AP_BATCHES_ALL

Holds data about batches of invoices or payments that are processed together, including batch totals and processing status.

AP_SELECTED_INVOICES_ALL

Contains details of invoices selected for payment during a payment batch, including payment priority and amounts.

AP_SYSTEM_PARAMETERS_ALL

Stores system-wide settings and defaults for the Accounts Payable module, such as default liability accounts and currency settings.

AP_AE_HEADERS_ALL

Holds accounting event (AE) headers for accounting transactions generated in the AP module, used for linking to the General Ledger (GL).

AP_AE_LINES_ALL

Contains the detailed accounting entries (debit and credit) for each AP accounting event, linked to the AE headers.

AP_INVOICE_PAYMENTS_ALL

Links invoices to payments, showing which payments were applied to which invoices, and the amounts applied.

AP_INTERFACE_CONTROL

Contains control information for AP interface tables, which are used for importing data into AP, such as from external systems.

AP_INTERFACE_ERRORS

Stores error messages related to issues encountered during the import of data into AP interface tables.

AP_INTERFACE_REJECTIONS

Contains details of records rejected during data import into AP, including reasons for rejection and the specific data involved.

Key Relationships:

  • AP_INVOICES_ALL is related to AP_INVOICE_LINES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL via the INVOICE_ID field.
  • AP_PAYMENTS_ALL is linked to AP_PAYMENT_DISTRIBUTIONS_ALL and AP_CHECKS_ALL via the PAYMENT_ID field.
  • AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL are related by the VENDOR_ID field.
  • AP_BANK_ACCOUNTS_ALL and AP_BANK_BRANCHES are linked via the BANK_ACCOUNT_ID and BRANCH_ID fields, respectively.
  • AP_AE_HEADERS_ALL and AP_AE_LINES_ALL are connected through the AE_HEADER_ID field.

These tables work together to manage the entire Accounts Payable process, from invoice creation and payment processing to supplier management and reporting.

 


Comments

Post a Comment

Popular posts from this blog

Accrual reconciliation when using Accrue Expense Items at Receipt in Oracle EBS R12 or Oracle Fusion.

 1. SLA Accounting Rules (Subledger Accounting Setup) When you’re using Accrue at Receipt , Oracle needs to know which accounts to use during different steps of the P2P process. SLA handles this through Journal Line Definitions (JLD) and Account Derivation Rules (ADR) .  A. Typical Accounting Setup in SLA for Expense Items at Receipt Event Debit Credit Description Receiving (Expense Destination) Charge Account (from PO) Accrual Account Accrual created immediately at receipt Invoice Matching Accrual Account AP Liability Reverses accrual and creates liability Payment AP Liability Cash/Bank Standard AP payment Optional Enhancements via SLA : Add cost center segments from PO distribution. Use item category to change accounts. Override based on supplier site or BU .B. Example Account Derivation Rule Let’s say you want the credit accrual account to vary by item category. Your rule tree can look like: java IF Item Category = 'IT_HARDWARE' THEN use Accrual A...
Read more

AP Accrual at Receipt in Oracle R12

 what really happens in Oracle E-Business Suite/Oracle Fusion Procurement & Payables when you set Accrue Expense Items = “At Receipt” (sometimes called Perpetual Accrual ). I’ve broken it into the three moments you actually care about— Receipt, Invoice, and Period Close/Reconciliation —plus the key setup switches that drive it. 1. Key setup you need to double-check Module Form / Task Field / Profile What it must be Why it matters Purchasing Purchasing Options Accrue Expense Items At Receipt (not Period End ) Tells the Receiving Transaction Processor (RTP) to book an accrual the instant you do the receipt. Receiving Receiving Options (supplier & org) Expense AP Accrual Account A suspense / clearing account Credited at receipt and debited when the invoice posts. Payables Financial Options Liability Account Your trade AP control Credited when the invoice is accounted. Sub-ledger acct. rules (SLA) (optional) Override rules Only if you need different accounts by item categ...
Read more

Types of AP invoices in oracle ERP

  In Oracle ERP (Enterprise Resource Planning), specifically in the context of Accounts Payable (AP) invoicing, you can create and manage various types of invoices to handle different financial transactions and business needs. Here are some common types of AP invoices in Oracle ERP: 1.Standard Invoice: This is the most common type of AP invoice, used to request payment from your organization's customers for goods or services provided. It typically includes details such as the supplier's name, invoice number, invoice date, and itemized charges. 2.Credit Memo: A credit memo is issued by a supplier to reduce the amount owed by your organization. It may be used to account for returns, discounts, or other adjustments to previously issued invoices. 3.Debit Memo: Conversely, a debit memo is issued by a supplier to increase the amount owed by your organization. It might be issued for additional charges, fees, or other adjustments. 4.Prepayment Invoice: Prepayment invoices are used when...
Read more