My Oracle Support Banner

Difference In Datatype Between BICC Data Store and Extracted Data - BICC UI Shows Data Store Column as DATE Datatype, Extracted Data Shows As TIMESTAMP Datatype (Doc ID 2481819.1)

Last updated on FEBRUARY 02, 2020

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version and later
Information in this document applies to any platform.


There is a difference in datatype on column(s) between what is shown in the BICC UI and what is being extracted. The BICC UI shows data store column(s) as DATE datatype, whereas the extracted data shows as TIMESTAMP datatype. This can be seen on any datastore/column.


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.