Search Results cst_ap_po_reconciliation




Overview
Explore in AI Chat

Overview

The CST_AP_PO_RECONCILIATION table is a core transactional table within the Oracle E-Business Suite (EBS) Bills of Material (BOM) product family, specifically designed to support the reconciliation of purchasing and payables transactions. Its primary role is to serve as a central repository that links procurement activities—such as purchase order receipts and distributions—with their corresponding financial entries in accounts payable. This linkage is critical for accurate cost accounting, period-end accrual accounting, and ensuring that inventory and expense costs are correctly captured and matched between the Purchasing (PO), Receiving (RCV), and Payables (AP) modules. The table's existence is fundamental to maintaining data integrity across the procure-to-pay lifecycle in both EBS 12.1.1 and 12.2.2 versions.

Key Information Stored

While the provided metadata does not list specific columns, the documented foreign key relationships reveal the essential data linkages stored in this table. Each record typically represents a reconcilable transaction and includes foreign key references to its source documents. The critical columns inferred from these relationships are the PO_DISTRIBUTION_ID, which links to a specific line on a purchase order distribution; the RCV_TRANSACTION_ID, which links to the corresponding material receipt or return transaction; and the ACCRUAL_ACCOUNT_ID, which points to the general ledger account used for accrual postings. Furthermore, the OPERATING_UNIT_ID column enforces multi-org security and partitioning of data by business unit. Additional columns likely store amounts (e.g., quantity, cost), transaction dates, reconciliation status flags, and references to the eventual accounts payable invoice distribution.

Common Use Cases and Queries

This table is central to reconciliation reports and troubleshooting discrepancies between received goods and invoiced amounts. A common use case is identifying unreconciled receipts at period close to calculate accurate accruals. Database administrators and functional consultants may query it to diagnose issues where cost updates fail or where payables invoice validation errors occur due to missing receipt information. A typical analytical query would join this table to purchasing and receiving tables to assess the reconciliation status.

Sample Query Pattern:
SELECT capr.po_distribution_id,
pod.quantity_ordered,
rcv.quantity,
capr.accrual_account_id
FROM bom.cst_ap_po_reconciliation capr,
po_distributions_all pod,
rcv_transactions rcv
WHERE capr.po_distribution_id = pod.po_distribution_id
AND capr.rcv_transaction_id = rcv.transaction_id
AND pod.org_id = :p_org_id;

Related Objects

As per the provided metadata, CST_AP_PO_RECONCILIATION has direct foreign key relationships with several key EBS base tables, defining its integration points:

  • PO_DISTRIBUTIONS_ALL: Links each reconciliation record to its originating purchase order line distribution.
  • RCV_TRANSACTIONS: Links the record to the specific receiving transaction that brought the goods into inventory or to an expense destination.
  • GL_CODE_COMBINATIONS: References the general ledger accrual account via ACCRUAL_ACCOUNT_ID, tying the procurement activity to the financial chart of accounts.
  • HR_ALL_ORGANIZATION_UNITS: Associates the transaction with an operating unit for multi-org reporting and security.

This table is also intrinsically related to the AP_INVOICE_DISTRIBUTIONS_ALL table, although not listed in the excerpt, as the final step in reconciliation is matching to an invoice distribution. It is commonly referenced in cost accounting interfaces and standard reconciliation reports within the Inventory and Cost Management modules.