Module: MRPForecastingSeverity: MEDIUM
Sales Order Demand Exceeds Forecast Consumption Backward / Forward Window
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
forecast consumption errorsales order not consuming forecastbackward consumption days exceeded
Root Cause Analysis
Forecast {forecastName} has consume_forecast = "N" or days window is too narrow for sales order date.
Diagnostic SQL Queries (Read-Only)
CHECK_FORECAST_RULESQuery MRP_FORECAST_DESIGNATORS for consumption rules and backward days
SELECT forecast_designator, organization_id, consume_forecast,
backward_update_days, forward_update_days
FROM mrp_forecast_designators
WHERE forecast_designator = :forecastNameRemediation Mode: MANUAL_UI
Verification Query
SELECT consume_forecast FROM mrp_forecast_designators WHERE forecast_designator = :forecastNameExecute 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.