Item Induction - ACTION_DATE on Process Tracker (iindprctrk) Form Not Correct Data Type
Last updated on APRIL 03, 2017
Applies to:Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.
Although SVC_PROCESS_TRACKER.ACTION_DATE holds the date/time of action (for example, 5/5/2015 4:49:38 PM), the [iindprctrk] form only shows the date and does not include the timestamp. This is an issue because the sort on the form is by ACTION_DATE DESC. Thus, the form will not correctly display records in the correct order when multiple records exist for the same date.
Steps to Reproduce:
1. Load 3 items using the XITEM RIB script.
1. Navigate to Items > Item induction Process Tracker
2. Note that the process IDs are not in the proper order as shown in V_SVC_PRC_TRACKER
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