Results for “end_print_document”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_INV_SELECTION_CRITERIA_ALL is the Oracle Payables table that stores payment batch invoice selection criteria. Each row represents the header definition of a payment batch — the user-supplied filters and options that the Payment Batch (payment run) process uses to select invoices for payment and to drive check or electronic payment generation. It is owned by the AP schema and is populated whenever a user creates a payment batch from the Payment Workbench or the Payment Batch window, or when a batch is created programmatically through the Payables payment APIs.

The table sits at the center of the payment batch lifecycle. The primary key AP_INVOICE_SELECTION_CRITER_PK corresponds to the CHECKRUN_ID column, which is the surrogate identifier of the payment batch. Foreign-key metadata also identifies CHECKRUN_NAME with ORG_ID as the unique business-key candidate (AP_INV_SELECTION_CRITERIA_U1), meaning the batch name is unique per operating unit. From a Data Vault modeling perspective, the mined FK structure suggests this object behaves as a hub: CHECKRUN_ID/CHECKRUN_NAME is the business key referenced by numerous downstream satellites and link-style detail tables (checks, selected invoices, groups, confirmations).

Key Information Stored

The table contains 93 documented columns. The most functionally significant are:

• CHECKRUN_ID — surrogate primary key of the payment batch; referenced by many child tables.
• CHECKRUN_NAME and ORG_ID — business-key candidate (unique index U1); the user-visible batch name scoped to the operating unit.
• CHECK_DATE, PAY_THRU_DATE, PAY_FROM_DATE, FUTURE_DATED_PAYMENT_FLAG, PAY_ONLY_WHEN_DUE_FLAG, ANTICIPATED_VALUE_DATE — date and timing filters applied during selection.
• BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, CHECK_STOCK_ID — disbursement bank account and check stock used for the run.
• CURRENCY_CODE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE — currency scope of the batch.
• PAYMENT_METHOD_LOOKUP_CODE / PAYMENT_METHOD_CODE, PAYMENT_PROFILE_ID — payment instrument definition.
• VENDOR_ID, VENDOR_PAY_GROUP, VENDOR_TYPE_LOOKUP_CODE, HI_PAYMENT_PRIORITY, LOW_PAYMENT_PRIORITY — supplier scope and priority band.
• MIN_CHECK_AMOUNT, MAX_PAYMENT_AMOUNT, MAX_OUTLAY, ZERO_AMOUNTS_ALLOWED, ZERO_INVOICES_ALLOWED — amount thresholds.
• FIRST_VOUCHER_NUMBER, NEXT_VOUCHER_NUMBER, START_PRINT_DOCUMENT, END_PRINT_DOCUMENT — document numbering range.
• STATUS, TEMPLATE_FLAG, TEMPLATE_ID, RESUBMIT_FLAG — batch state and templating.
• BATCH_SET_ID, BATCH_SET_LINE_ID, PAY_GROUP_OPTION, CURRENCY_GROUP_OPTION, LE_GROUP_OPTION, OU_GROUP_OPTION — grouping and batch-set linkage.
• ATTRIBUTE1–15 and ATTRIBUTE_CATEGORY — DFF support.

Common Use Cases and Queries

Typical usages include auditing active payment batches, reporting on selection criteria, and diagnosing why an invoice was or was not selected. A common query retrieves batch headers per operating unit:

• SELECT checkrun_id, checkrun_name, check_date, status, bank_account_name FROM ap.ap_inv_selection_criteria_all WHERE org_id = :p_org_id AND status = 'CREATED';
• Join to AP_SELECTED_INVOICES_ALL on CHECKRUN_NAME to view the invoices chosen for a batch, and to AP_UNSELECTED_INVOICES_ALL on CHECKRUN_ID for rejects.
• Join to AP_CHECKS_ALL on CHECKRUN_ID or CHECKRUN_NAME to obtain payment documents produced.
• Compare against FV_AAN_MATCHES_TEMP on CHECKRUN_NAME — the search term that led here — since that temporary table is keyed by CHECKRUN_NAME and is populated by Funds/Public Sector matching processes that reference the payment batch header.
• Template reporting: SELECT template_id, checkrun_name FROM ap.ap_inv_selection_criteria_all WHERE template_flag = 'Y';

Related Objects

The table is both a child of configuration objects and a parent of payment-processing detail tables. Key relationships include:

• AP_CHECKS_ALL (CHECKRUN_ID, CHECKRUN_NAME) — payment documents generated for the batch.
• AP_SELECTED_INVOICES_ALL and AP_SELECTED_INVOICE_CHECKS_ALL (CHECKRUN_NAME) — invoices picked and their payment linkage.
• AP_UNSELECTED_INVOICES_ALL (CHECKRUN_ID) — invoices rejected during selection.
• AP_LE_GROUP, AP_OU_GROUP, AP_PAY_GROUP, AP_CURRENCY_GROUP (all on CHECKRUN_ID) — grouping criteria used by the batch.
• FV_AAN_MATCHES_TEMP and FV_AP_CASH_POS_TEMP (CHECKRUN_NAME / CHECKRUN_ID) — Funds/Public Sector temporary matching and cash-position staging tables.
• AP_AWT_TEMP_DISTRIBUTIONS_ALL, AP_CHECKRUN_CONFIRMATIONS_ALL, AP_CHECKRUN_CONC_PROCESSES_ALL — withholding, confirmation, and concurrent-process data tied to the batch.
• AP_CHECK_STOCKS_ALL, AP_BANK_ACCOUNTS_ALL, IBY_ACCT_PMT_PROFILES_B, FND_CURRENCIES, GL_DAILY_CONVERSION_TYPES, AP_PBATCH_SETS_ALL / AP_PBATCH_SET_LINES_ALL — the referenced configuration parents.