Receipt Fails With RVTCL-040: Subroutine Po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_id:10:-1422
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.
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.
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