Search Results load_header_data_adj




Overview
Explore in AI Chat

Overview

ARP_XLA_EXTRACT_MAIN_PKG is a core subledger accounting package in the APPS schema that drives the extraction of Oracle Receivables transactions and distributions into the Subledger Accounting (SLA / XLA) data model under Oracle E-Business Suite 12.1.1 and 12.2.2. Its central role is to move accounting-relevant Receivables data — receivables adjustments, cash receipts and cash basis distributions, receivables transaction distributions, and misc cash distributions — into the XLA extraction tables so that the Create Accounting process can subsequently generate and post journal entries to the General Ledger. The package also controls the locking of documents during extraction, participates in the pre-accounting and post-accounting phases, and handles posting control state transitions. As an ETRM-documented object with status VALID, it is classified as API classification OTHER, indicating it is an internal engine package rather than a public, supported extension API. It registers a workflow event reference (WF_EVENT_T) and is tightly coupled to the Receivables accounting hook XLA_AR_ACCT_HOOKS_PKG, which references it as part of the SLA extract pipeline.

Key Procedures and Functions

The documented interface exposes twenty-seven procedures and functions organized around the extraction and accounting lifecycle:

  • EXTRACT — the primary driver that reads eligible Receivables documents and populates the XLA extraction structures.
  • PREACCOUNTING and POSTACCOUNTING — bracket the accounting generation phase, preparing source data and performing follow-up actions respectively.
  • POSTPROCESSING — completes cleanup and status updates after accounting.
  • LOCK_DOCUMENTS_FOR_XLA and LOCKING_STATUS — control and report the locking of documents to prevent concurrent modification during extraction.
  • EXTRACT_STATUS, POSTING_CTL_STATUS, and FLAG_THE_POSTING_ID — report and manage extraction and posting control state.
  • ED_UNED_TRX — handles the executed / unexecuted (accounted vs. unaccounted) distinction for transactions.
  • THE_SEGMENT_VALUE — resolves accounting segment values used during extraction.
  • LOAD_HEADER_DATA_* and LOAD_LINE_DATA_* — load header and line extraction data for each document type: CTLGD, ADJ (adjustments), CRH (cash receipts history), TH (transactions), plus LOAD_LINE_DATA_CRH_MF for miscellaneous cash receipts. These routines map source document attributes into the staging/interface structures consumed by downstream accounting.

Tables Accessed

The package reads and writes a broad set of Receivables base tables and staging objects through APPS synonyms, including AR_ADJUSTMENTS_ALL, AR_CASH_BASIS_DISTS_ALL, AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, AR_DISTRIBUTIONS_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, AR_PAYMENT_SCHEDULES_ALL, AR_RECEIVABLES_TRX_ALL, and AR_RECEIVABLE_APPLICATIONS. It also interacts with global temporary tables AR_CRH_GT, AR_CRH_APP_GT, and AR_LINE_APP_DETAIL_GT, the extract staging table AR_MFAR_EXTRACT_S, the posting control table AR_POSTING_CONTROL_S, and the WF_EVENT_T workflow event table. These objects supply the transactions, distributions, receipt history, and payment scheduling data required to build accounting entries.

Usage Notes

ARP_XLA_EXTRACT_MAIN_PKG is invoked internally by the Receivables SLA extract and accounting flow, including the Create Accounting concurrent program and the accounting hooks in XLA_AR_ACCT_HOOKS_PKG. It is referenced by the AR_DISTRIBUTIONS_L_V and AR_GL_SEGMENTS_REF_V views. Because it is an internal engine package (classification OTHER), it should not be called directly by custom code; use the supported Create Accounting concurrent programs and the XLA accounting APIs instead. In 12.2.x the package continues to serve the same extraction role within the unified SLA architecture.