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