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:

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

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