If Stat PS_OPRID names are longer than PeopleSoft’s group ID, Stat is not able to update physical object locking in PeopleSoft.
The issue is due to the PeopleSoft's group ID limitation having a limit of 18 characters while Stat PS_OPRID column has 30 characters showing a mismatch.
For example if the PS_DB_OPRID table has the PS_OPRID column value as PRASHANTH_THEEGALA plus a prefix of 3 which is longer than Peoplesoft's grou ID 'PJ_PRASHANTH_THEEG' (18 characters) there will be a mismatch because PeopleSoft group ID cannot fill the prefix.
Solution 1:
In STAT use PS_OPRID name shorter than 15 character so that will match the PeopleSoft group ID included the prefix of 3.
Solution 2:
To ask to Oracle to change PeopleSoft group id to a longer field.
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center