Search Results ar_posting_report_interim_u1

Overview

The AR_POSTING_REPORT_INTERIM table is a transient data repository within Oracle E-Business Suite Receivables (AR) that facilitates the reporting of General Ledger (GL) transfer results. Its primary role is to decouple the Posting Execution report from directly querying the high-volume GL_INTERFACE table, a critical design requirement for distributed application architectures. The table is populated by the GL Transfer Program (also known as the Posting program) with summarized posting cycle data. Immediately after the Posting Execution report extracts this information for user review, the GL Transfer program purges the rows, ensuring the table remains a temporary, non-logging work area. This object is integral to the period-end process of transferring Receivables transactions to the General Ledger.

Key Information Stored

The table stores summarized financial information grouped by key posting dimensions. Its structure is defined by a composite primary key consisting of POSTING_CONTROL_ID, CURRENCY_CODE, USER_JE_CATEGORY_NAME, and CYCLE_NUMBER. The CYCLE_NUMBER column is a critical identifier, specifying the exact posting cycle iteration for the summarized row. Core financial data includes the sums of ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, and ACCOUNTED_CR amounts for the defined grouping. The SET_OF_BOOKS_ID links the data to the applicable ledger. Standard "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) track row creation and modification, though the table's transient nature limits their typical use.

Common Use Cases and Queries

The principal use case is generating the Posting Execution report, which queries this table to show users a summary of what was transferred to GL_INTERFACE, categorized by currency and journal category for a specific posting control ID and cycle. A developer or analyst might query it diagnostically during a posting run. A sample query to retrieve the core posting summary for a specific batch would be:

• SELECT posting_control_id, cycle_number, currency_code, user_je_category_name, entered_dr, entered_cr, accounted_dr, accounted_cr FROM ar.ar_posting_report_interim WHERE posting_control_id = <control_id> ORDER BY cycle_number, currency_code;

Given its interim nature, queries outside the immediate context of the GL Transfer program's execution will typically return no data, as rows are deleted after report generation.

Related Objects

The table maintains defined foreign key relationships with several foundational EBS tables, ensuring referential integrity for its key identifiers:

• AR_POSTING_CONTROL: The POSTING_CONTROL_ID column references this table, linking the interim data to the specific posting batch definition in Receivables.
• FND_CURRENCIES: The CURRENCY_CODE column references this table, validating the currency of the summarized amounts.
• GL_SETS_OF_BOOKS (Historical GL_SETS_OF_BOOKS_11I): The SET_OF_BOOKS_ID column references the ledger to which the amounts are being posted.

The unique index AR_POSTING_REPORT_INTERIM_U1 enforces the primary key constraint on the four-column combination, including CYCLE_NUMBER.