My Oracle Support Banner

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:

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


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.

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

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.

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




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.