MSCNSP Memory Based Snapshot Fails with: mscsnr_snp_routings failed due to ORA-01502: index 'MSC.MSC_ROUTINGS_N1' or partition of such index is in unusable state

(Doc ID 273298.1)

Last updated on APRIL 27, 2017

Applies to:

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

Symptoms

MSCNSP module: Memory-Based Snapshot Fails with

fetching info on request: 8953
APP-FND-01564: ORACLE error 1502 in mscsnr_snp_routings

Cause: mscsnr_snp_routings failed due to ORA-01502: index 'MSC. MSC_ROUTINGS_N1' or partition of such index is in unusable state

The SQL statement being executed at the time of the error was:
select
decode(oper_res.resource_id,null ,(-1),rout_oper.department_id) and was
executed from the file 3073565/msc/src/mslsyi.pc.
APP-MRP-22075: An internal error has occurred (mrnspxt, 17, 10010, ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10010, ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
APP-MRP-22075: An internal error has occurred (main, 13, , ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
Freeing calendar memory

Statement with the error:
select decode(oper_res.resource_id,null ,(-1),rout_oper.department_id)
3073565/msc/src/mslsyi.pc

 

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