Search Results xla_mapping_sets_f_pkg




Overview
Explore in AI Chat

Overview

XLA_MAPPING_SETS_F_PKG is the Forms PL/SQL wrapper package for the Subledger Accounting mapping set entity in Oracle E-Business Suite. It belongs to the XLA (Subledger Accounting) product family and exists to service the Oracle Forms user interface through which administrators define and maintain mapping sets. A mapping set associates a mapping set code and application accounting context with a view application, lookup type, chart of accounts, value set, and flexfield segment configuration, thereby controlling how Subledger Accounting derives and assigns account values during journal entry creation. The package header, generated from the XLAUTB utility, carries the source identifier xlathmps.pkh (version 120.22) and is owned by the APPS schema, making it callable through standard APPS synonyms.

Because it is a forms wrapper rather than a public programmatic API, its procedures encapsulate the row-level insert, lock, update, delete, and translation operations that the mapping sets form requires, and it is classified in the ETRM repository as OTHER rather than as an open interface or a full public API. The package does not implement business validation or account derivation logic itself; that responsibility resides in the underlying XLA mapping engine and the base tables the wrapper manipulates.

Key Procedures and Functions

  • INSERT_ROW — Creates a new mapping set row. It accepts the mapping set code, application accounting context, view application, lookup type, accounting chart of accounts, value set, flexfield assign mode, flexfield segment code, enabled flag, flex value set, name, description, and the standard WHO audit columns. The row identifier is returned to the calling form through an IN OUT NOCOPY parameter.
  • LOCK_ROW — Obtains a pessimistic lock on an existing mapping set identified by its primary key columns so that the form can safely display and modify the record without concurrent update conflicts.
  • UPDATE_ROW — Persists changes made to an existing mapping set, applying the same descriptive and configuration attributes passed at insert time and refreshing the audit columns.
  • DELETE_ROW — Removes a mapping set record from the underlying tables, subject to referential integrity enforced by the database.
  • ADD_LANGUAGE — Inserts a new translated row into the translation table for a language that does not yet have a mapping set description.
  • TRANSLATE_ROW — Updates the translated name and description for an existing language row, supporting the multilingual maintenance of mapping set definitions.

Tables Accessed

  • XLA_MAPPING_SETS_B — The base table holding the language-independent mapping set definition. INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW operate against this table.
  • XLA_MAPPING_SETS_TL — The translation table storing language-specific names and descriptions. ADD_LANGUAGE and TRANSLATE_ROW write to and update this table as part of the translated entity pattern.
  • FND_LANGUAGES — The Oracle Application Object Library languages table, consulted to validate and resolve installed languages during translation maintenance.

All three objects are referenced through APPS synonyms, so the package executes with the privileges of the APPS schema. The ETRM metadata records no other packages referencing XLA_MAPPING_SETS_F_PKG, confirming its role as a leaf-level UI support package.

Usage Notes

In both 12.1.1 and 12.2.2, this package is invoked almost exclusively by the Subledger Accounting mapping sets form. It is not intended as a supported integration point, and Oracle does not publish it as a public API. Custom code should not call these procedures directly; instead, external integrations should use the documented Subledger Accounting setup migration tools or the appropriate XLA public APIs. Because the wrapper performs no significant validation, direct invocation bypasses form-level checks and risks introducing inconsistent mapping set definitions. The insert and lock operations follow the standard Oracle Forms row-handling pattern, with the form supplying the ROWID and audit context. Organizations performing upgrades or cloning should be aware that the package was generated automatically and its version header reflects a 2005 source baseline, though the package remains present and functional across the 12.1.1 and 12.2.2 releases. Any modification to mapping sets through the form should be followed by the standard Subledger Accounting setup validation and, where applicable, the concurrent program that regenerates accounting method definitions.