Search Results query_autoacc_def

Overview

ARP_AUTO_ACCOUNTING_BR is a server-side PL/SQL package owned by the APPS schema in the Oracle E-Business Suite Receivables (AR) module. It serves as the business rule layer behind AutoAccounting, the mechanism by which Oracle Receivables automatically derives General Ledger code combinations for transactions, receipts, distributions, and remittances without manual entry. The package is declared with AUTHID CURRENT_USER and exposes the subtype ae_sys_rec_type from ARP_ACCT_MAIN, public error buffers (g_errorbuf and g_error_buffer), and the user-defined exception no_ccid. Its primary responsibility is to resolve a valid Accounting Flexfield combination ID (CCID) based on AutoAccounting rules configured against transaction types, receipt methods, and bank accounts, and to support both programmatic calls and interactive lookups. The header identifies the object as version 120.2, illustrating its maturity within the Receivables code line.

Key Procedures and Functions

• DO_AUTOACCOUNTING — The documented entry point for server-side autoaccounting. It accepts a mode indicating Insert, Update, Delete, or Get, an account class (for example REC, UNPAIDREC, FACTOR, or REMITTANCE), and optional identifiers such as customer_trx_id, request_id, and a passed_ccid. In Get mode, the caller inspects the returned ccid for a value of -1 to determine that no code combination could be derived. In non-Get modes, the procedure raises the no_ccid exception if derivation fails, populating g_error_buffer with detail. It also raises NO_DATA_FOUND when no rows are selected.
• QUERY_AUTOACC_DEF — Retrieves the configured AutoAccounting definition rules that govern how a code combination should be built for a given account class and context.
• SEARCH_GLCC_FOR_CCID — Locates the appropriate GL_CODE_COMBINATIONS entry (CCID) matching the segment values derived from AutoAccounting rules, and is the procedure most relevant to users investigating the search_glcc_for_ccid term.
• TEST_BUILD_SQL — Builds and validates the dynamic SQL used to query GL_CODE_COMBINATIONS, supporting diagnostic and testing scenarios.
• INIT — Initializes package state, clearing error buffers before processing.

Tables Accessed

The package reads and writes across several Receivables and General Ledger tables through APPS synonyms. RA_ACCOUNT_DEFAULTS and RA_ACCOUNT_DEFAULT_SEGMENTS provide the AutoAccounting rule definitions and segment sourcing. RA_CUST_TRX_TYPES and AR_RECEIPT_METHOD_ACCOUNTS supply the context keys that select which rules apply. GL_CODE_COMBINATIONS is queried to resolve and validate the combined CCID, while RA_CUST_TRX_LINE_GL_DIST, AR_DISTRIBUTIONS, HZ_CUST_SITE_USES, and DBMS_SQL, along with PLITBLM, support distribution creation, dynamic SQL execution, and internal table handling.

Usage Notes

ARP_AUTO_ACCOUNTING_BR is typically invoked indirectly through the AutoAccounting workflow triggered by Receivables transaction entry, receipt application, and distribution workflows. Custom code and extensions may call DO_AUTOACCOUNTING directly when generating distributions programmatically, while SEARCH_GLCC_FOR_CCID and TEST_BUILD_SQL are useful for diagnosing failures where no valid CCID is returned. Because the package relies on AOL error stack messaging and the no_ccid exception, callers should consistently check g_error_buffer after any failure. This object is referenced by one other package; it is documented as API classification OTHER and is not intended as a public open-interface API.