Item Supply/Demand Form INVDVDSD Includes Items Associated With Closed Purchase Orders (Doc ID 1469983.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

There are a few items in the Supply/Demand Form that are showing Purchase Orders (PO) which are already closed.


Steps
The issue can be reproduced at will with the following steps:

1. Inventory Responsibility
On Hand Availability /  Supply Demand INVDVDSD form
Query Item
Include: All Subinventories
Hit find Button
PO appears although the PO line has been closed

For instance there is a record shown with the following:

Item 000002908
Date = 19-MAY-2009
Supply/Demand Type = Purchase Order
Identifier = 704269
Quantity = 15000

2. Purchasing Responsibility
Purchase Orders / Purchase Order Summary
Check the PO. It is already received and closed
Standard Purchase Order 704269
has Status = Approved, Closed
Line  1
Type Inventory
Item 000002908
Quantity = 15000

Script from <Note 1321193.1>  Datafix to Remove Unwanted Supply From Supply Tables was run but did not change the data.

 

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