My Oracle Support Banner

Completion Date in Job and Schedule Interface Report is Different from Completion Date in WIP Mass Load Result (Doc ID 1991311.1)

Last updated on MAY 13, 2018

Applies to:

Oracle Work in Process - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

On : 12.2.3 version, After running WIP Mass Load to change scheduled completion date for a job, program output (Job and Schedule Interface Report) is not in sync with the actual completion data of the job.

EXPECTED BEHAVIOR
-----------------------
Expect that Job and Schedule Interface Report shows correct Completion Date for the job
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run WIP Mass Load to change Completion Date from 16-JAN-15 18:00 to Completion Date= 16-JAN-15 20:00 for a job
2. WIP Mass Load completes normally
3. Completion date 16-JAN-15 20:00 is out of calendar shift (Shift time range is 8:00-18:00), so WIP Mass Load changes Completion Date to 16-JAN-15 18:00 >> this is correct
4. Check Job and Schedule Interface Report and see incorrect Completion Date= 16-JAN-15 20:00 >> this is incorrect
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.