Rebuild of View PS_SSR_RI_OPCV_NLD Fails With Error 'SQL0182N An expression with a datetime value or a labeled duration is not valid. SQLSTATE=42816' on DB2 Platform
(Doc ID 2666431.1)
Last updated on AUGUST 07, 2021
Applies to:PeopleSoft Enterprise CS Campus Community - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Attempting to apply a change package from all fixes from Campus Solutions 9.2 PUM images 14 -16 inclusive results in an error during the 'Creating Views' step in the Finalizing the Database Structure group in Change Assistant The database platform is DB2.
The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0182N An expression with a datetime value or a labeled duration is not
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