Search Results dpp_sla_claim_extract_pub




Overview
Explore in AI Chat

Overview

The APPS.DPP_SLA_CLAIM_EXTRACT_PUB package is a public PL/SQL API within the Oracle E-Business Suite applications schema, classified as a PUB (public) interface. It belongs to the Oracle E-Business Suite Trade Management / Channel Revenue Management family of components, as evidenced by the DPP prefix (Channel Revenue Management and Trade Management schema) and the OZF (Oracle Order Management / Trade Management) table references drawn into its dependency chain. Its core business function is to construct and persist Subledger Accounting (SLA) extraction data for supplier and customer claim transactions, reconciling the operational claim records held in the Trade Management claim tables with the accounting event model maintained by the SLA and XLA (eXtended Ledger Accounting) infrastructure. In practical terms, the package acts as the bridge between claims business objects and the accounting engine, generating the extract structures that the Subledger Accounting program later consumes when creating journal entries. The package is documented as VALID in both 12.1.1 and 12.2.2 environments, and its API classification confirms it is intended for invocation from other application modules rather than being an internal helper.

Key Procedures and Functions

  • CREATE_SLA_EXTRACT — The single documented public program unit. It is responsible for building the SLA extract payload for claim-based transactions. Based on its name and the dependent tables, it reads claim and transaction data, assembles the accounting-relevant attributes, and writes the resulting extract rows that downstream SLA processing uses to generate and post accounting entries. It follows the standard EBS API conventions exposed through FND_API, which appears in its dependency list, indicating use of the standard API error-handling and message framework (FND_API.G_RET_STS_SUCCESS style return conventions). No parameter list is reproduced here, as the documented metadata does not expose the formal signature.

Tables Accessed

The package operates against a defined set of operational and accounting staging tables, all reached through APPS synonyms:

  • OZF_CLAIMS — The base Trade Management claims table, providing the source claim records eligible for accounting extraction.
  • DPP_CUSTOMER_CLAIMS_ALL — Customer claim details in the Channel Revenue Management model.
  • DPP_TRANSACTION_CLAIMS_ALL — Links claim data to the underlying transaction that generated the claim.
  • DPP_TRANSACTION_HEADERS_ALL and DPP_TRANSACTION_LINES_ALL — The transaction header and line records that supply amounts, quantities, and reference context needed for accounting.
  • DPP_XLA_HEADERS and DPP_XLA_LINES — The XLA (Subledger Accounting) header and line tables into which extract information is inserted or matched, forming the interface to the accounting engine.
  • PLITBLM — A standard EBS PL/SQL index-by table type used for passing collections of identifiers and values into the extract routines.

Usage Notes

DPP_SLA_CLAIM_EXTRACT_PUB is a public API referenced by OZF_SETTLEMENT_DOC_PVT, indicating that settlement document processing invokes it to prepare accounting extracts when claims are settled. It also carries a self-referential entry in the dependency report, consistent with the package body calling its own specification. Typical invocation paths include the Channel Revenue Management accounting concurrent programs and settlement workflows that drive claim-to-accounting transfer, as well as custom extensions that call the public API directly to generate SLA extracts programmatically. Because it depends on FND_API, callers should expect standard EBS API status and message output handling. In 12.2.2, Subledger Accounting is the mandatory accounting method, so this package's role in populating XLA staging tables is central to producing subledger journal entries for claims. Administrators troubleshooting missing claim accounting should confirm that the extract was generated successfully before investigating SLA program execution.