My Oracle Support Banner

E-SQR: Union Statements in SQR are not Working after Oracle DB Upgrade (Doc ID 2539738.1)

Last updated on FEBRUARY 11, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.58 [Release 8.4]
Information in this document applies to any platform.

Symptoms

After upgrading database from 11g to 12c (12.1.0.2) and attempting to run SQR Reports with Unions/Group By SQL statements, the following error occurs:

"SQL Error:
1406.000000

SQL Error: 1406.000000 -

SQL Error creating Journals. Rolling back. Stopping

Error on line 1762:
  (SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting."


The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to People Tools > Process Scheduler > System Process Requests
3. Create a new Run Cntrl ID or select an existing one
4. Run the affected reports (e.g. AGL00165)

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
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.