Results for “ce_999”

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

Overview

CE_AUTO_BANK_MATCH is the core PL/SQL package body within Oracle Cash Management (CE) that implements the automatic bank statement reconciliation engine. Its primary business function is to compare bank statement lines against Oracle E-Business Suite transaction records and, where a confident match is found, clear the corresponding transactions automatically. The package operates against unreconciled statement lines held in CE_STATEMENT_LINES, matching them against payment, receipt, and miscellaneous transaction sources, then applying reconciliation results through the Cash Management tables.

This package is the subject of the search term "ce_999" because it exposes a set of match rule configuration accessors and mutators named around numeric rule identifiers, including SET_999, UNSET_999, SET_801, UNSET_801, SET_101, UNSET_101, and their counterparts. These procedures allow callers to toggle individual match rules on and off, and to read or write the underlying rule parameters. In Oracle EBS 12.1.1 and 12.2.2 the object is owned by APPS and classified as an OTHER API; it is referenced by twelve other packaged objects, indicating its role as a low-level engine consumed by reconciliation concurrent programs and user-facing flows rather than being an end-user entry point itself.

The header comment identifies the source as ceabrmab.pls, revision 120.96.12020000.18, dated 2013/04/02, confirming long-term maintenance across the 12.x release family.

Key Procedures and Functions

The 39 documented procedures fall into several functional families:

• Rule setters and getters: SET_101, SET_200, SET_200_GROUP, SET_222, SET_260, SET_801, SET_999, and GET_101, GET_200 configure and retrieve individual auto-match rules. Each numeric suffix denotes a specific matching strategy or segment of the reconciliation logic.
• Complementary unset operations: UNSET_101, UNSET_200, UNSET_200_GROUP, UNSET_222, UNSET_260, UNSET_801, and UNSET_999 disable the corresponding rules before a new reconciliation run.
• Aggregate controls: SET_ALL and UNSET_ALL apply or reset the entire rule set in a single call, which is the normal usage pattern for a batch reconciliation job.
• Revision metadata: SPEC_REVISION and BODY_REVISION return the package specification and body version strings, used for diagnostics and patch validation.

Together these procedures form the configuration surface through which the Cash Management reconciliation process determines which statement lines are eligible for automatic matching and which algorithms are applied.

Tables Accessed

The package reads and writes a documented set of APPS synonyms. Cash Management tables — CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL, CE_STATEMENT_HEADERS, CE_STATEMENT_LINES, and CE_TRANSACTION_CODES — supply bank account definitions, statement data, and transaction type classifications. Payables and payments tables — AP_CHECKS_ALL, AP_INV_SELECTION_CRITERIA_ALL, IBY_PAYMENTS_ALL, and PAY_PAYMENT_TYPES — provide the payment-side records being matched. Receivables tables — AR_CASH_RECEIPT_HISTORY_ALL, AR_RECEIPT_METHODS, and AR_SYSTEM_PARAMETERS_ALL — supply receipt-side data. FND_CURRENCIES, GL_DAILY_RATES, and FND_LOOKUP_VALUES provide currency conversion and reference lookups required for amount comparison and rounding.

Usage Notes

CE_AUTO_BANK_MATCH is normally invoked indirectly. The Automatic Reconciliation concurrent program calls it to enable the configured rules, iterate bank accounts and statement headers, and process statement lines. It is not designed for ad hoc invocation from SQL*Plus without the surrounding reconciliation context and transaction control. Custom code should call only the documented rule accessors and revision functions, never the internal cursors, and should respect the standard EBS error-handling and savepoint conventions. Because twelve packages depend on it, changes to rule numbering or parameter semantics carry wide integration risk across releases 12.1.1 and 12.2.2.