Search Results ar_payment_schedule_id

Overview

The FV_AAN_MATCHES_TEMP table is a temporary data structure within the Federal Financials (FV) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves a critical role in the AR/AP Netting (AAN) process, which is a core federal financial management function for offsetting accounts receivable against accounts payable. Specifically, this table acts as a transient repository that stores the detailed match entries identified by the netting engine. It holds the relationships between specific customer transactions (AR) and supplier invoices (AP) that are eligible for offset within a given netting run, facilitating the generation of netting transactions and supporting documents.

Key Information Stored

The table's composite primary key defines the unique combination of entities required for a single netting match. The key columns are CHECKRUN_NAME, CUSTOMER_TRX_ID, AR_PAYMENT_SCHEDULE_ID, AP_INVOICE_ID, and AP_PAYMENT_NUM. Of particular relevance to the user's search, the AP_INVOICE_ID column is a foreign key that directly links each match entry to a specific payable invoice record in the AP_INVOICES_ALL table. This column is essential for identifying which supplier invoice is being proposed for offset. The CHECKRUN_NAME links the match to the specific netting run definition, while the CUSTOMER_TRX_ID and AR_PAYMENT_SCHEDULE_ID columns identify the receivable transaction and its payment schedule being netted.

Common Use Cases and Queries

The primary use case is supporting the AR/AP Netting process. Data is populated into this table during the execution of a netting run, where the system identifies eligible invoice pairs based on predefined criteria. Common queries involve reviewing the proposed matches before finalization or troubleshooting netting runs. A typical query to examine all matches for a specific payable invoice would be:

• SELECT checkrun_name, customer_trx_id, ap_invoice_id FROM fv_aan_matches_temp WHERE ap_invoice_id = :invoice_id;

Another reporting use case is to join with the AP_INVOICES_ALL and RA_CUSTOMER_TRX_ALL tables to create a detailed match report showing invoice numbers and amounts for a specific netting run.

Related Objects

Based on the documented foreign key relationships, FV_AAN_MATCHES_TEMP has direct dependencies on two core EBS tables:

• AP_INVOICES_ALL: The table is referenced via the AP_INVOICE_ID column. This relationship provides access to all details of the payable invoice being netted, such as invoice number, amount, vendor, and invoice date.
• AP_INV_SELECTION_CRITERIA_ALL: The table is referenced via the CHECKRUN_NAME column. This links the match entries back to the specific netting run setup and its selection parameters that generated these matches.

It is important to note the metadata indicates this table is "Not implemented in this database," which may refer to a specific ETRM instance. In a live EBS environment, this table is typically implemented as a Global Temporary Table (GTT), meaning its data is session-specific and automatically truncated, aligning with its transient role in the netting process.