Search Results is_ccid_exists

Overview

PSA_MFAR_UTILS is a utility package body owned by APPS within the Oracle E-Business Suite. The package forms part of the Public Sector Applications (PSA) multi-fund accounting and receivables processing infrastructure, providing shared helper routines that support account derivation, code combination validation, and distribution logging for Oracle Receivables transactions. In Oracle EBS 12.1.1 and 12.2.2, the package is classified as an "OTHER" API, meaning it is a supporting internal utility rather than a formally published public interface.

The core business purpose of PSA_MFAR_UTILS is to bridge the gap between transaction-level accounting data and the underlying Accounting Flexfield structures. It resolves chart of accounts identifiers, derives code combinations (CCIDs) appropriate for a given transaction and organization, applies mapping rules, and maintains an audit trail of distribution activity. The package is referenced by eight other packages, indicating that it functions as a shared dependency in the Receivables and multi-fund accounting flows rather than being called directly by end-user interfaces.

Key Procedures and Functions

• GET_USER_CATEGORY_NAME — Retrieves the user-defined category name associated with a transaction class or receipt activity, supporting category-driven account derivation.
• OVERRIDE_SEGMENTS — Applies overriding segment values to an account structure, allowing configured mapping rules to replace default Accounting Flexfield segment values prior to CCID generation.
• INSERT_CCID — Inserts a fully resolved code combination identifier together with its segment information into an in-memory PL/SQL table. This procedure is the routine most commonly referenced in searches for "insert_ccid," because it is the mechanism by which account combinations are accumulated for batch processing without repeated database round-trips.
• IS_CCID_EXISTS — Tests whether a given code combination already exists, typically used to prevent duplicate entries or unnecessary validation calls.
• INSERT_DISTRIBUTIONS_LOG — Writes entries into the distributions log table, providing an audit record of accounting distributions generated or processed by the package's callers.
• PSA_MF_ORG_DETAILS — Returns organizational detail information relevant to multi-fund accounting, such as organization identifiers used to scope account mapping.
• GET_AR_SOB_ID — Determines the Receivables set of books identifier, allowing callers to resolve the correct accounting context for receivables transactions.
• GET_REC_CCID — Derives the code combination identifier for a receivables accounting entry by combining mapping, override, and validation logic.
• GET_COA — Returns the chart of accounts identifier associated with a ledger or set of books, establishing the structure against which segments are validated.
• ACCOUNTING_METHOD — Exposes the accounting method configured for the implementation, driving how revenue and receivable accounts are selected.

Tables Accessed

The package reads and writes a defined set of APPS synonym tables. Accounting structure resolution relies on FND_ID_FLEX_STRUCTURES, FND_ID_FLEX_SEGMENTS, FND_SEGMENT_ATTRIBUTE_VALUES, and FND_FLEX_VALUES for key flexfield configuration and segment validation, with GL_CODE_COMBINATIONS holding the resulting account combinations. GL_JE_CATEGORIES supports journal category attribution. Setup and configuration data come from PSA_IMPLEMENTATION_ALL, PSA_MF_ACCOUNT_MAPPING_ALL, and PSA_MF_ACCT_MAP_HEADER_ALL, which define the multi-fund mapping rules the package applies. Receivables context is drawn from AR_SYSTEM_PARAMETERS, RA_CUSTOMER_TRX_ALL, and RA_CUST_TRX_LINE_GL_DIST_ALL. Audit output is written to PSA_MF_DISTRIBUTIONS_LOG, and PLITBLM is used as the in-memory PL/SQL table type for accumulating CCID and segment information processed by INSERT_CCID.

Usage Notes

PSA_MFAR_UTILS is an internal helper package and should not be called directly from custom code unless the calling program fully replicates the expected setup context. It is typically invoked from higher-level PSA and Receivables packages during account generation, distribution creation, and mapping validation, and it is not exposed through a standard concurrent program or Oracle Forms interface. Because it maintains session-level PL/SQL table state through INSERT_CCID, callers must clear or reinitialize that state between logical batches to avoid cross-contamination of segment information. Any modification to the package should be treated as a customization requiring regression testing across the eight dependent packages. In 12.2.2 environments with multiple ledgers, the set of books resolution performed by GET_AR_SOB_ID and GET_COA is particularly sensitive to ledger configuration, and callers should ensure the correct operating unit and ledger context is initialized before invocation.