Transportation Intelligence (FTI) - F_SHIPMENT_EVENT Local Times Missing from EVENT_DATE_LOCAL Column (Doc ID 2261449.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.0 to 6.4.1 [Release 6 to 6.4]
Information in this document applies to any platform.

Symptoms

The customer is reporting that Local Times are missing in the F_SHIPMENT_EVENT table. The dates appear to be working however because in some cases the local date is a different date so the conversion appears to be happening. The values in the EVENT_DATE_LOCAL table look like this:  20170325000000.  Notice the zeros.  This is where the time stamp should appear.



Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:

Steps to Reproduce:


1)  Select any buy/sell shipment and add an event for it.
2)  Also run the action 'Add Event for Location'.
3)  Ensure that the status for the shipment and the respective ORs are in
     READY_TO_LOAD status.
4)  Run ETL

Bug(Actual Result):
Observe that the EVENT_DATE_LOCAL column in F_SHIPMENT_EVENT table is not
getting populated with the complete timestamp.




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