Results for “delete_tax_dists”

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

Overview

ZX_NEW_SERVICES_PKG is a PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite ETRM (E-Business Tax) module. It provides a set of utility services that support lifecycle operations on tax distributions generated by the tax engine. In the context of Oracle EBS 12.1.1 and 12.2.2, this package operates as an internal services layer for tax lines and tax distribution records associated with transactions in Receivables, Payables, and related subledgers. Its responsibilities center on freezing, cancelling, deleting, and synchronizing tax distribution data, as well as managing descriptive flexfield data attached to those distributions. The package is classified as "OTHER" in ETRM's API taxonomy, indicating it is not a public, external-facing API but rather an internal service invoked by E-Business Tax processing flows, concurrent programs, or dependent packages.

Key Procedures and Functions

• FREEZE_TAX_DISTS_FOR_ITEMS — Freezes tax distributions associated with specified transaction items so their amounts and detail factors are locked from further recalculation. This is typically used when a transaction must be finalized without additional tax recalculation, ensuring downstream accounting and reporting remain stable.
• CANCEL_TAX_LINES — Cancels tax lines previously created for a transaction. Cancellation is generally applied when a transaction is voided, reversed, or otherwise invalidated, and the associated tax lines should no longer participate in distribution or posting.
• DELETE_TAX_DISTS — Removes tax distribution records (including records in ZX_REC_NREC_DIST and possibly summary structures) so they can be regenerated or eliminated from the accounting stream. This supports cleanup of stale or invalid distributions prior to recalculation.
• SYNC_TAX_DIST_DFF — Synchronizes descriptive flexfield (DFF) values attached to tax distributions, ensuring that context-sensitive attributes are propagated consistently to the distribution records and downstream reports.

Tables Accessed

The package interacts with several ETRM tables via APPS synonyms. ZX_LINES, ZX_LINES_SUMMARY, and ZX_LINES_DET_FACTORS (and its sequence ZX_LINES_DET_FACTORS_S) hold tax line data and the detailed factors used to distribute tax amounts. ZX_REC_NREC_DIST stores recovered and non-recoverable distributions, which are directly modified by freezing, cancelling, and deletion operations. Event classification and event type mappings (ZX_EVNT_CLS_MAPPINGS, ZX_EVNT_TYP_MAPPINGS) are consulted to resolve tax event handling. Global temporary tables including ZX_ERRORS_GT, ZX_REVERSE_DIST_GT, ZX_TAX_DIST_ID_GT, ZX_TRANSACTION_LINES_GT, and ZX_TRX_HEADERS_GT support set-based processing and error capture. Standard Oracle components such as DUAL, PLITBLM, FND_API, FND_LOG, FND_MESSAGE, FND_MSG_PUB, and ZX_API_PUB provide API error handling, logging, and messaging services.

Usage Notes

ZX_NEW_SERVICES_PKG is not intended for direct customer invocation. It is invoked internally by E-Business Tax processing flows, concurrent programs, and dependent packages (notably ZX_API_PUB) during transaction tax calculation, adjustment, and reversal cycles. Because it manipulates distribution and factor records directly, it should be called only within the appropriate tax engine context, after event classification and line generation have occurred. Administrators performing diagnostics or troubleshooting tax distribution issues in 12.1.1/12.2.2 may observe its execution through standard EBS logging (FND_LOG) and message stack output (FND_MSG_PUB). Custom code should rely on documented public APIs rather than calling this internal package body directly, since its procedures are subject to change across patches and releases.