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 FEBRUARY 26, 2017

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

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