Search Results op_invc_chg




Overview
Explore in AI Chat

Overview

The OP_INVC_CHG table is a core transactional data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the detailed repository for tax and charge information associated with individual lines on an invoice. Its primary role is to store and manage the specific tax calculations and additional charges applied to an order line during the invoicing process. This table is critical for ensuring accurate financial postings, tax reporting, and audit trails for transactions generated within the Process Manufacturing supply chain. By linking invoice lines to master tax and charge definitions, it provides the granular detail necessary for financial compliance and cost analysis.

Key Information Stored

The table's structure is designed to capture the relationship between an invoice line and its associated financial adjustments. The key columns, as defined by its primary and unique keys, establish its core identity and relationships. The LINECHARGE_ID serves as the primary unique identifier for each record. The unique key constraint (OP_INVC_CHG_UK) enforces business rule integrity by ensuring a specific combination of INVOICE_ID, LINE_ID, CHARGE_ID, and TAXAUTH_ID is not duplicated. Other significant columns include CHARGE_ID, which links to the master charge definition, and TAXRATE_ID and TAX_STATUS, which link to the specific tax rate and tax status applied to the line. The table typically stores calculated amounts, tax bases, and rates for each charge or tax line.

Common Use Cases and Queries

This table is central to inquiries and reports concerning the tax and charge composition of invoices. A common use case is analyzing the tax breakdown for a specific invoice or a set of invoices within a period for financial reporting or audit purposes. Developers and analysts query this table to reconcile invoice totals, investigate tax calculations, or support customer inquiries about line-item charges. A typical reporting query would join OP_INVC_CHG to the invoice headers and lines tables, as well as to the tax master tables to retrieve descriptive information.

Sample SQL Pattern:
SELECT oic.invoice_id, oic.line_id, oic.charge_id, ccm.charge_name, oic.calculated_amount, ttd.tax_rate
FROM gml.op_invc_chg oic
JOIN gml.op_chrg_mst ccm ON oic.charge_id = ccm.charge_id
LEFT JOIN applsys.tx_taxa_dtl ttd ON oic.taxrate_id = ttd.taxrate_id
WHERE oic.invoice_id = :p_invoice_id;
This query fetches all charges and linked tax rates for a given invoice, providing a detailed line-item audit.

Related Objects

The OP_INVC_CHG table is integral to a network of related objects, primarily defined through its foreign key constraints. It is a child table that draws its master definitions from several key reference tables.

  • OP_CHRG_MST: Linked via OP_INVC_CHG.CHARGE_ID. This relationship provides the master definition (name, type, account) for the charge applied on the invoice line.
  • TX_TAXA_DTL: Linked via OP_INVC_CHG.TAXRATE_ID. This relationship provides the specific tax rate details used in the calculation.
  • TX_TAXA_STS: Linked via OP_INVC_CHG.TAX_STATUS. This relationship provides the tax status code that determines the taxability of the transaction line.

Furthermore, OP_INVC_CHG is a child of the invoice line table (implied by INVOICE_ID and LINE_ID), making it a critical component in the invoice transaction hierarchy.