Results for “insert_data_mrc_gt”
10 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:
- File and logging utilities: INITIALIZE_FILE, CLOSE_FILE, READ_LINE, WRITE_MESSAGE, and GET_LOG manage flat-file input/output and capture processing messages for later retrieval.
- Parsing helpers: GET_NEXT_ELEMENT_IN_ROW and RETRIEVE_ANOTHER_SEGMENT tokenize delimited input records into individual attributes.
- Key management: SURROGATE_KEY and CHECK_SURROGATE_KEY generate and validate surrogate keys; BREAK_USER_KEY_INTO_SEGMENTS and GET_USER_KEY_ID decompose and resolve user-defined key strings against the ETRM key model.
- Data marshalling: PUT_DATA_IN_PARTY_REC populates the party record structure, while INSERT_DATA_TRX_HEADERS_GT, INSERT_DATA_TRX_LINES_GT, INSERT_DATA_MRC_GT, INSERT_ROW_TRANSACTION_REC, and INSERT_TRANSACTION_REC stage transactional data into the ETRM global temporary tables.
- Tax and distribution staging: INSERT_IMPORT_SUM_TAX_LINES_GT, INSERT_TRX_TAX_LINK_GT, and INSERT_REVERSE_TRX_LINES_GT insert summarized tax lines, tax link records, and reversing line entries into their respective GT tables.
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.
-
PACKAGE: APPS.ZX_TEST_API 12.2.2
-
PACKAGE: APPS.ZX_TEST_API 12.1.1