Creating Discrete Job Is Stuck With "Scheduling Job And Creating Material Requirements." Message
Last updated on SEPTEMBER 18, 2017
Applies to:Oracle Work in Process - Version 126.96.36.199 and later
Information in this document applies to any platform.
When attempting to create a new jobs, the following error occurs.
Scheduling Job and creating material requirements.. and the job is not created.
The issue can be reproduced at will with the following steps:
1. Responsibility = Work In Process (WIP)
2. Navigation = Discrete-> Discrete
3. Enter the the header information (assembly, Class and Quantity....)
5. Running the following SQL shows
where owner='APPLSYS' and index_name='FND_LOBS_CTX' and table_name='FND_LOBS';
Response is INRPOGRS <<<< you MUST get this response to the above query. Otherwise, do not proceed with the action plan
6. Also, the FND log will show:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE in Package wip_bomRoutingUtil_pvt Procedure explodeRouting
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