Net Change Simulation Plan Error - 'Julian Date Must Be Between 1 And 5373484'

(Doc ID 1211516.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

Using 'Batch Replan' process for 'what-if' simulations gets the following errors in the'Net Change Simulation Planner 64-bit Linux' .

APP-FND-01564: ORACLE error 1854 in mrcrfl_create_supplies_file
Cause: mrcrfl_create_supplies_file failed due to ORA-01854: julian date must be between 1 and 5373484

The SQL statement being executed at the time of the error was: insert into msc_supplies (plan_id,sr_instance_id,transaction_id,last_u and was executed from the file .
APP-MRP-22075: An internal error has occurred (mrfrec_flush_supplies, 11, 1289, ) @ERRORTEXT
Cause: The current routine encountered the specified@ERRORTEXT x
Action: Contact your customer supportrepresentative.
Error string= Statement with the error: insert into msc_supplies (plan_id,sr_instance_id,transaction_id,


Steps:
1. Log in to Advanced Supply Chain Planner
2. Navigate to Supply Chain Plan -> Workbench
3. Select a plan that has already been run.
4. Open resource availability form for any resource.
5. Use 'Add capacity' function to increase capacity units for the resource.
6. Launch 'Batch Replan'.
7. Witness the error.

Cause

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