ORA-01403: No Data Found In Package OE_Delayed_Requests_PVT, when scheduling fails.
Last updated on JUNE 28, 2017
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
OEXOEORD.fmb - Sales Order form
OEXOETEL.fmb - Quick Sales Order form
When scheduling a line against a Model (ATO/PTO) or Kit, and scheduling fails,
the following error occurs:
ORA-01403: no data found in Package OE_Delayed_Requests_PVT Procedure Process_Request_Pvt
In Process message window, the following message may be shown.
Order: xxxx Line: x.x..x Message_text: Scheduling failed: Cannot meet request date or latest acceptable date.
STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Order Management Responsibility 2. Create a new Sales Order with ATO Model or Kit, with an included item which is not available. 3. Book or Schedule Order 4. Error is reported
"Scheduling failed" is valid message, but ORA-01403 should not occur.
Error also encountered, When attempting to change ship to address on the Quick Sales order form (or Sales Order form) sometimes receive the error occurs. Lines are in Entered status. Scheduling process is triggered.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms