Last updated on JANUARY 12, 2016
Applies to:Oracle Purchasing - Version 12.0.6 and later
Information in this document applies to any platform.
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.
Wfstat.sql shows the following attributes:
• 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,
where segment1= '&PO_NUMBER'
• Diagnostic Scripting
- The script is seeded under the $FND_TOP/sql directory
- Label1 (Item Type)
- Label2 (Item Key)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms