Receipt Fails With RVTCL-040: Subroutine Po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_id:10:-1422 (Doc ID 2272175.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

On :  12.1.3 version, Receiving Functions

Receiving transactions stuck in RCV_TRANSACTIONS_INTERFACE with an error. 
This particular user has never been able to create a receiving transaction.   This issue is occurring for just this one user.  Other users are able to log in with the same responsibility and successfully create receipts against this PO.

ERROR
RVTCL-040: Subroutine po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_id:10:-1422
ORA-01422: exact fetch returns more than requested number of rows -  po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_close_po:60:get_employee_id not successful -  po.pls

STEPS
The issue can be reproduced at will with the following steps:
1. The employee experiencing this receiving problem was a recent re-hire.
2. He originally terminated back in 2000 and was re-hired in 2017.
3. To re-activate we removed the termination date from his employee record in the Enter Person form and then set him up as an Oracle user.
4. He reported back he was not able to receive against a PO.

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, one user cannot complete receipts.

Changes

Cause

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