My Oracle Support Banner

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.
POAPPRV
PER_ALL_ASSIGNMENTS_F

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

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
Symptoms
Cause
Solution
References


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