R12 Incorrect Mtl_supply When Receiving PO for One Time Items with Multiple Distribution Lines
Last updated on JUNE 01, 2016
Applies to:Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
FORM:RCVRCERC.FMB - Enter Receipts
FORM:RCVTXERT.FMB - Enter Receiving Transactions
Find for Purchase orders for one time item, ie if item_id is not entered, with multiple distributions lines, after performing the Receive transaction there is one record in mtl_supply with all the quantity under one distribution.
As a consequence user is not able perform receive and deliver separately for multi Distribution case as quantities are not getting split in Receiving Transactions Form .
The issue also occurs for expense items.
The issue can be reproduced at will with the following steps:
1. Navigate to Purchase Order form
Enter one standard purchase order with one line - no item . Quantity =10
Line has one shipment line
Shipment line is split into 3 distribution lines (quantity 4,3 and 3) with expense destination type
This issue is for one time items on a PO (having multiple distributions) with
Line Type = Goods,
Purchase Basis = GOODS and
Matching Basis = QUANTITY
2. Approve purchase order
Run below query
5. Navigate to Receiving / Receiving transactions form RCVTXERT
Search for the Purchase order
See that line appears with Multiple Destination
if clicking on + sign
3 records appear
Last record has quantity 10
The others have quantity 0
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