Search Results fii_flex_mapping




Overview
Explore in AI Chat

Overview

FII_FLEX_MAPPING is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. Its name and dependency signature identify it as a component of the Oracle Financial Intelligence / Enterprise Territory and Resource Management (ETRM) family of utilities, which supply the accounting flexfield resolution logic used when transactional data is moved between operational subledgers and the analytical or warehouse schemas. The package exposes a small, focused API for translating a flexfield value or key into its stored equivalent, backed by a session-level memory cache that avoids repeated lookups against the general ledger chart of accounts.

The object is reported as VALID in the ETRM 12.1.1 metadata and is classified as API type OTHER, indicating that it is an internal utility rather than a public, supported interface. It depends on PLITBLM (the standard PL/SQL index-by table type declarations) and STANDARD, and it is referenced by fifteen other database objects, confirming its role as a shared low-level service consumed by higher-level ETRM processing units. No object in the database is documented as referencing it from outside this family.

Key Procedures and Functions

  • GET_VALUE — Resolves and returns the value associated with a supplied flexfield mapping entry, applying the package's cached lookup rules so that callers receive a consistent result without directly querying GL_CODE_COMBINATIONS.
  • GET_FK — Returns the corresponding key or identifier (foreign key) for a mapping, providing the inverse of the value resolution path used by GET_VALUE.
  • INIT_CACHE — Initializes the in-memory cache structures used by the resolution routines, typically invoked once per session or batch before repeated mapping requests are issued.
  • FREE_MEM_ALL — Releases the memory held by the cached mapping data, allowing the session or concurrent request to reclaim resources after processing completes.

The four documented routines follow a conventional load-resolve-release pattern: initialization, one or more value or key resolutions, and explicit cleanup. Parameter lists are not documented in the available metadata and are therefore not reproduced here.

Tables Accessed

  • GL_CODE_COMBINATIONS — the primary source of accounting flexfield combinations used to validate and resolve mapping values.
  • EDW_LOCAL_SET_OF_BOOKS — supplies set of books context, which determines the chart of accounts against which flexfield resolution must occur.
  • EDW_LOCAL_EQUI_SET_OF_BOOKS — provides the equivalent or translated set of books reference used when mapping across multiple ledgers.
  • PLITBLM — the standard public package of PL/SQL table type definitions used to hold the cached mapping structures in memory.

The package is documented as reading these objects through APPS synonyms; no insert, update, or delete activity against them is recorded.

Usage Notes

FII_FLEX_MAPPING is an internal dependency rather than a user-invoked interface. It is called by the fifteen dependent ETRM objects during reporting, data extraction, and flexfield translation routines, most commonly within concurrent program execution or batch data movement where many mapping requests are processed in a single run. In such contexts INIT_CACHE should be called before the first resolution and FREE_MEM_ALL after the last, so that the cache is populated once and released deterministically.

Because the package is classified as OTHER and is not documented as a public API, customizations should avoid calling it directly; developers requiring flexfield resolution are advised to use supported Oracle APIs such as FND_FLEX_EXT or the standard GL interfaces. Any reference to this package in custom code creates a dependency on an unsupported internal object, and Oracle EBS 12.1.1 to 12.2.2 upgrades may alter its behavior without notice.