Item Induction - ACTION_DATE on Process Tracker (iindprctrk) Form Not Correct Data Type

(Doc ID 2023181.1)

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