E-INST: PT 8.55 Demo installation fails with "ORA-00997: illegal use of LONG datatype"

(Doc ID 2389852.1)

Last updated on APRIL 23, 2018

Applies to:

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

Symptoms

ENVIRONMENT

=============

Environment: Demo

PT 8.55

 

When attempting to create a PT 8.55 demo environment the following error occurs.

 

ERROR

=======

INSERT INTO PSYPSROLEDEFN (

ROLENAME,

VERSION,

ROLETYPE,

DESCR,

QRYNAME,

ROLESTATUS,

RECNAME,

FIELDNAME,

PC_EVENT_TYPE,

QRYNAME_SEC,

PC_FUNCTION_NAME,

ROLE_PCODE_RULE_ON,

ROLE_QUERY_RULE_ON,

LDAP_RULE_ON,

DESCRLONG,

ALLOWNOTIFY,

ALLOWLOOKUP,

LASTUPDDTTM,

LASTUPDOPRID)

SELECT

SUBSTR(ROLENAME, 1, 30),

VERSION,

SUBSTR(ROLETYPE, 1, 1),

SUBSTR(DESCR, 1, 30),

SUBSTR(QRYNAME, 1, 30),

SUBSTR(ROLESTATUS, 1, 1),

SUBSTR(RECNAME, 1, 15),

SUBSTR(FIELDNAME, 1, 18),

SUBSTR(PC_EVENT_TYPE, 1, 14),

SUBSTR(QRYNAME_SEC, 1, 30),

SUBSTR(PC_FUNCTION_NAME, 1, 30),

SUBSTR(ROLE_PCODE_RULE_ON, 1, 1),

SUBSTR(ROLE_QUERY_RULE_ON, 1, 1),

SUBSTR(LDAP_RULE_ON, 1, 1),

DESCRLONG,

SUBSTR(ALLOWNOTIFY, 1, 1),

SUBSTR(ALLOWLOOKUP, 1, 1),

LASTUPDDTTM,

SUBSTR(LASTUPDOPRID, 1, 30)

FROM PSROLEDEFN

DESCRLONG,

*

ERROR at line 36:

ORA-00997: illegal use of LONG datatype

 

STEPS

======

The issue can be reproduced at will with the following steps:

1. Complete Task 7-2-8 Applying Patched PeopleTools Database Objects

2. Build PATCH855 and PATCH855ML

Changes

 

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