After migration to OBPM 10.3.2 some database datatypes are still DATE (Doc ID 1299404.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version: 10.3.2 and later   [Release: AS10gR3 and later ]
Information in this document applies to any platform.

Symptoms

The BPM 10.3.2 changed the type of time columns in the Oracle database from DATE  to TIMESTAMP
However, even after applying the scripts available in migration folder 1031 to 1032, the engine schema
PNOTIF table has a DATE datatype for column 'RECEIVETIME'

Similar, the directory schema FUEGO_OBJCLASSINST table has DATE datatype for the columns FUEGO_MOTIME and FUEGO_CRTIME.

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