Creating Discrete Job Is Stuck With "Scheduling Job And Creating Material Requirements." Message

(Doc ID 2308498.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle Work in Process - Version 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....)
4. Save
5.  Running the following SQL shows

select status
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