My Oracle Support Banner

R12 Context Issue Responder_Appl_ID And Responder_Resp_ID Set To -1 After Forwarding resulting in VERIFY_APPROVER_AUTHORITY #EXCEPTION (Doc ID 1295780.1)

Last updated on JANUARY 12, 2023

Applies to:

Oracle Purchasing - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

When a Purchase Order (PO) has been forwarded, the document becomes stuck in an IN PROCESS status.  The Purchase Order then does not reach completion without resetting the PO through the reset datafix scripting.

Technical Details:
Wfstat.sql  or Approval Analyzer shows the following attributes:

RESPONDER_APPL_ID:  -1
RESPONDER_RESP_ID:  -1


Supporting Diagnostics:

 •  Purchase Order Query:
     select segment1 po#, revision_num r#, substr(type_lookup_code,1,4) type,
               authorization_status auth_status, cancel_flag, closed_code, wf_item_type,
               wf_item_key, org_id
      from po_headers_all
     where segment1= '&PO_NUMBER'


 •  Diagnostic Scripting:
     wfstat.sql
         - The script is seeded under the $FND_TOP/sql directory
         - Label1 (Item Type)
         - Label2 (Item Key)

 •  Analyzer:
     
EBS Procurement Approval Analyzer - <Note 1525670.1>
     - PO Number
     - Org ID

Changes

 

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
Changes
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.