Submitting a Purchase Order for Approval fails with: po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_checks_setup:70 ORA-01422
(Doc ID 1908264.1)
Last updated on APRIL 23, 2019
Applies to:Oracle Purchasing - Version 12.1.2 and later
Information in this document applies to any platform.
When a Purchase Order (PO) is submitted for approval the documents gets stuck in the workflow with the following error:
VERIFY_APPROVER_AUTHORITY #EXCEPTION 1
Workflow Attribute SYSADMIN_ERROR_MSG has error:
exact fetch returns more than requested number of rows -
po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check:20:unexpected error in
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call
The Purchase Order is approved by an approver with multiple primary assignments of different types.
In Human Resources it is legitimate and allowed to have multiple primary assignments of different types.
STEPS TO REPRODUCE:
1. Terminate current employment
2. As the Final Settlement Process in Payroll has not completed, do not de-activate the assignment of the ex-employee yet.
3. Immediately, rehire the ex-employee as Contingent worker with an active assignment.
4. Contingent worker submits PO for approval and 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