Search Results sync_tax_registrations

Overview

ZX_TCM_PTP_PKG is an Oracle E-Business Tax (EBTax) internal PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. Its name encodes its function: Tax Configuration Manager (TCM) Party Tax Profile (PTP). The package provides the resolution and synchronization logic by which E-Business Tax identifies the correct Party Tax Profile record for a given transaction context, and by which changes to legal entity tax registrations are propagated across the tax configuration.

The user search term "NTTP company" relates to the concept of a Non-Tax-Treatment-Party or non-registered company scenario, where a party does not carry a full tax profile. This package is directly implicated in such scenarios, because its GET_PTP and GET_TAX_SUBSCRIBER procedures determine whether a valid Party Tax Profile exists for a party at a given legal entity and inventory location, and return a null profile identifier when registration data is absent.

Key Procedures and Functions

• GET_PTP — Returns the Party Tax Profile identifier for a supplied party, party type, legal entity, and inventory location, with a return status indicating success or failure.
• GET_PTP_HQ — Retrieves the Party Tax Profile of the Headquarters Establishment associated with a given Legal Entity. The package header documents the assumption that any Legal Entity has exactly one HQ Establishment.
• GET_TAX_SUBSCRIBER — Resolves the tax subscriber Party Tax Profile for a legal entity and operating unit combination.
• GET_LOCATION_ID — Derives the location identifier associated with an operating unit.
• CHECK_TAX_REGISTRATIONS — Validates the tax registrations belonging to a legal entity registration identifier.
• SYNC_TAX_REGISTRATIONS — Synchronizes registration data when a legal entity registration is replaced, taking the old and new registration identifiers, the old end date, and the new registration number.
• GET_PARTY_TAX_PROF_INFO — Overloaded procedure returning party tax profile information either by party tax profile identifier or by party identifier and party type code, writing results into a PL/SQL table indexed by a binary integer.

Tables Accessed

The package reads and writes core E-Business Tax and Oracle Legal Entity configuration tables through APPS synonyms. XLE_ENTITY_PROFILES supplies legal entity identity; ZX_PARTY_TAX_PROFILE is the primary profile repository read and updated; ZX_REGISTRATIONS and ZX_REGISTRATIONS_S hold tax registration and registration number data; XLE_ETB_PROFILES supports establishment-level configuration; HR_ALL_ORGANIZATION_UNITS resolves the operating unit and organization hierarchy; and FND_LOG_MESSAGES records debug and error logging. DBMS_UTILITY and PLITBLM are used for PL/SQL table manipulation.

Usage Notes

ZX_TCM_PTP_PKG is not a public API. It is invoked internally by the E-Business Tax engine during tax determination, by the Legal Entity configuration and registration flows when registrations are created, ended, or renumbered, and by concurrent programs that rebuild or validate tax configuration data. Because thirteen other packages reference it, modifications carry a wide blast radius. Custom code should avoid direct calls and instead use the supported E-Business Tax public APIs; diagnostic queries against the referenced tables, however, are useful when investigating party tax profile resolution failures in non-registered company scenarios on both 12.1.1 and 12.2.2.