PeopleTools 8.5 seems to have changed application data type Datetime to using Oracle data base data type TIMESTAMP(6) from DATE. PeopleTools is common for the Oracle PeopleSoft applications (Financials, HCM, CRM) and this change most likely was made with one of the applications in mind.
Oracle database data type TIMESTAMP is proprietary with Oracle providing functions. Implies adding code using the TIMESTAMP functions for code using SQL with database links. Ventyx precompiler seems to ignore Oracle specific SQL in larger SQL. Example: Using SYSTIMESTAMP in VALUES clause.
PeopleTools 8.5 meta data Datetime change to TIMESTAMP problem
PeopleTools 8.5 seems to have changed application data type Datetime to using Oracle data base data type TIMESTAMP(6) from DATE. PeopleTools is common for the Oracle PeopleSoft applications (Financials, HCM, CRM) and this change most likely was made with one of the applications in mind.
Oracle database data type TIMESTAMP is proprietary with Oracle providing functions. Implies adding code using the TIMESTAMP functions for code using SQL with database links. Ventyx precompiler seems to ignore Oracle specific SQL in larger SQL. Example: Using SYSTIMESTAMP in VALUES clause.
Early Jan 2010