My Oracle Support Banner

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 MAY 06, 2020

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

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.

ERROR
-----------------------
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
valid. SQLSTATE=42816


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.