My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

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


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

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.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.