Total Onhand Quantity Does Match With Total Availability Quantity In Material Work Bench after upgrade from 11i

(Doc ID 2281330.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Project Manufacturing - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, UAT of Onhand and Availability

Total On hand quantity and availability shows zero quantity after WIP Job completion for any item code.

1.We are upgrading 11i to R12 (11.5.10 to 12.2.5).
2.System allows transaction.
3. There are no pending transactions/no interface stuck records/no reservations

System should show the total on hand and availability quantity as completed quantity where there are no pending transactions/no interface stuck records/ no reservations against reported item.

The issue can be reproduced at will with the following steps:
1. Perform Wip Job Completion
2.Check On hand Quantity>On hand Availability
3. Select Organization code,item code,check detailed check box and click on find
4. Click on Availability.
5. observe reported issue.

The issue has the following business impact:
Due to this issue, users are misled with incorrect availability information.


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