My Oracle Support Banner

Total Onhand Quantity Does Match With Total Availability Quantity In Material Work Bench after upgrade from 11i (Doc ID 2281330.1)

Last updated on FEBRUARY 18, 2019

Applies to:

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

Symptoms

On : 12.2.5 version, UAT of Onhand and Availability

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

Note:
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

EXPECTED BEHAVIOR
-----------------------
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.

STEPS
-----------------------
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.

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

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
References


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