Search Results xla_third_party_merge




Overview
Explore in AI Chat

Overview

XLA_THIRD_PARTY_MERGE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the Subledger Accounting (XLA) module. Its purpose is to consolidate accounting entries originating from third-party or external source systems into the Oracle Subledger Accounting model, so that transactions captured outside the standard EBS subledgers can participate in the same accounting, posting, and reporting infrastructure as native EBS entries. This capability is significant because Subledger Accounting is the central engine that creates accounting representations for transactions from Payables, Receivables, Assets, and other sources; a merge utility of this type allows externally generated data to be merged into that model without duplicating the entire create-accounting pipeline.

The package is documented as VALID in both 12.1.1 and 12.2.2, and the ETRM metadata classifies it as a package (not a public API), with its public counterpart exposed through XLA_THIRD_PARTY_MERGE_PUB. The package references the STANDARD PL/SQL package and is both referenced by and dependent on its public wrapper, confirming a private-implementation / public-interface design pattern.

Key Procedures and Functions

Two documented procedures are exposed in the ETRM metadata:

  • THIRD_PARTY_MERGE — The primary driver procedure of the package. It performs the merge operation that takes third-party accounting data and integrates it into the Subledger Accounting tables. Conceptually it orchestrates the population and reconciliation of accounting event headers, lines, and details for externally sourced transactions.
  • CREATE_ACCOUNTING — Performs the accounting creation step, generating the accounting entries (headers and lines) that correspond to the merged third-party data. This procedure is responsible for transforming the merged source data into the XLA_AE_HEADERS and XLA_AE_LINES records required for posting.

The documentation does not expose parameter lists, so no signatures are asserted here; callers should inspect the package specification directly.

Tables Accessed

The package reads and writes a focused set of Subledger Accounting and General Ledger tables:

Usage Notes

Because the package is classified as OTHER rather than a supported public API, it is intended for internal invocation by Subledger Accounting processes and their public wrappers rather than direct customer calls. The presence of FND_CONCURRENT_REQUESTS in its reference list strongly suggests it is executed from a concurrent program, and the XLA_*_GT staging tables indicate a bulk, set-based merge design typical of concurrent batch jobs.

Custom code should not call XLA_THIRD_PARTY_MERGE directly; instead, use the documented public interface XLA_THIRD_PARTY_MERGE_PUB. Any customization that depends on this private package risks breakage across patches and upgrades, since only the public wrapper is contractually stable.