Subcontracting Workbench Shows Closed PO When Querying For Only Open PO's
(Doc ID 2202751.1)
Last updated on JUNE 18, 2021
Applies to:
Oracle Outsourced Mfg for Discrete Industries - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
12.2.5
PROBLEM
-------------
In Subcontracting Workbench. when we search to see only subcontracting PO's with 'Purchase Order Status = 'Open' and click on Go button.
Search Results show 'Closed' and 'Finally Closed' PO's in the results.
STEPS
--------
Open workbench - components tab
search for order type - Subcontracting Order
-- enter OU and Subcontracting org
In MORE Search options - choose Purchase Order Status - Open
Check results
-- see 7 PO's listed in screen shot
export-of-PO-headers.xlsx
SELECT * FROM po_headers_all
where segment1 in ('&po1','&po2', [etc]);
FileComment
-----------------
PO headers output shows:
SEGMENT1 CLOSED_CODE
11111
11112 FINALLY CLOSED
11113
11114 CLOSED
11115 OPEN
11116 CLOSED
EXPECTED BEHAVIOR
----------------------------
Closed PO should not show up in this view.
NOTE: The query for closed PO is showing correct outputs
BUSINESS IMPACT
----------------------
cannot use this query effectively
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 |
| Cause |
| Solution |
| References |