Search Results get_concatenated_account




Overview
Explore in AI Chat

Overview

FUN_TRX_ENTRY_UTIL is a utility package owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It belongs to the Oracle Financials for EMEA (FUN) product family, which underpins the core Payables and Receivables transaction entry flows. The package carries an API classification of UTIL, indicating that it is not a business-facing public API in the sense of a documented, supported interface with an externally guaranteed contract, but rather an internal helper library used by other components of the transaction entry stack.

Its role is to centralize common low-level operations that would otherwise be duplicated across the modules that compose the transaction entry experience. In particular, the package resolves accounting flexfield context and derives code combination identifiers, and it provides a lightweight debugging trace facility. By isolating these routines, Oracle allows multiple entry points — the open interface loader, the web ADI integration layer, and the transactional package itself — to share consistent logic for account resolution and diagnostics.

Key Procedures and Functions

The documented interface exposes six callable units, all of which are read or helper oriented rather than transactional in nature.

  • GET_LEDGER_ID — Resolves and returns the ledger identifier applicable to the calling context, allowing downstream code to work with the correct accounting books without re-deriving that context itself.
  • GET_CONCATENATED_ACCOUNT — Produces a concatenated, human-readable representation of an accounting flexfield combination, typically assembling the individual segment values into a single display string.
  • GET_CONCAT_DESCRIPTION — Returns a concatenated description form of the account, complementing the concatenated value with descriptive segment text.
  • GET_CCID — Derives the code combination identifier for a given account specification, serving as the bridge between user-entered or imported segment values and the internal GL_CODE_COMBINATIONS key.
  • GET_DEFAULT_CCID — Returns the default code combination identifier, used when a transaction line or distribution has no explicitly supplied account.
  • LOG_DEBUG — Provides a debug logging facility used during development, diagnostics, and troubleshooting of transaction entry processing.

The ETRM documentation does not publish parameter lists for these routines. They should be treated as internal helpers whose signatures may change between patch levels.

Tables Accessed

The package reads from five tables through APPS synonyms. FND_ID_FLEX_STRUCTURES and FND_ID_FLEX_SEGMENTS supply the key flexfield definition and segment metadata needed to interpret an accounting flexfield structure and its segments. GL_CODE_COMBINATIONS is the primary lookup target for validating and retrieving code combination identifiers (CCIDs), while GL_LEDGERS supplies ledger information underpinning GET_LEDGER_ID. FUN_INTER_ACCOUNTS holds the inter-account relationships specific to the FUN product line and is consulted during account resolution logic. No insert, update, or delete activity is documented; the package is primarily a read-oriented utility layer.

Usage Notes

FUN_TRX_ENTRY_UTIL is referenced by two other packages within the APPS schema: FUN_OPEN_INTERFACE_PKG and FUN_WEBADI_PKG. This dependency pattern shows the package being invoked during open interface imports and through the Web ADI entry path, both of which need consistent account derivation and ledger resolution. It also references SYS.STANDARD, confirming standard PL/SQL runtime dependencies.

Because the package is classified as UTIL and is not exposed as a supported public API, customizations should avoid calling it directly. Instead, custom code should use the supported public APIs in the transaction entry modules, allowing Oracle to evolve these internal helpers without breaking customer extensions. When troubleshooting entry or import failures, DBMS output from LOG_DEBUG can be a useful diagnostic aid at the direction of Oracle Support.