Search Results zx_extract_pkg




Overview
Explore in AI Chat

Overview

ZX_CORE_REP_EXTRACT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle E-Business Tax (EBTax) reporting and extract infrastructure. Its name combines the EBTax "ZX" product prefix with "CORE_REP_EXTRACT," indicating that it serves as a core reporting extract utility for tax-related transaction data. The package is classified in the ETRM repository as an OTHER API, reflecting that it is an internal, non-public interface rather than a formally published integration API.

In Oracle EBS 12.1.1 and 12.2.2, the tax reporting extract framework gathers taxable transaction detail from Payables and Receivables so that it can be staged, archived, or consumed by downstream tax reporting, reconciliation, and audit processes. ZX_CORE_REP_EXTRACT_PKG operates within this framework, orchestrating the population of core extract structures from the primary subledger accounting sources. It depends on and is referenced by ZX_EXTRACT_PKG, which is the broader EBTax extract driver package, and is referenced by one additional package in the APPS schema.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package:

  • POPULATE_CORE_AP — Populates the core extract data associated with Oracle Payables tax transactions. It is the Payables-side entry point invoked during a tax reporting extract run.
  • POPULATE_CORE_AR — Populates the core extract data associated with Oracle Receivables tax transactions. It is the Receivables-side entry point, mirroring the structure and purpose of POPULATE_CORE_AP for the receivables subledger.

No parameter lists are documented in the ETRM repository; the procedures should be treated as internal entry points. Callers are expected to supply the run context already established by the invoking extract process rather than passing independent business arguments.

Tables Accessed

The package reads from a broad set of Payables, Receivables, Purchasing, Subledger Accounting, and general ledger tables via APPS synonyms, including:

These tables supply the transactional, accounting, and period context required to build a complete, reconcilable tax extract for reporting.

Usage Notes

This package is an internal EBTax component and is not intended for direct invocation by customers. In typical EBS 12.1.1 and 12.2.2 environments, it is invoked indirectly through the EBTax reporting extract concurrent programs, which call ZX_EXTRACT_PKG, which in turn references ZX_CORE_REP_EXTRACT_PKG. Because it is an OTHER-classified API, its signature and behavior are not covered by Oracle's public API compatibility guarantee and may change between releases or patches. When troubleshooting missing tax extract data, review ZX_EXTRACT_PKG and the extract concurrent program log rather than calling this package directly.