Module: OTMCostingSeverity: HIGH
OTM Shipment Actual Freight Cost Exceeds Purchase Order Accrual
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
freight cost accrual discrepancyotm freight variancecarrier invoice out of balance
Root Cause Analysis
Carrier invoice voucher {voucherNum} includes unapproved accessorial fuel surcharge charges.
Diagnostic SQL Queries (Read-Only)
CHECK_FREIGHT_VARIANCECompare planned freight cost vs carrier actual voucher amount
SELECT s.shipment_gid, s.total_actual_cost, v.total_amount_voucher
FROM shipment s
JOIN voucher v ON s.shipment_gid = v.shipment_gid
WHERE s.shipment_gid = :shipmentGidRemediation Mode: MANUAL_UI
Verification Query
SELECT count(*) FROM voucher WHERE shipment_gid = :shipmentGid AND payment_status = 'APPROVED'Execute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.