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 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a new jobs, the following error occurs.

ERROR

Scheduling Job and creating material requirements.. and the job is not created.

STEPS

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
from
all_indexes
where owner='APPLSYS' and index_name='FND_LOBS_CTX' and table_name='FND_LOBS';

shows

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

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