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:

Symptoms

When a Purchase Order (PO) is submitted for approval the documents gets stuck in the workflow with the following error:

ERROR
-----------------------
VERIFY_APPROVER_AUTHORITY #EXCEPTION 1
User-Defined Exception

Workflow Attribute SYSADMIN_ERROR_MSG has error:

po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_checks_setup:70: -1422ORA-01422:
exact fetch returns more than requested number of rows -
po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check:20:unexpected error in
authority_checks_setup -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call

SYMPTOMS:
-------------
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

Cause

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