IO Policy Plan Fails With mrlsfia_snp_fcst_item_attributes failed due to ORA-00904: "ENTRIES"."INTERMITTENT_DEMAND":

(Doc ID 2215065.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Optimization - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Engine Comp for Oracle RiskOpt

While running an IO Policy Plan the following error is being seen in the Inventory Optimization Planner log file:

after mrwdit_weed_out_items
Call mrlsfia_snp_fcst_item_attributes with plan_id:166123, cutoff_date:2458070
APP-FND-01564: ORACLE error 904 in mrlsfia_snp_fcst_item_attributes

Cause: mrlsfia_snp_fcst_item_attributes failed due to ORA-00904: "ENTRIES"."INTERMITTENT_DEMAND": invalid identifier.

The SQL statement being executed at the time of the error was: select distinct NVL(entries.sr_inventory_item_id,(-23453)) ,NVL(entrie and was executed from the file .
APP-MRP-22075: An internal error has occurred (main, 10, 207, AR_IO_2)
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
Error string=
Statement with the error:
select distinct NVL(entries.sr_inventory_item_id,(-23453)) ,NVL(entrie

The issue can be reproduced at will with the following steps:
1.  Run IO Policy Plan

The issue has the following business impact:
Due to this issue, users cannot run the plan.


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