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

Last updated on JULY 01, 2024

Applies to:

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

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