Results for “use_ship_to_geo”

4 results




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

Overview

ARP_TAX_VIEW_TAXWARE is an Oracle Receivables (AR) package body that belongs to the partner integration layer of Oracle E-Business Tax (EBTax). Its name reflects the older "Taxware" third-party tax engine integration model, in which Oracle applications exchanged tax-relevant attributes with an external tax calculation vendor through a well-defined view interface. In Oracle EBS 12.1.1 and 12.2.2, EBTax superseded the legacy Taxware-style architecture, yet the package body persists as a compatibility and view-provider component that supplies tax attributes for Receivables transactions and related documents.

The package is owned by APPS and is classified as OTHER in the ETRM metadata. It exposes a set of PL/SQL functions that return discrete pieces of tax-related header, line, and party information, effectively defining the shape of a tax view contract consumed by the tax engine. Each function is a public entry point that maps an underlying Receivables or Order Management attribute to a value the tax service can read.

Key Procedures and Functions

The ETRM metadata documents 19 public functions:

  • PRODUCT_CODE, COMPANY_CODE, DIVISION_CODE — Return item or organization classification attributes used to categorize the taxable good or service. The header source shows PRODUCT_CODE returning a null character value as a placeholder, indicating these are view-contract stubs.
  • VENDOR_CONTROL_EXEMPTIONS — Supplies vendor-level exemption behavior, determining how exemption rules apply to vendor transactions.
  • USE_NEXPRO — Indicates whether the Nexpro tax engine is in use, a legacy routing flag.
  • USE_SECONDARY — Controls whether secondary tax classification or a secondary tax regime is applied. This is the object most associated with the search term "use_secondary".
  • TAX_SEL_PARM — Returns the tax selection parameter used to drive tax determination.
  • SERVICE_INDICATOR — Flags whether the line represents a service rather than a tangible good.
  • GET_EXEMPTIONS — Retrieves exemption information applicable to the transaction.
  • POA_ADDRESS_CODE, POO_ADDRESS_CODE, SHIP_FROM_ADDRESS_CODE, SHIP_TO_ADDRESS_CODE — Return address role codes for the pay-on-account, pay-on-order, ship-from, and ship-to locations, which drive place-of-supply determination.
  • CALCULATION_FLAG, AUDIT_FLAG — Return flags governing whether tax is calculated and whether the transaction is audited.
  • TOTAL_TAX — Returns the total tax amount for the transaction or line context.
  • CUSTOMER_CODE, TRANSACTION_DATE, CUSTOMER_NAME — Return customer identity, transaction date, and customer name attributes.

The package also declares a constant USE_SHIP_TO_GEO and FND_LOG runtime-level constants, enabling debug logging through FND_LOG.STRING keyed on ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.

Tables Accessed

The ETRM metadata does not enumerate tables accessed via APPS synonyms for this package body. The documented source excerpt references MTL_SYSTEM_ITEMS in the PRODUCT_CODE description, noting that segment1 is returned and that users may define a different segment for the product code. Given the tax-view contract, related reads would typically target Receivables transaction and customer tables, though these are not confirmed in the supplied metadata.

Usage Notes

The package is referenced by two other packages, indicating it serves as a supporting provider rather than a top-level entry point. It is not directly invoked by forms or concurrent programs; instead it is called by the tax determination and view layers during Receivables transaction processing. The USE_SECONDARY function is significant because it governs secondary tax application behavior, and the presence of USE_NEXPRO and USE_SHIP_TO_GEO highlights the package's role in preserving legacy routing and geography logic within the modern EBTax framework.