Subcontracting Workbench Shows Closed PO When Querying For Only Open PO's (Doc ID 2202751.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Outsourced Mfg for Discrete Industries - Version 12.2.5 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms