Search Results populate_je_ap

Overview

ZX_JE_EXTRACT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite release 12.1.1 and 12.2.2. It is an internal extract utility within the E-Business Tax (EBTax / ZX) module, whose central responsibility is the population of tax-related journal entry extraction data used to reconcile and report tax amounts recorded against transactions in Receivables, Payables, and the General Ledger. The package works in conjunction with the main tax extract infrastructure, ZX_EXTRACT_PKG, and shares its global variable record type, ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE, as the common input carrier for runtime context. The declared AUTHID CURRENT_USER attribute indicates the package executes with the privileges of the invoking user rather than the definer, consistent with its role as a called extract routine driven by a parent extract process rather than a user-facing API. Its declared header identifier (zxriextrajeppvts.pls) and revision history place it in the R12 EBTax extract family, where journal-entry-oriented tax data is assembled for downstream reporting and reconciliation. The package is classified as OTHER in the ETRM model and is referenced by one other package.

Key Procedures and Functions

The package exposes three documented procedures, each following the same calling convention and differing only in the sub-ledger or ledger source from which tax journal entry data is gathered.

• POPULATE_JE_AR — Populates journal entry extract data for tax lines originating from Oracle Receivables transactions. It accepts the global variables record as input context and drives population for the AR side of the extract.
• POPULATE_JE_AP — Populates journal entry extract data for tax lines originating from Oracle Payables invoices. As with the AR variant, runtime context is supplied through the global variables record.
• POPULATE_JE_GL — Populates journal entry extract data for tax lines at the General Ledger level, drawing on GL journal lines. This is the procedure identified by the search term "populate_je_gl"; it consumes the same global variables record and completes the GL leg of the extract set.

Each procedure carries a single documented parameter, P_TRL_GLOBAL_VARIABLES_REC, an IN parameter of type ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE. No additional parameters, return values, or overloads are documented.

Tables Accessed

The package reads and writes a defined set of APPS synonyms. Party and transaction sources include RA_CUSTOMER_TRX_ALL and AP_INVOICES_ALL, which anchor the AR and AP extract procedures, and GL_JE_LINES for the GL leg. Tax engine data is drawn from ZX_LINES together with the reporting configuration tables ZX_REPORTING_CODES_B, ZX_REPORTING_CODES_TL, ZX_REPORTING_TYPES_B, and ZX_REPORT_CODES_ASSOC. Extract output is held in the staging tables ZX_REP_TRX_DETAIL_T, ZX_REP_TRX_JX_EXT_T, and its sequence ZX_REP_TRX_JX_EXT_T_S. Supporting lookups include FINANCIALS_SYSTEM_PARAMS_ALL for system parameters and HR_LOCATIONS_ALL for location context. PLITBLM is a PL/SQL internal table used as a transient structure during processing.

Usage Notes

ZX_JE_EXTRACT_PKG is not a public API and is not intended for direct invocation from forms or custom code. It is called internally by the EBTax extract framework, most likely by the parent extract package that supplies the initialized ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE record. In practice it is driven during tax extract processing, including concurrent program runs that stage tax reporting detail for subsequent reporting and reconciliation. Because it is AUTHID CURRENT_USER and operates on staging tables, any custom usage should be limited to environments that already replicate the parent extract context, and it should never be invoked outside that orchestration.