Search Results xla_gl_sl_link_id_s




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.CST_UPD_GIR_MTA_WTA is a PL/SQL package body in the Oracle E-Business Suite Cost Management (CST) module. Its name reflects its purpose: updating Goods Issued/Received (GIR) data across Material Transaction Accounts (MTA) and Work in Process Transaction Accounts (WTA). The package reconciles cost accounting records against the subledger accounting (XLA) and general ledger (GL) tables, ensuring that the linkage between transactional accounting entries and their corresponding GL journal lines is correctly populated.

This package is most closely associated with the migration and upgrade of the XLA_GL_SL_LINK_ID_S column — the sequence-generated link identifier that ties XLA distribution lines to their GL subledger references. This is consistent with the user's search for "xla_gl_sl_link_id_s," which is both a referenced table and the central theme of the package's logic. In EBS 12.1.1 and 12.2.2, this package supports the upgrade of historical transactions so that prior accounting entries conform to the current Subledger Accounting model.

Key Procedures and Functions

  • CST_SL_LINK_UPG_MTA — Handles the upgrade of the subledger link identifier for Material Transaction Accounts records. It identifies MTA rows that require a link ID and updates them against GL and XLA reference data.
  • CST_SL_LINK_UPG_WTA — Performs the equivalent upgrade for WIP Transaction Accounts records, applying the same reconciliation logic to work-in-process accounting entries.
  • UPDATE_MTA_WTA — The driving orchestration procedure that coordinates the updates across both MTA and WTA populations, likely invoking the two specialized routines above and managing batch processing.

The ETRM documentation does not enumerate parameter lists for these procedures; only their names and functional purpose are documented.

Tables Accessed

The package reads and writes a defined set of cost, subledger, and GL tables:

Usage Notes

CST_UPD_GIR_MTA_WTA is an internal, upgrade-oriented utility rather than a user-facing API. It is not referenced by any other database object, confirming that it is invoked directly — typically by a concurrent program, patch script, or one-time upgrade driver during the 12.1.1 to 12.2.2 transition. It is not intended for routine transaction processing and should not be called from custom code under normal operating conditions. The package relies on profile options and FND logging, so administrators should ensure logging is configured when diagnosing its execution. Because it modifies GL-linkage data, it should be run only within a controlled upgrade or data-fix context with a validated backup.