Module: MRPPlanningSeverity: HIGH
MRP / ASCP Planned Order Auto-Release Fails on Inactive Sourcing Rule
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
planned order release failedmrp planned ordersascp auto release exceptionsourcing rule invalid
Root Cause Analysis
Sourcing rule for planned item {itemNum} is disabled or has no active rank 1 supplier allocation.
Diagnostic SQL Queries (Read-Only)
CHECK_SOURCING_RULESInspect sourcing assignment sets for item and organization
SELECT a.assignment_set_id, a.assignment_type, a.sourcing_rule_id,
r.sourcing_rule_name, r.status
FROM mrp_sr_assignments a
JOIN mrp_sourcing_rules r ON a.sourcing_rule_id = r.sourcing_rule_id
WHERE a.inventory_item_id = :itemIdRemediation Mode: MANUAL_UI
Verification Query
SELECT status FROM mrp_sourcing_rules WHERE sourcing_rule_id = :ruleIdExecute 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.