Discrete Jobs Updated Using WIP Mass Load Not Having Seconds In Scheduled_Start/Completion_Date
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