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.

Symptoms


ACTUAL BEHAVIOR

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.


EXPECTED BEHAVIOR

Seconds should not be removed from scheduled_start_date , scheduled_completion_date



STEPS

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

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