My Oracle Support Banner

When Running SPP Plan In Net Change Mode, MSCSDW Fails With APP-FND-01564 and ORA-00904 (Doc ID 2024429.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Service Parts Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Using Support Parts Planning / Net Change Planning
On 12.2.4 in Production:
When attempting to run an SPP plan with Netchange = Yes
the following error occurs in the MSCSDW module: Snapshot Delete Worker:

ERROR
-----------------------

APP-FND-01564: ORACLE error 904 in mrnwpl_delete_mrp_table
Cause: mrnwpl_delete_mrp_table failed due to ORA-00904: "INVENTORY_ITEM_ID": invalid identifier


-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. (R) Service Parts Planner
2. Launch Service Supply Chain Planning Process
3. Set parameter Netchange = Yes
4. Observe that MSCSDW module: Snapshot Delete Worker failes with the noted error.

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
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.