Results for “get_log”

32 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ZX_TEST_API is a public PL/SQL package owned by the APPS schema within the Oracle E-Business Suite. It belongs to the ETRM (E-Business Tax / Tax Reporting and Management) product family, as indicated by the ZX prefix and the associated ZX_ interface tables. The package serves as a testing and validation harness for the tax engine's external data import mechanism. Its principal business function is to simulate the ingestion of transaction, tax line, and distribution data through the ETRM interface layer, thereby allowing implementations to verify that the tax determination, surrogate key generation, and multi-organization (MRC) handling logic behave as expected before live data is loaded.

The package header defines an extensive library of PL/SQL collection and record types. Scalar table types include NUMBER, DATE, and VARCHAR2 collections sized from 1, 2, 15, 30, 40, 50, 80, 150, 240, 250, and 2000 characters. Specialized associative arrays keyed by VARCHAR2(1000) support surrogate transaction IDs, surrogate transaction line IDs, and surrogate transaction distribution IDs. Record types such as party_rec_type model ship-to and ship-from party classifications together with POA and POO party types. These type definitions constitute the package's data contract and are exposed to any custom program that calls the API.

Key Procedures and Functions

The ETRM metadata documents 46 callable units. Grouped by purpose, the principal entries are:

No parameter lists are asserted here beyond what the documented metadata exposes; callers should consult the package specification directly for exact signatures.

Tables Accessed

The package references its tables through APPS synonyms. Direct file operations are performed with UTL_FILE. Reference lookups draw on AP_SUPPLIERS, FND_APPLICATION, FND_DOCUMENT_SEQUENCES, HR_ALL_ORGANIZATION_UNITS, HZ_LOCATIONS, HZ_PARTIES, HZ_PARTY_SITES, RA_BATCH_SOURCES_ALL, and XLE_ENTITY_PROFILES — primarily to resolve legal entities, party and location identifiers, batch sources, and application context. Tax configuration is read from ZX_EVNT_CLS_MAPPINGS and ZX_EVNT_TYP_MAPPINGS. Transactional staging targets the global temporary tables ZX_ERRORS_GT, ZX_IMPORT_TAX_LINES_GT, and ZX_ITM_DISTRIBUTIONS_GT, which hold errors, imported tax lines, and item distributions respectively during a processing run.

Usage Notes

ZX_TEST_API is typically invoked from concurrent programs or custom PL/SQL test drivers rather than from standard EBS forms. A common invocation sequence is INITIALIZE_FILE, repeated READ_LINE and parsing calls, PUT_DATA_IN_PARTY_REC, surrogate key derivation, INSERT_TRANSACTION_REC, and finally CLOSE_FILE and GET_LOG to report results. The metadata records zero dependent packages, confirming that ZX_TEST_API is a leaf consumer — it calls into the ETRM interface tables and reference data but is not referenced by other shipped packages. Because it is classified as an API and is a test utility, it should be used only in controlled test or validation environments; production tax loading should rely on the supported ETRM import programs. The origin header dates the specification to 2006, and the package remains available in both 12.1.1 and 12.2.2 releases.