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

Last updated on JANUARY 20, 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

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