Results for “ap_check_stocks_active_v”

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

Overview

AP_CHECK_STOCKS_ACTIVE_V is a Payables (AP) view that exposes the active payment document (check stock) definitions maintained in Oracle EBS. It presents a denormalized, query-friendly projection of check stock records joined to their associated bank accounts, check formats, lookup meanings, concurrent program names, and document categories. The view is documented in ETRM as Release 10SC only and is described as "Not implemented in this database," which indicates that in the referenced instance the underlying object is not deployed. Its principal role is reporting and integration: it allows external systems and internal reports to retrieve check stock configuration — including the accounting code combinations assigned to bank charges, bank errors, cash clearing, and future-dated payments — without navigating the multi-table joins required against the base AP tables.

Underlying Base Objects

The documented view text defines the object over the following primary base tables:

• AP_CHECK_STOCKS (aliased ACS) — the driving table supplying the check stock identifier, bank account, charges/errors/cash clearing code combinations, clearing days, document numbering state, disbursement type, document category, organization, and audit columns.
• AP_CHECK_FORMATS (aliased ACF) — supplies check format attributes such as format name, payment method lookup code, currency code, multi-currency flag, zero-amount behaviors, and invoices per stub.
• AP_BANK_ACCOUNTS (aliased ABA) — provides bank account name, account number, currency code, set of books, and multi-currency/zero-amount flags.
• AP_BANK_BRANCHES (aliased ABB, referenced for BANK_NUM) — supplies the bank number.
• Lookup and program reference sources (ALC1, ALC2, APP1, APP2, FDSC) — resolve lookup display values for disbursement type and payment method, concurrent program names for format payments and remittance, and the document category name.

ETRM records no documented referenced base objects and no owner for the 12.2.2 metadata, and the object is not implemented in the referenced database, so the join behavior above is derived from the documented view text rather than an active catalog entry.

Key Columns

• CHECK_STOCK_ID, NAME, BANK_ACCOUNT_ID — identity of the check stock and its owning bank account.
• BANK_CHARGES_CCID, BANK_ERRORS_CCID, CASH_CLEARING_CCID, FUTURE_PAY_CODE_COMBINATION_ID — accounting code combinations used for bank charges, bank errors, cash clearing, and future-dated payments; these are the columns most relevant to code combination ("CCID") lookups.
• DISBURSEMENT_TYPE_LOOKUP_CODE / DISBURSEMENT_TYPE and PAYMENT_METHOD_LOOKUP_CODE / PAYMENT_METHOD — coded value and its displayed meaning.
• LAST_AVAILABLE_DOCUMENT_NUM, LAST_DOCUMENT_NUM, NUM_SETUP_CHECKS — document numbering and setup state.
• CLEARING_DAYS, INACTIVE_DATE, FUTURE_DATED_PAYMENTS_FLAG — clearing and availability attributes.
• BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM, BANK_CURRENCY_CODE, SET_OF_BOOKS_ID, BANK_NUM — bank account context.
• CHECK_FORMAT_NAME, FORMAT_CURRENCY_CODE, INVOICES_PER_STUB, FORMAT_PAYMENTS_PROGRAM_NAME, REMITTANCE_PROGRAM_NAME — format and program context.
• DOC_CATEGORY_CODE / DOC_CATEGORY_NAME and IN_USE_BY (derived via AP_AUTO_PAYMENT_PKG.GET_CHECK_STOCK_IN_USE_BY) — categorization and concurrency usage.

Common Use Cases and Queries

A frequent scenario is resolving the bank errors code combination configured for a check stock, which aligns with the search term "bank_errors_ccid." Reports and integrations use the view to enumerate active check stocks with their accounting code combinations, currency restrictions, and payment programs.

• Identify the bank errors account for a given check stock or bank account.
• List active check stocks by currency, payment method, and set of books.
• Audit clearing days, code combinations, and format assignments.

Sample query:

• SELECT check_stock_id, name, bank_account_id, bank_account_name, bank_currency_code,
•        bank_errors_ccid, bank_charges_ccid, cash_clearing_ccid, clearing_days
• FROM  ap_check_stocks_active_v
• WHERE bank_account_id = :p_bank_account_id
• AND   NVL(inactive_date, SYSDATE + 1) > SYSDATE;

Because the view is documented as not implemented in the referenced 12.1.1/12.2.2 database, availability should be verified against the target instance before deployment; where absent, the equivalent join across AP_CHECK_STOCKS, AP_CHECK_FORMATS, and AP_BANK_ACCOUNTS must be used instead.