Search Results ont_sales_order




Overview
Explore in AI Chat

Overview

OE_BULK_TAX_UTIL is a private utility package owned by APPS within the Oracle Order Management (ONT) product family. Its documented display name is the Order Management Tax Utility API, and it is classified as a UTIL-type API under the business entity ONT_SALES_ORDER. The package provides the low-level tax calculation utilities used during sales order processing in Oracle E-Business Suite 12.1.1 and 12.2.2. It is not intended for direct invocation by external consumers; the @rep:scope private annotation confirms it is an internal helper whose behavior supports the higher-level tax determination and bulk tax processing logic executed when order lines are priced, repriced, or saved.

The package maintains package-level global variables such as G_CURRENCY_CODE, G_MINIMUM_ACCOUNTABLE_UNIT, and G_PRECISION that carry currency and rounding context across calls within a session. It also defines the TAX_NUMBER_TBL_TYPE collection and the Line_Adj_Rec_Type record type, which together with globals such as G_TAX_LINE_ID, G_TAX_LINE_VALUE, and G_LINE_ADJ_REC provide the in-memory structures used to stage tax line identifiers, tax values, and line-level price adjustment information prior to persistence.

Key Procedures and Functions

  • GET_DEFAULT_TAX_CODE — Populates a default tax code on order lines when no tax code has been specified, ensuring downstream tax calculation has a valid starting value.
  • CALCULATE_TAX — Performs the core tax computation for order lines and adjustments, applying currency precision and minimum accountable unit rules.
  • EXTEND_ADJ_REC — Expands or extends the line adjustment record structure, supporting the mapping of tax results onto price adjustment data.
  • INSERT_TAX_RECORDS — Writes the resulting tax lines and adjustment records into the appropriate Order Management tax tables.
  • HANDLE_ERROR — Provides standardized error handling for failures raised during tax processing.
  • HANDLE_TAX_CODE_ERROR — Provides targeted error handling specific to tax code retrieval and validation failures.

Tables Accessed

The package reads and writes across Order Management, Receivables, and Trading Community reference data. Core transactional tables include OE_ORDER_HEADERS_ALL, OE_ORDER_LINES, OE_PRICE_ADJUSTMENTS, and OE_PRICE_ADJUSTMENTS_S, which hold the order context and the price adjustment lines that receive tax results. AR_SYSTEM_PARAMETERS_ALL and RA_BATCH_SOURCES supply Receivables tax and batch configuration. Currency and rounding behavior relies on FND_CURRENCIES. Customer and location data is resolved from HZ_CUST_ACCOUNTS_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTIES, and HZ_PARTY_SITES, while HR_ALL_ORGANIZATION_UNITS supplies operating unit context. These reads establish the tax applicability and rates used during calculation.

Usage Notes

OE_BULK_TAX_UTIL is referenced by two other packages and is invoked indirectly rather than through forms, concurrent programs, or standard public APIs. It executes as part of the Order Management order-entry and pricing flow, typically when a sales order line requires tax determination or when bulk tax recalculation is triggered during order save and repricing. The ONT_SALES_ORDER categorization confirms its role in the sales order business entity, so custom code extending order tax behavior should generally call the supported public Order Management tax APIs rather than this private utility. Modification of this package is not supported and any direct dependency should be treated as a customization risk during upgrades between 12.1.1 and 12.2.2.