Search Results op_prsl_chg




Overview
Explore in AI Chat

Overview

The OP_PRSL_CHG table is a core transactional data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It functions as the central repository for storing charge information associated with presales order profiles. Specifically, it records charges that can be applied at the header level for an entire order profile or at the line level for individual order profile lines. This table is essential for capturing the financial and logistical cost components during the presales and order configuration process, enabling accurate pricing, cost analysis, and subsequent order generation.

Key Information Stored

The table's primary purpose is to link charges to specific presales order entities. Its structure, as indicated by the provided metadata, is defined by key foreign key relationships. The primary identifier is the CHARGE_LINE_ID. The table maintains critical references to other master and transactional entities: the PRESALES_ORD_ID links the charge to the parent order profile header (OP_PRSL_HDR), and the PRESALES_ORDLINE_ID links it to a specific line (OP_PRSL_DTL). The CHARGE_ID column references the charge master table (OP_CHRG_MST), which defines the charge type, calculation basis, and rate. While the full column list is not detailed in the excerpt, typical data stored would include the calculated charge amount, applicable tax, currency, and status flags.

Common Use Cases and Queries

This table is primarily accessed for reporting on presales order profitability, generating charge summaries for customer quotes, and as a source for downstream order generation. A common reporting requirement is to aggregate all charges for a specific presales order. A sample SQL pattern for this would join the charge lines to the header and charge master to provide detail:

  • SELECT oh.order_number, cm.charge_code, cm.description, pc.charge_amount FROM gml.op_prsl_chg pc, gml.op_prsl_hdr oh, gml.op_chrg_mst cm WHERE pc.presales_ord_id = oh.presales_ord_id AND pc.charge_id = cm.charge_id AND oh.presales_ord_id = :p_order_id;

Another critical use case is the propagation of these charges to the actual sales order upon conversion, which is facilitated by the foreign key relationship from the OP_ORDR_CHG table, indicating the presales charge line is the source for the final order charge.

Related Objects

The OP_PRSL_CHG table exists within a tightly integrated schema. Its primary relationships, as documented, are as follows:

  • OP_PRSL_HDR: The parent order profile header table. The foreign key (PRESALES_ORD_ID) enforces this relationship.
  • OP_PRSL_DTL: The order profile lines table. The foreign key (PRESALES_ORDLINE_ID) links a charge to a specific line item.
  • OP_CHRG_MST: The charges master table, which supplies the charge definition via the CHARGE_ID foreign key.
  • OP_ORDR_CHG: A key dependent object. This sales order charges table references OP_PRSL_CHG via the PRESALES_CHARGELINE_ID, showing the direct data flow from presales configuration to final order execution.