My Oracle Support Banner

ORA-01422 Error Occurs When Opening Assignment Status Form Due to Duplicate Records in PER_ASSIGNMENT_STATUS_TYPES (Doc ID 2767959.1)

Last updated on APRIL 12, 2021

Applies to:

Oracle Human Resources - Version 12.2 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to open the Assignment Status form, following error occurs.

ORA-01422: exact fetch returns more than requested number of rows

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01422.

An Unexpected Error - 1422 has occurred. An alert has been sent to the system administrator.
ORA-01422: exact fetch returns more than requested number of rows.


When attempting to open Purchase Order Summary form, following error occurs.

APP-PO-14142: Get_Employee-: ORA-0000: normal, successful completion

Cause: A SQL error has occurred in GET_Employee. The SQL error is ORA-0000: normal, successful completion.

Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.



Steps to Reproduce:

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

  1.  Login with HRMS Manager responsibility
  2.  Open Assignment Status form
     (N) Work Structures > Status
  3.  Error occurs


        1. Login with PO super user responsibility
        2. Open Purchase Order Summary form
            (N) Purchase Orders > Purchase Order Summary
        3. Error occurs



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.