ASCP Plan Failure : APP-FND-01564: Oracle Error 1854 In Mrfgrq_flush_demands
(Doc ID 1325079.1)
Last updated on FEBRUARY 04, 2022
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.0 and laterInformation in this document applies to any platform.
Symptoms
MSONEW module: Memory Based Planner or 64 bit version of Memory Based Planner fails with
Error string=
Statement with the error:
insert into msc_demands (plan_id,sr_instance_id,demand_id,last_update_
APP-FND-01564: ORACLE error 1854 in mrfgrq_flush_demands
Cause: mrfgrq_flush_demands 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_demands (plan_id,sr_instance_id,demand_id,last_update_ and was executed from the file .
Total memory usage: 3999
Freeing calendar memory
Statement with the error:
insert into msc_demands (plan_id,sr_instance_id,demand_id,last_update_
APP-FND-01564: ORACLE error 1854 in mrfgrq_flush_demands
Cause: mrfgrq_flush_demands 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_demands (plan_id,sr_instance_id,demand_id,last_update_ and was executed from the file .
Total memory usage: 3999
Freeing calendar memory
Changes
<Note 458657.1> - MSONEW App-Mrp-22064 Mrfgrq_flush_demands Ora-01854 Julian Date Must Be - Mentions to relink MSO/MSC to resolve error. Even after relinking error is still thrown.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |