Search Results op_ordr_chg




Overview
Explore in AI Chat

Overview

The OP_ORDR_CHG table is a core transactional data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the central repository for storing all charge information associated with sales orders and their individual lines. This table is critical for capturing the financial and logistical details of additional costs applied to an order, such as freight, handling, taxes, or other surcharges, enabling accurate order costing, invoicing, and profitability analysis. Its role is to link specific charge entries to their parent order header (OP_ORDR_HDR) and order line (OP_ORDR_DTL), ensuring that charges are correctly allocated and processed throughout the order-to-cash cycle.

Key Information Stored

The table's primary key is CHARGE_LINE_ID, which uniquely identifies each charge line record. As indicated by its foreign key relationships, the table stores several critical foreign key columns that establish its context within the order management structure. The ORDER_ID column links the charge to a specific sales order header in the OP_ORDR_HDR table. The LINE_ID column associates the charge with a particular line item within that order, stored in the OP_ORDR_DTL table. The CHARGE_ID references the master definition of the charge type from the OP_CHRG_MST table, which defines the charge's name, calculation basis, and accounting rules. Additionally, the PRESALES_CHARGELINE_ID column links to the OP_PRSL_CHG table, potentially connecting the finalized order charge back to a pre-sales quotation or estimate.

Common Use Cases and Queries

A primary use case is generating detailed order invoices that itemize all applicable charges. Financial reporting and cost analysis also rely on this table to attribute charges to specific orders and products. Common queries include retrieving all charges for a specific order for review or audit, and aggregating charge amounts by type for period-end reporting. Sample SQL patterns often involve joins to the related header, detail, and charge master tables.

  • Retrieve Charges for an Order: SELECT * FROM GML.OP_ORDR_CHG WHERE ORDER_ID = <order_number>;
  • List Charges with Master Description: SELECT och.*, mst.CHARGE_DESCRIPTION FROM GML.OP_ORDR_CHG och, GML.OP_CHRG_MST mst WHERE och.CHARGE_ID = mst.CHARGE_ID AND och.ORDER_ID = <order_number>;

Related Objects

As defined by its foreign keys, OP_ORDR_CHG has direct dependencies on several key GML tables. It is a child table to OP_ORDR_HDR (order headers) and OP_ORDR_DTL (order lines), meaning it cannot exist without a parent order. Its relationship to OP_CHRG_MST ensures charge definitions are consistent and maintained centrally. The link to OP_PRSL_CHG facilitates the flow of charge information from the presales quoting phase into the actual sales order. This table is also likely referenced by various views, reports, and interfaces within the Process Manufacturing Logistics module for charge-related processing and inquiry.