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 laterInformation 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 |