Job Stuck In Open Interface With Process Status PENDING (Doc ID 2126023.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Work in Process - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR  
There are rows stuck in the WIP_JOB_SCHEDULE_INTERFACE table in pending status

EXPECTED BEHAVIOR
Rows to process.

STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility = Work In Process (WIP)
2. Navigation = Pending Jobs and Schedules
3. Find 498 rows


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