Error Upon Submitting Position Transactions
(Doc ID 2693841.1)
Last updated on JULY 28, 2020
Applies to:Oracle Human Resources - Version 12.2 HRMS RUP12 and later
Information in this document applies to any platform.
A few users are unable to submit a position on the Position Transaction form. Users receive 2 ORA errors. This is the case for 4 users. All other users of the Position Control module are able to submit transactions (create and update) without any issues.
'Position Transaction' form (PQHWSPTX) will only display positions that are in the actual Position Hierarchy.
FRM-40735: Pre-block trigger raised unhandled exception ORA:06502
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Login as fnd_user with name longer than 30 characters
- Responsibility: US Super HRMS Manager
- Navigate: Work Structures > Position > Position Transaction
- Enter any details then attempt to Save
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