E-UPG/E-ORA: 'Running a DBTSFIX Report' Step fails with "(SQR 5528) ORACLE OCIAttrSet(Username) error 24315 in cursor 0: ORA-24315: illegal attribute type" (Doc ID 1055792.1)

Last updated on JULY 19, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.2.0.0 [Release 8.0.3 to 11.2]
Information in this document applies to any platform.
*** Currency checked May 7, 2013 ***

Symptoms

PeopleTools (PT) only upgrade to 8.50.
Change Assistant fails in "Running a DBTSFIX REPORT" step, with the following error :
ERROR
---------
(SQR 5528) ORACLE OCIAttrSet(Username) error 24315 in cursor 0:
ORA-24315: illegal attribute type
(SQR 4701) Cannot logon to the database.

SQR for PeopleSoft: Program Aborting.


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Launch Change Assistant 8.50, with the PT8.50 upgrade template.
2. Run the step "Running a DBTSFIX REPORT".

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to proceed with the PeopleTools 8.50 upgrade.

Cause

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 hundreds of Community platforms