My Oracle Support Banner

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.


Problem Statement:

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.

ORA-1403: No data found

FRM-40735: Pre-block trigger raised unhandled exception ORA:06502


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

  1.  Login as fnd_user with name longer than 30 characters

  2.  Responsibility: US Super HRMS Manager
  3.  Navigate: Work Structures > Position > Position Transaction

  4.  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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.