My Oracle Support Banner

Location Delivery Schedules START_TIME and END_TIME Show as DATE in DB Viewer and Not TIME (Doc ID 2861690.1)

Last updated on JANUARY 10, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.


Location Delivery Schedules in MFCS.

The SOURCE_DLVRY_SCHED_DAYS table shows START_TIME and END_TIME as 01/01/1970, when it should should show the time values entered in the delivery schedule via the UI

The issue can be reproduced at will with the following steps:

1. Login to MFCS
2. Navigate to Manage Supplier > More Actions > Delivery schedules
3. Location Delivery Schedules window opens in MFCS
4. Select the Destination Location as Warehouse and enter Warehouse_Id
5. Select Manage Delivery Schedules > Frequency as Everyday
6. Start time as 10:00 and end time as 11:00
7. Click on Ok
8. Delivery Schedules can be viewed in "Location Delivery Schedules " Screen
9. Query the table : select * from SOURCE_DLVRY_SCHED_DAYS where location='';
10. Observe the records Start_Time, End_Time in DB show only 01/01/1970 and not the times entered in the UI.


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.