My Oracle Support Banner

FA:SCM:RP: Replenishment Plan Ending With ORA-01403 Error (Doc ID 2791166.1)

Last updated on AUGUST 15, 2021

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.21.04.0 and later
Information in this document applies to any platform.

Symptoms

Weekly Replenishment Plan is getting error out with the following error

ERROR
-----------------------
MSC.PLSQL.MSC_REPL_PLAN_RUN : Entering process_demands_temp_table
MSC.PLSQL.MSC_REPL_PLAN_RUN : v_table_name = msc_dmd_100012_dyd
MSC.PLSQL.MSC_REPL_PLAN_RUN : v_table_exist = 1
MSC.PLSQL.MSC_REPL_PLAN_RUN : Error process_demands_temp_table
MSC.PLSQL.MSC_REPL_PLAN_RUN : ORA-01403: no data found
MSC.PLSQL.MSC_REPL_PLAN_RUN : RUN REPLENISHMENT ENGINE Error
MSC.PLSQL.MSC_REPL_PLAN_RUN : ORA-20105: Error in the procedure process_demands_temp_table . The error is -ORA-01403: no data found
MSC.PLSQL.MSC_REPL_PLAN_RUN : write error clob entered


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Replenishment Plan
2. Encounter error in Run Replenishment EngineESS job

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.