Receipt Fails With RVTCL-040: Subroutine Po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_id:10:-1422

(Doc ID 2272175.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms