Search Results get_mapping_flexfield_char

Overview

XLA_AE_SOURCES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category. It forms part of the Subledger Accounting (XLA) infrastructure introduced in Oracle EBS 11i and carried forward into 12.1.1 and 12.2.2. Its principal business function is to resolve the descriptive and derived values that the Accounting Engine attaches to journal entry lines during subledger accounting. Specifically, it maps XLA source codes, accounting attribute codes, mapping set rules, and lookup values into the human-readable strings and numeric values that ultimately populate the accounting flexfield and descriptive segments of a subledger journal entry.

The package was created in November 2002 by K. Boussema and underwent repeated revision between 2003 and 2004, including a redesign for the bulk (array-based) processing approach adopted by the Accounting Engine, the introduction of error message handling, and the removal of the get_flex_value_meaning function. Those revisions reflect the package's tight coupling to the bulk journal entry processing model used by xla_ae_journal_entry_pkg.

Key Procedures and Functions

Eleven documented program units are exposed by the package:

• GETSYSTEMSOURCENUM — returns the numeric value of a system source for a given source code, source type, and source application.
• GETSYSTEMSOURCEDATE — returns the date value of a system source.
• GETSYSTEMSOURCECHAR — returns the character value of a system source.
• GETLOOKUPMEANING — resolves a lookup code to its meaning via FND_LOOKUP_VALUES.
• GET_MAPPING_FLEXFIELD_NUMBER — returns the numeric value derived from a mapping set flexfield rule.
• GET_MAPPING_FLEXFIELD_CHAR — the function most commonly searched for; it returns the character value produced by evaluating a mapping set rule against an accounting flexfield or descriptive flexfield source.
• DATE_TO_CHAR — converts an internal date representation to a character string for journal entry display.
• GETAPPLICATIONNAME — returns the application name from FND_APPLICATION_TL.
• GETSOURCENAME — returns the translated source name from XLA_SOURCES_TL.
• GETACCOUNTINGSOURCENAME — returns the accounting source name used in journal entry descriptions.
• GETCOMPONENTNAME — returns a component name for use in journal line and header descriptions.

The package also defines the cached record type t_rec_meaning and the associative array t_array_meaning, which cache flex value meanings (up to 4000 characters per element) to reduce repeated lookups during bulk accounting runs.

Tables Accessed

The package reads translation and definition tables to resolve names and meanings: FND_APPLICATION_TL for application names, FND_LOOKUP_VALUES for lookup meanings, XLA_SOURCES_TL for source names, XLA_ACCT_ATTRIBUTES_TL and XLA_ACCT_LINE_TYPES_TL for accounting attribute and line type descriptions, XLA_SEG_RULES_TL for segment rule text, XLA_DESCRIPTIONS_TL for journal description components, and XLA_MAPPING_SETS_TL together with XLA_MAPPING_SET_VALUES for mapping set rule evaluation. PLITBLM is used as the PL/SQL table-to-VARCHAR2 conversion utility for array handling. All references are made through APPS synonyms, consistent with standard XLA coding practice.

Usage Notes

XLA_AE_SOURCES_PKG is not invoked directly by end users. It is called internally by the Subledger Accounting program (XLAABL) and related Accounting Engine packages during journal entry creation, and it is referenced by approximately fifty other packages within the XLA schema. Customers and partners typically call it only from custom subledger accounting programs, custom sources, or custom mapping set logic that must reproduce the same value resolution the seeded Accounting Engine performs. When extending subledger accounting in 12.1.1 or 12.2.2, developers should treat this package as a read-only utility and avoid modifying it, since changes affect all fifty dependent packages.