My Oracle Support Banner

E-SEC: OPRDEFNDESC Defined As Mixed (30) However Online Entry Allows More Than 30 On PSOPRDEFN (Doc ID 3063031.1)

Last updated on DECEMBER 10, 2024

Applies to:

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

Symptoms

On : 8.60 version, Security


Noticed a discrepancy with on line entry versus entry done using sql. On line lets the OPRDEFNDESC entry to be bigger than it should. Noticed when trying to troubleshoot instances in which people were having blank OPRDEFNDESC on psoprdefn.  The value in OPRDEFNDESC should not be allowed to be larger than the 30 max value.


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

1. Attempt to change the value in OPRDEFNDESC on the backend and it will not work, there is no error however there is incorrect behavior

2. Navigate to PeopleTools > Security > User Profiles > User Profiles online

3. Go to the ID tab and change User Description to a value more than the 30 max limit, this works.



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.