My Oracle Support Banner

E-SQR: SQR Reports Executing "TRUNCATE" SQL Command Throws The Error "SQL Error = ORA-00001: unique constraint (SYSADM.PS_XXX) violated" (Doc ID 1670300.1)

Last updated on OCTOBER 13, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 and later
Information in this document applies to any platform.

Symptoms

After upgrade to PT8.51.23 when running SQR Reports that truncate multiple tables the following error occurs:
"SQL Error = ORA-00001: unique constraint (SYSADM.PS_A0_B_1AR_ACTENT) violated

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

SQR for PeopleSoft: Program Aborting."

The process is using "TRUNCATE" SQL command specified with Capital Letters.

Steps:
-------
The issue can be reproduced at will with the following steps:
1. Login to PIA;
2. Navigate to Process Scheduler > System Process Requests
3. Select an existing Run Control Id or add a new one;
4. Run the SQR Reports
5. The error occurs in the out file generated by sqr functionality

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!


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