Search Results provider_id




Overview
Explore in AI Chat

Overview

The ZX_PRVDR_LINE_EXTNS_GT table is a global temporary table within the Oracle E-Business Tax (ZX) module. It serves a critical role in the tax determination and reporting architecture for Oracle EBS 12.1.1 and 12.2.2. Its primary function is to act as a staging area for extensible, line-level tax attributes that must be transmitted to an external tax service provider, such as Vertex or a similar partner service, for real-time tax calculation or reporting. The 'GT' suffix indicates its temporary nature; data is session-specific and persists only for the duration of a tax processing transaction, ensuring data isolation and performance efficiency during high-volume tax calls.

Key Information Stored

The table is designed to store a combination of transaction identifiers and extensible attribute data. Its structure is defined by a composite primary key that uniquely identifies each record for a specific tax provider and transaction line. The key columns, as documented, are APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, PROVIDER_ID, and TAX_REGIME_CODE. The PROVIDER_ID column is of particular importance, as it identifies the specific external tax service (e.g., Vertex O Series) for which the extensible attributes are intended. The table's description emphasizes that it holds "extensible attributes," implying that beyond the key columns, it likely contains user-defined or provider-specific columns (not detailed in the provided metadata) to pass custom data points required by the external service for accurate tax processing.

Common Use Cases and Queries

The primary use case is during the tax calculation engine's callout to an external provider. Before invoking the service, the E-Business Tax engine populates this table with line-level data from the transaction (e.g., from RA_CUSTOMER_TRX_LINES for Receivables) along with any custom attributes configured for the provider. A typical query pattern would involve selecting data for a specific transaction and provider to debug tax calculation issues or to verify the data payload being sent. For example: SELECT * FROM ZX.ZX_PRVDR_LINE_EXTNS_GT WHERE TRX_ID = :p_trx_id AND PROVIDER_ID = :p_provider_id; Reporting use cases are less common due to the table's temporary nature, but it is central to customizations that require passing additional line-level information to a tax service provider. Developers might query it within a debug session to ensure custom attributes are populated correctly.

Related Objects

As a global temporary table, it is primarily referenced programmatically by the E-Business Tax engine's PL/SQL logic rather than through declarative foreign key constraints. Its relationship to other objects is defined by its primary key composition. The columns APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, and TRX_LINE_ID directly correlate with core E-Business Tax transaction tables like ZX_LINES. The PROVIDER_ID column would relate to the configuration of tax service providers within the E-Business Tax module, likely referencing a setup table such as ZX_PARTNER_SERVICES or similar. The table's data is sourced from transaction lines (e.g., from modules like Order Management or Receivables) and is consumed by the tax provider application programming interface (API) that formats and transmits the data to the external service.

  • Table: ZX_PRVDR_LINE_EXTNS_GT 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PRVDR_LINE_EXTNS_GT,  object_name:ZX_PRVDR_LINE_EXTNS_GT,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the extensible attributes required/ need to be passed to the partner service at the line level for the purpose of tax processing/reporting. ,  implementation_dba_data: ZX.ZX_PRVDR_LINE_EXTNS_GT , 

  • Table: ZX_CONTENT_SOURCES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_CONTENT_SOURCES,  object_name:ZX_CONTENT_SOURCES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores multiple sources from which tax configuration content can be loaded. Each row stores details about a content source for a specific regime. ,  implementation_dba_data: ZX.ZX_CONTENT_SOURCES , 

  • Table: ZX_PRVDR_LINE_EXTNS_GT 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PRVDR_LINE_EXTNS_GT,  object_name:ZX_PRVDR_LINE_EXTNS_GT,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the extensible attributes required/ need to be passed to the partner service at the line level for the purpose of tax processing/reporting. ,  implementation_dba_data: ZX.ZX_PRVDR_LINE_EXTNS_GT , 

  • Table: ZX_CONTENT_SOURCES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_CONTENT_SOURCES,  object_name:ZX_CONTENT_SOURCES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores multiple sources from which tax configuration content can be loaded. Each row stores details about a content source for a specific regime. ,  implementation_dba_data: ZX.ZX_CONTENT_SOURCES , 

  • Table: ZX_PRVDR_HDR_EXTNS_GT 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PRVDR_HDR_EXTNS_GT,  object_name:ZX_PRVDR_HDR_EXTNS_GT,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the user extensible attributes that need to be passed to the partner service at the transaction level for the purpose of tax processing/reporting. ,  implementation_dba_data: ZX.ZX_PRVDR_HDR_EXTNS_GT , 

  • Table: ZX_PRVDR_HDR_EXTNS_GT 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PRVDR_HDR_EXTNS_GT,  object_name:ZX_PRVDR_HDR_EXTNS_GT,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the user extensible attributes that need to be passed to the partner service at the transaction level for the purpose of tax processing/reporting. ,  implementation_dba_data: ZX.ZX_PRVDR_HDR_EXTNS_GT ,