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 10, 2021

Applies to:

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


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.

Expect that Job and Schedule Interface Report shows correct Completion Date for the job
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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.