Search Results get_pp_ar_clearing_ccid




Overview
Explore in AI Chat

Overview

The APPS.DPP_XLA_EVENT_PUB package is a public PL/SQL API within the Oracle E-Business Suite that supports the integration between Oracle Advanced Pricing accrual and claims processing and the Subledger Accounting (XLA) engine. It serves as an event publication and accounting generation utility, enabling the creation of accounting entries for supplier and customer rebate, accrual, and claim transactions originating in the pricing and trade management modules. In the context of Oracle EBS 12.1.1 and 12.2.2, this package bridges transactional data captured in tables such as DPP_TRANSACTION_HEADERS_ALL and OZF_CLAIMS_ALL with the accounting event model managed by XLA, populating the DPP_XLA_HEADERS, DPP_XLA_LINES, and DPP_XLA_EVENT_MAP structures. The object is classified as a PUBLIC API (PUB), indicating it is intended for supported invocation by external programs and extensions. Its status is VALID, and it resides in the APPS schema. The package is referenced by four views — DPP_XLA_CLAIM_HEADERS_V, DPP_XLA_CLAIM_LINES_V, DPP_XLA_INV_HEADERS_V, and DPP_XLA_INV_LINES_V — and by four additional packages, underscoring its central role in the pricing subledger accounting flow.

Key Procedures and Functions

The documented interface exposes six procedures and functions, each oriented toward generating accounting distributions for pricing-related transactions:

  • CREATEACCOUNTING — The primary driver that constructs and publishes accounting events and lines for pricing accrual and claim transactions, orchestrating the creation of header and line records within the DPP XLA tables.
  • GET_PP_ACCRUAL_CCID — Retrieves the accounting flexfield (CCID) associated with the accrual liability or expense account for a given pricing transaction.
  • GET_PP_COST_ADJUSTMENT_CCID — Obtains the CCID used to record cost adjustment entries arising from pricing accrual activity.
  • GET_PP_AP_CLEARING_CCID — Returns the CCID for the Accounts Payable clearing account applied when settling supplier-related pricing accruals.
  • GET_PP_AR_CLEARING_CCID — Provides the CCID for the Accounts Receivable clearing account used in customer-facing rebate or claim settlements.
  • GET_PP_CONTRA_LIAB_CCID — Supplies the CCID for the contra liability account that offsets accrual balances during recognition and settlement.

These helper functions centralize account derivation logic, ensuring consistent use of the mapping rules defined for pricing accruals across the accounting generation routines.

Tables Accessed

The package operates across several transactional and setup tables, referenced in the APPS schema through synonyms. Transactional sources include DPP_TRANSACTION_HEADERS_ALL, which holds the pricing transaction headers, and MTL_TRANSACTION_ACCOUNTS, which supplies inventory-related accounting information. Claim and accrual data are read from OZF_CLAIMS_ALL, OZF_CLAIM_TYPES_ALL_B, OZF_SUPP_TRD_PRFLS_ALL, and OZF_SYS_PARAMETERS_ALL, providing claim definitions and system parameters governing accrual behavior. The package writes to and reads from the accounting staging tables DPP_XLA_HEADERS, DPP_XLA_LINES, and DPP_XLA_EVENT_MAP, which store the generated XLA-compatible event headers, distribution lines, and event-to-transaction mappings that are subsequently transferred to the Subledger Accounting engine.

Usage Notes

DPP_XLA_EVENT_PUB is typically invoked during accounting generation for pricing accruals and claims, often in the context of subledger accounting programs and the Create Accounting process. It is called by the dependent DPP views and by other pricing accounting packages when building event data for transfer to XLA. Custom code and extensions should call CREATEACCOUNTING only after the requisite transaction and claim records are populated, and should use the GET_*_CCID functions to retrieve account identifiers rather than hard-coding account logic. Because the package is a public API, direct modification is not supported; all interactions should respect the documented interfaces and the standard XLA event lifecycle to maintain integrity between the pricing module and Subledger Accounting.