My Oracle Support Banner

Datafix: PO Marked FULLY RECEIVED And Cannot Receiving Remaining Balance (Data Corruption In RCV_SHIPMENT_LINES Table) (Doc ID 1223899.1)

Last updated on APRIL 22, 2024

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts GUI



Symptoms

A Purchase Order (PO) shows FULLY RECEIVED even though there is quantity to receive outstanding. The user cannot receive the remaining quantity.
In this case, the item was serialized so the remaining serial numbers show status intransit (current_status 5).

Example
PO Quantity: 6000
Received Quantity: 5947
Balance to be received: 53

Steps
1. Inventory > Transactions > Receiving > Receipts
2. Query the purchase order receipts.
3. Cannot complete the Purchase Order receipt

 

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


Changes

 

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