Search Results selected_check_id




Overview
Explore in AI Chat

Overview

The AP_SELECTED_INVOICE_CHECKS_ALL table is a historical data object within Oracle E-Business Suite Payables (AP) modules for releases 12.1.1 and 12.2.2. As explicitly noted in the official ETRM documentation, its status is "No Longer Used." This designation indicates that the table is retained primarily for backward compatibility and data reference, with its original transactional logic likely superseded by newer application features or architectural changes. Its historical role was to serve as a junction table, linking selected invoices to specific checks within the payment processing workflow, particularly during the invoice selection and check creation stages of a payment batch.

Key Information Stored

The table's structure, inferred from its primary and foreign key relationships, was designed to store associations between payment instruments and selection criteria. The primary key is SELECTED_CHECK_ID. Key foreign key columns illustrate its integrative purpose: CHECKRUN_NAME links to AP_INV_SELECTION_CRITERIA_ALL, connecting the record to a specific payment batch process. CHECK_ID references AP_CHECKS_ALL, tying it to the actual check document. VENDOR_ID and VENDOR_SITE_ID link to PO_VENDORS and PO_VENDOR_SITES_ALL, respectively. Additional columns like CURRENCY_CODE and EXTERNAL_BANK_ACCOUNT_ID (linked to AP_BANK_ACCOUNTS_ALL) provided necessary financial context for the payment association.

Common Use Cases and Queries

Given its "No Longer Used" status, direct operational or transactional use cases are obsolete. Current implementations should utilize the standard Payables APIs and updated table structures for payment processing. The primary contemporary use is for historical data analysis or forensic reporting on legacy payment batches. A sample diagnostic query might join to related active tables to investigate old payment data:

  • SELECT asic.checkrun_name, ac.check_number, pv.vendor_name
    FROM ap_selected_invoice_checks_all asic
    JOIN ap_checks_all ac ON ac.check_id = asic.check_id
    JOIN po_vendors pv ON pv.vendor_id = asic.vendor_id
    WHERE asic.creation_date > SYSDATE - 3650;

Such queries are typically executed for data audits or migration validation, not for active business processes.

Related Objects

The table's relationships are defined by its foreign key constraints. It is centrally linked to the invoice selection process via AP_INV_SELECTION_CRITERIA_ALL and to the payment document via AP_CHECKS_ALL. It references master data tables for suppliers (PO_VENDORS, PO_VENDOR_SITES_ALL), currencies (FND_CURRENCIES), and bank accounts (AP_BANK_ACCOUNTS_ALL). Crucially, it is referenced by the AP_SELECTED_INVOICES_ALL table through two foreign key columns (PAY_SELECTED_CHECK_ID and PRINT_SELECTED_CHECK_ID), indicating its past role in connecting selected invoice lines to payment and print check operations.