Cannot Change The Project And Task To Null And Task To Null Using The Work In Process (WIP) Mass Load
Last updated on JULY 28, 2016
Applies to:Oracle Work in Process - Version 12.2.3 and later
Information in this document applies to any platform.
On : 12.2.3 version, Open Interfaces
When attempting to update Work Order Header Project ID and Task Id to null using the WIP Mass Load, the following error occurs.
Error: Invalid value for Project.
1. No such project currently exists.
2. Project References are not enabled in your organization.
The issue can be reproduced at will with the following steps:
1. Update the WIP_JOB_SCHEDULE_INTERFACE table PROJECT_ID and TASK_ID columns with FND_API.G_NULL_NUM
2. Launch Mass Load for row
3. Update the WIP_JOB_SCHEDULE_INTERFACE table PROJECT_ID and TASK_ID columns with FND_API.G_NULL_CHAR
4. Launch Mass Load for row
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms