Search Results om_tax_out_tab_type




Overview
Explore in AI Chat

Overview

APPS.OM_TAX_UTIL is a utility package within the Oracle E-Business Suite Order Management module that supports tax calculation and charge-related processing for order lines. The package is classified as a UTIL API in ETRM and is owned by the APPS schema. Its primary responsibility is to assemble the tax-relevant data structures required by the E-Business Tax engine when calculating taxes on order transactions, and to expose helper functions that retrieve charge details and content ownership information for a given order header or line. The package is most commonly associated with the Taxer flow in Order Management, which determines tax lines for ordered items based on pricing adjustments, customer information, and transaction attributes.

Key Procedures and Functions

The package exposes four documented program units, each serving a distinct purpose within the tax determination flow.

  • TAX_LINE — invoked with a table of entity identifiers and returns a tax output table along with a return status. It is the principal entry point for computing tax lines at the order line level, populating the OM_TAX_UTIL.OM_TAX_OUT_TAB_TYPE structure with tax amount, taxable amount, tax rate, and related attributes.
  • CALCULATE_TAX — accepts an order header identifier and returns a status. It orchestrates the tax calculation for all applicable lines under the specified header, typically invoking the underlying tax engine after collecting charges and other required inputs.
  • GET_CHARGE_DETAILS — a function that returns a table of the charge_rec record type for a given header and line. Each charge_rec instance contains a charge_id (derived from OE_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID) and a charge_amount (derived from OE_PRICE_ADJUSTMENTS.ADJUSTED_AMOUNT), representing the price adjustments applied to an order line that are relevant to taxation.
  • GET_CONTENT_OWNER_ID — returns the content owner identifier for a specified order header, used to determine the correct tax registration and jurisdictional context.

Tables Accessed

The package references several tables through APPS synonyms. OE_ORDER_HEADERS_ALL and OE_ORDER_HEADERS provide order header context. OE_PRICE_ADJUSTMENTS supplies charge and adjustment information consumed by GET_CHARGE_DETAILS. ZX_DETAIL_TAX_LINES_GT is the E-Business Tax detail tax lines interface table used when returning calculated tax results. RA_CUSTOMER_TRX_LINES is referenced through the tax_rec_tbl_type structure, reflecting the relationship between Order Management tax processing and Receivables transaction lines. Additional reference data is drawn from AR_SYSTEM_PARAMETERS_ALL, FND_CURRENCIES, HR_ALL_ORGANIZATION_UNITS, and the HZ party, account, site, and location tables (HZ_CUST_ACCOUNTS_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTIES, HZ_PARTY_SITES), which supply the customer and party information required for tax determination.

Usage Notes

OM_TAX_UTIL is an internal utility rather than a public integration API. It is typically invoked indirectly by the Order Management tax workflow during order entry, order import, or order revision, whenever tax lines must be computed or refreshed. Forms and concurrent programs within Order Management call this package through the tax determination logic, and the ETRM metadata confirms that it is referenced by three other packages. Because the package relies on AUTHID CURRENT_USER and on session-level tax context, custom code that calls it directly should execute under the APPS schema and ensure that the E-Business Tax configuration and customer data are correctly set up. Developers extending the tax flow should treat the charge_rec structure as the mechanism by which price adjustments are communicated into tax calculation, and should not assume that the package performs its own tax rate lookup outside the E-Business Tax engine.