Requisition Approval Ends With No Approver Found When Building Default Approval List (Doc ID 284844.1)

Last updated on MARCH 06, 2023

Applies to:

Symptoms

Requisition is not completing approval and is stopping in an "Incomplete" status with the workflow
listed with the step of Build Default Approval List in failure. No exception errors are noted.

The workflow has the following activities as shown in the following excerpt:

56 30-SEP-2004 14:26 Main Requisition Approval Does Approval List Exist? COMPLETE N
58 30-SEP-2004 14:26 Main Requisition Approval Build Default Approval List COMPLETE FAILURE
60 30-SEP-2004 14:26 Main Requisition Approval Return Requisition to Submitter COMPLETE
ACTIVITY_PERFORMED
61 30-SEP-2004 14:26 Return Requisition to Submitter Start COMPLETE #NULL
63 30-SEP-2004 14:26 Return Requisition to Submitter Set Req Status to Original Status COMPLETE
ACTIVITY_PERFORMED
65 30-SEP-2004 14:26 Return Requisition to Submitter Get Preparer Notification Attribute COMPLETE
ACTIVITY_PERFORMED
67 30-SEP-2004 14:26 Return Requisition to Submitter Notify Requestor of No Approver Available
COMPLETE #NULL <user_name>
69 30-SEP-2004 14:26 Return Requisition to Submitter Is Submitter Last Approver? COMPLETE Y
71 30-SEP-2004 14:26 Return Requisition to Submitter End COMPLETE #NULL
74 30-SEP-2004 14:26 Main Requisition Approval End COMPLETE #NULL


The workflow debug data for this record indicates the following from this debug data exceprt:

PO_REQAPPROVAL_ACTION.set_doc_mgr_context. USER_ID= <user_id> APPLICATION_ID=<application_id> RESPONSIBILITY_ID= <responsibility_id>
PO_REQAPPROVAL_INIT1.Ins_actionhist_submit: 01
PO_REQAPPROVAL_INIT1.Ins_actionhist_submit: 02
Does_Approval_List_Exist: 001
Does_Approval_List_Exist: 002 - l_approval_list_header_id:
Build_Default_Approval_list: 001
Build_Default_Approval_list: 002-86717-REQUISITION-INTERNAL
Build_Default_Approval_list: 003-86717-2338--10357
Build_Default_Approval_list: 004-get_default_approval_list-1.05
Build_Default_Approval_list: 020 1.05
Build_Default_Approval_list: 021- E_NO_SUPERVISOR_FOUND OR E_NO_ONE_HAS_AUTHORITY
PO_REQAPPROVAL_INIT1.set_doc_to_originalstat: 01
PO_REQAPPROVAL_INIT1.set_doc_to_originalstat: 02 Auth_status= IN PROCESS, Orig_auth_stat= INCOMPLETE


The workflow attribute Total Amount shows the following document total amount:
TOTAL_AMOUNT_DSP 12,528.00

Cause

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