Search Results ap_inv_selection_criteria_all




Overview
Explore in AI Chat

Overview

The AP_INV_SELECTION_CRITERIA_ALL table is a core technical object within the Oracle E-Business Suite Payables module (AP). It serves as the master repository for storing the specific selection criteria defined for a payment batch, also known as a checkrun. When a user initiates the "Build Payments" or "Format Payments" process, they define a set of rules to determine which invoices are eligible for payment. These rules, which include parameters such as payment currency, bank account, payment method, and due date ranges, are persisted in this table. Each record is uniquely identified by a CHECKRUN_ID and acts as the central configuration for a single payment batch execution, driving the entire invoice selection and payment generation workflow in Oracle Payables for both releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is the CHECKRUN_ID, which links the criteria to the resulting payment batch. Critical foreign key columns define the operational parameters of the batch. The BANK_ACCOUNT_ID links to AP_BANK_ACCOUNTS_ALL, specifying the source of funds. CURRENCY_CODE and EXCHANGE_RATE_TYPE (linked to FND_CURRENCIES and GL_DAILY_CONVERSION_TYPES, respectively) control the payment currency and conversion rules. For complex batch setups, BATCH_SET_ID and BATCH_SET_LINE_ID link to the AP_PBATCH_SETS_ALL and AP_PBATCH_SET_LINES_ALL tables. Other significant columns, inferred from standard functionality, typically include selection criteria like PAYMENT_METHOD_CODE, PAY_GROUP_CODE, VENDOR_ID ranges, invoice due date parameters, and payment priority rules, which collectively filter the payable invoices for inclusion.

Common Use Cases and Queries

The primary use case is auditing and troubleshooting payment batch processes. Analysts can query this table to understand why specific invoices were selected or excluded. A common reporting query retrieves the criteria for a specific payment batch run. For example:

  • SELECT checkrun_name, currency_code, bank_account_id, creation_date FROM ap_inv_selection_criteria_all WHERE checkrun_id = :p_checkrun_id;

Another frequent scenario involves tracing the lineage of payments back to their originating criteria. Integration or data repair scripts may also reference this table to validate or correct batch configurations. Support personnel often join this table with AP_SELECTED_INVOICES_ALL or AP_CHECKS_ALL to correlate payment outputs with the input rules that generated them, providing a complete audit trail from criteria definition to final payment.

Related Objects

As indicated by the extensive foreign key relationships, AP_INV_SELECTION_CRITERIA_ALL is a pivotal hub in the Payables schema. It is directly referenced by numerous key transaction tables. AP_CHECKS_ALL stores the final payment documents created from the batch. AP_SELECTED_INVOICES_ALL and AP_UNSELECTED_INVOICES_ALL log the invoices that were included or excluded based on the criteria. Temporary and work tables like AP_AWT_TEMP_DISTRIBUTIONS_ALL and AP_CHECKRUN_CONC_PROCESSES_ALL also link to it during batch processing. Furthermore, grouping tables such as AP_PAY_GROUP, AP_LE_GROUP, and AP_CURRENCY_GROUP use the CHECKRUN_ID to store detailed, multi-record selection criteria defined within the batch, forming a hierarchical data model for complex payment instructions.