My Oracle Support Banner

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

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

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