Search Results is_ccid_valid

Overview

ZX_TRD_SERVICES_PUB_PKG (Trade Services Public Package) is the public API wrapper within the Oracle E-Business Suite E-Business Tax (EBTax) module that exposes core tax determination and tax recovery services to external callers. In Oracle EBS 12.1.1 and 12.2.2, this package body (ZX_TRD_SERVICES_PUB_PKG) serves as the programmatic entry point for calculating, validating, and reversing tax on transactions processed through Trade Management, Order Management, Receivables, and Payables flows. It is classified as an "OTHER" API, meaning it is not a formally frozen public interface but is nonetheless widely consumed by internal EBS modules and custom extensions.

The package encapsulates the tax engine's runtime logic for jurisdiction resolution, tax line generation, recoverability determination, and distribution accounting. The header references version 120.172.12020000.5, indicating iteration through the 12.2 release train, with behavior largely consistent with the 12.1.1 codebase. Notably, the user search term "is_ccid_valid" relates to this package's accounting flexibility validation, which occurs through the CCID-retrieval routines and their underlying use of GL_CODE_COMBINATIONS.

Key Procedures and Functions

The package documents fourteen callable procedures and functions:

• DETERMINE_RECOVERY — Evaluates whether tax amounts on a transaction are recoverable based on the applicable recovery rate and tax regime configuration.
• OVERRIDE_RECOVERY — Allows a caller to supersede the system-determined recovery outcome with a manually specified recovery value.
• REVERSE_TAX_DIST — Reverses previously generated tax distributions, typically during credit memo or adjustment processing.
• VALIDATE_DOCUMENT_FOR_TAX — Confirms a transaction document is eligible for tax calculation before processing proceeds.
• REVERSE_DISTRIBUTIONS — Reverses accounting distributions associated with tax lines for correction workflows.
• UPDATE_EXCHANGE_RATE — Refreshes the exchange rate applied to tax amounts when currency conversion changes.
• GET_CCID — Retrieves the Code Combination ID (CCID) for a given accounting string, validating it against GL_CODE_COMBINATIONS via the accounting flexfield (the "is_ccid_valid" search concept).
• GET_OUTPUT_TAX_CCID — Returns the CCID designated for output tax accounting entries.
• GET_RECOVERABLE_CCID — Returns the CCID associated with recoverable tax portions.
• ROUND_AMT_TO_MAU — Rounds a monetary amount to the Minimum Accounting Unit of the functional currency.
• GET_TAX_HOLD_RLS_VAL_FRM_CODE — Maps a release code to its corresponding tax hold release value.
• GET_PROD_TOTAL_TAX_AMT — Aggregates the total tax amount for a product line across jurisdictions.
• IS_RECOVERABILITY_AFFECTED — Determines whether a configuration or transaction change impacts recoverability status.
• UPDATE_POSTING_FLAG — Sets or clears the posting indicator on tax records following processing.

Tables Accessed

The package reads and writes against several EBS tax and accounting tables through APPS synonyms. ZX_LINES and ZX_REC_NREC_DIST hold tax line and recoverable/non-recoverable distribution records. AR_LOCATION_ACCOUNTS_ALL and RA_CUSTOMER_TRX_LINES_ALL supply Receivables transaction and location accounting context. GL_CODE_COMBINATIONS is queried by the CCID-retrieval routines to validate account combinations. FND_CURRENCIES provides currency metadata for exchange-rate and rounding logic. HZ_GEOGRAPHIES and HZ_GEOGRAPHY_TYPES_B support jurisdiction and geography resolution. ZX_ACCOUNTS, ZX_ITM_DISTRIBUTIONS_GT, ZX_DETAIL_TAX_LINES_GT, ZX_DET_FACTOR_TEMPL_B, ZX_DET_FACTOR_TEMPL_DTL, ZX_EVNT_CLS_MAPPINGS, and ZX_JURISDICTIONS_B provide tax setup, event-class mapping, and jurisdiction reference data.

Usage Notes

ZX_TRD_SERVICES_PUB_PKG is invoked primarily by other EBS tax and trade packages — it is referenced by eleven dependent packages — and indirectly from Order Management, Receivables, and Payables transaction flows. It is not exposed through a standard concurrent program or form directly; instead, callers reach it through public tax APIs such as ZX_API_PUB. Custom code calling these routines must be aware that the package is classified as OTHER and may change between patch levels. The presence of dummy constants and NOCOPY OUT parameters reflects defensive coding for high-volume tax processing where performance and buffer reuse matter.