Discrete Jobs Updated Using WIP Mass Load Not Having Seconds In Scheduled_Start/Completion_Date

(Doc ID 1981709.1)

Last updated on FEBRUARY 26, 2017

Applies to:

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



When inserting first_unit_start_date = scheduled_start_date , last_unit_completion_date = scheduled_completion_date.

When running WIP Mass Load,  seconds are removed from scheduled_start_date , scheduled_completion_date.
i.e. In wip_job_schedule_interface we input first_unit_start_date = 21-feb-2014 14:22:24
it reflects in job as scheduled_start_date = 21-feb-2014 14:22:00.


Seconds should not be removed from scheduled_start_date , scheduled_completion_date


The following steps were used to replicate the issue:

1.  Insert data into wip_job_schedule_interface table.

2.  Run WIP Mass Load

3.  Find that seconds were removed from scheduled_start_date & scheduled_completion_date


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