Results for “op_prsl_chg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OP_PRSL_CHG is a table owned by the GML schema (Process Manufacturing Logistics) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores charge records associated with an entire order profile and/or individual order profile lines. In Process Manufacturing Logistics, an order profile (presales order) represents a customer-facing quotation or prospective order, and OP_PRSL_CHG captures the pricing adjustments, surcharges, freight, or other charges that apply to that profile or to specific profile lines.

The table is documented as VALID and contains 18 columns in the 12.2.2 physical schema. Its heuristic Data Vault classification, mined from the foreign key structure, is satellite-leaning. In Data Vault modeling terms, this suggests OP_PRSL_CHG behaves as a descriptive satellite attached to a hub or link (the order profile header or line), recording charge attributes that change over time rather than functioning as an independent hub. Modelers should treat CHARGE_LINE_ID as the unique record identifier rather than a natural business key.

Key Information Stored

• CHARGE_LINE_ID — surrogate primary key (OP_PRSL_CHG_PK) uniquely identifying each charge line; the documented unique index and only business-key candidate.
• CHARGE_ID — foreign key to OP_CHRG_MST, identifying the charge definition or charge master record that governs the charge type.
• PRESALES_ORD_ID — foreign key to OP_PRSL_HDR, tying the charge to a specific order profile header.
• PRESALES_ORDLINE_ID — foreign key to OP_PRSL_DTL, tying the charge to a specific order profile line when the charge applies at line level.
• CHARGE_LINE_NO — the sequence or line number of the charge within the profile.
• CHARGE_RATE — the rate factor applied when calculating the charge.
• CHARGE_LINE_AMOUNT — the extended monetary amount for the charge line.
• CHARGE_UNIT_AMOUNT — the per-unit monetary value used in the calculation.
• CHARGE_UOM — the unit of measure in which the charge is expressed.
• BILLABLE_IND — indicator of whether the charge is billable to the customer.

The table also carries standard EBS audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, plus DELETE_MARK for logical deletion, TRANS_CNT for transactional counting, and TEXT_CODE for descriptive text lookup. All 18 columns are documented; the list above is prioritized by functional importance.

Common Use Cases and Queries

Typical scenarios include retrieving all charges for a given order profile, reconciling charge amounts against the profile header or line totals, and reporting billable versus non-billable charges.

• Charges for a profile: SELECT charge_line_id, charge_id, charge_line_no, charge_line_amount FROM op_prsl_chg WHERE presales_ord_id = :p_id AND delete_mark = 0;
• Line-level charges: join OP_PRSL_DTL on PRESALES_ORDLINE_ID to attribute charges to specific profile lines.
• Charge master breakdown: join OP_CHRG_MST on CHARGE_ID to obtain charge names/categories alongside computed amounts.
• Billable charge reporting: filter on BILLABLE_IND = 'Y' and aggregate CHARGE_LINE_AMOUNT by order profile for revenue or surcharge analysis.

Because the table inherits standard audit columns, date-bounded queries using CREATION_DATE or LAST_UPDATE_DATE support incremental data extracts and audit trails.

Related Objects

• OP_PRSL_HDR — order profile header; joined via PRESALES_ORD_ID.
• OP_PRSL_DTL — order profile detail lines; joined via PRESALES_ORDLINE_ID.
• OP_CHRG_MST — charge master defining charge types; joined via CHARGE_ID.
• OP_ORDR_CHG — order charges table, which references OP_PRSL_CHG through PRESALES_CHARGELINE_ID, linking presales charge lines to actual order charges.

These relationships confirm OP_PRSL_CHG as the charge-level detail bridging order profile headers/lines and downstream order charge processing.