Search Results po_accrual_reconcile_temp_all




Overview
Explore in AI Chat

Overview

The PO_ACCRUAL_RECONCILE_TEMP_ALL table is a temporary data store within the Oracle E-Business Suite Purchasing (PO) module, specifically designed to support the Accrual Reconciliation Report. Its primary role is to act as a staging area during the report's execution, holding intermediate calculation results and aggregated data that links procurement transactions to their corresponding accounting accruals. This structure enables the complex reconciliation process between purchase order distributions, goods receipts, and inventory or work-in-process transactions before final financial posting. The table is session-specific, meaning data is typically inserted, processed, and purged within the context of a single report run.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented foreign key relationships explicitly reveal the critical identifiers the table stores to perform its reconciliation function. Each record likely contains key transaction IDs and associated master data IDs to link financial events. The core stored data includes PO_DISTRIBUTION_ID, linking to purchase order charges; PO_TRANSACTION_ID, for receiving transactions; and INV_TRANSACTION_ID or WIP_TRANSACTION_ID, for inventory or manufacturing cost movements. Furthermore, it stores PO_HEADER_ID, PO_LINE_ID, VENDOR_ID, and INVOICE_ID to provide document and supplier context. Crucially, it holds ACCRUAL_ACCOUNT_ID to tie transactions to the general ledger and REASON_ID for transaction rationale.

Common Use Cases and Queries

The singular, primary use case for this table is the generation of the Accrual Reconciliation Report. This report is critical for period-end close and audit processes, verifying that purchase accrual liabilities in the general ledger correctly reflect received but not invoiced goods and services. A typical process involves a concurrent request populating this temporary table with data for a selected operating unit, date range, and other parameters. Sample SQL for investigating report data would involve joining to the referenced key tables:

  • Identifying reconciled distributions for a specific PO: SELECT temp.*, poh.segment1 FROM po_accrual_reconcile_temp_all temp JOIN po_headers_all poh ON temp.po_header_id = poh.po_header_id WHERE poh.segment1 = '<PO_NUMBER>';
  • Analyzing accrual account activity: SELECT gcc.segment1, gcc.segment2, temp.* FROM po_accrual_reconcile_temp_all temp JOIN gl_code_combinations gcc ON temp.accrual_account_id = gcc.code_combination_id;

Direct queries against this table are generally only performed for diagnostic purposes during report troubleshooting.

Related Objects

As defined by its foreign keys, PO_ACCRUAL_RECONCILE_TEMP_ALL has a central relationship with core transaction tables across multiple EBS modules. In Purchasing, it directly references PO_DISTRIBUTIONS_ALL, PO_HEADERS_ALL, and PO_LINES_ALL. For receiving transactions, it links to RCV_TRANSACTIONS. For cost accounting, it relates to MTL_MATERIAL_TRANSACTIONS and WIP_TRANSACTIONS. Its integration with Payables is via AP_INVOICES_ALL and with supplier master data via PO_VENDORS. Finally, it connects to the General Ledger through GL_CODE_COMBINATIONS and to transaction coding via MTL_TRANSACTION_REASONS. This web of relationships underscores its role as a nexus for multi-module reconciliation data.