Search Results zx_product_options_all

Overview

The ZX_PRODUCT_OPTIONS_ALL table is a core configuration repository within the Oracle E-Business Tax (ZX) module for Oracle EBS 12.1.1 and 12.2.2. It functions as a central hub for defining and storing tax system options at the operating unit level, segmented by specific EBS application. This table enables the granular control of tax determination and processing rules, ensuring that different applications—such as Order Management, Payables, or Receivables—can have distinct tax behaviors configured for each legal entity or operating unit within a multi-org environment. Its role is pivotal in the E-Business Tax engine's ability to correctly apply tax regimes based on the transactional context.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies a tax configuration set. The critical columns include ORG_ID, which links to the operating unit (HR_ALL_ORGANIZATION_UNITS), and APPLICATION_ID, which references the specific EBS application module (FND_APPLICATION). The EVENT_CLASS_MAPPING_ID column references a tax event class mapping (ZX_EVNT_CLS_MAPPINGS), tying the configuration to specific transactional events like sales or purchases. While the provided metadata does not list all attribute columns, the table logically stores the associated tax options—such as default tax regimes, calculation methods, or reporting flags—for the combination of these three key identifiers. The separate primary key on PRODUCT_OPTIONS_ID suggests the table also supports unique identifier-based access.

Common Use Cases and Queries

Primary use cases involve troubleshooting tax setup, auditing configuration consistency across operating units, and supporting data migrations. A common query retrieves all tax product options for a specific operating unit to validate setup completeness. For example: SELECT * FROM ZX_PRODUCT_OPTIONS_ALL WHERE ORG_ID = :org_id ORDER BY APPLICATION_ID;. Another frequent pattern is joining to application and event class mapping tables to produce a readable report of which tax event classes are active per application per OU: SELECT hou.name, fa.application_short_name, zecm.tax_event_class_code FROM ZX_PRODUCT_OPTIONS_ALL zpoa, hr_all_organization_units hou, fnd_application fa, zx_evnt_cls_mappings zecm WHERE zpoa.org_id = hou.organization_id AND zpoa.application_id = fa.application_id AND zpoa.event_class_mapping_id = zecm.event_class_mapping_id;.

Related Objects

The table maintains documented foreign key relationships with several fundamental EBS objects, as per the provided metadata:

• FND_APPLICATION: Via ZX_PRODUCT_OPTIONS_ALL.APPLICATION_ID. This links the tax options to a specific E-Business Suite application module.
• HR_ALL_ORGANIZATION_UNITS: Via ZX_PRODUCT_OPTIONS_ALL.ORG_ID. This anchors the configuration to a specific operating unit within the multi-org structure.
• ZX_EVNT_CLS_MAPPINGS: Via ZX_PRODUCT_OPTIONS_ALL.EVENT_CLASS_MAPPING_ID. This critical relationship connects the options to a defined tax event class, which drives the tax determination logic for transactional events.

These relationships ensure data integrity and are essential for any joins performed for reporting or diagnostic queries within the E-Business Tax framework.