R12 Incorrect Mtl_supply When Receiving PO for One Time Items with Multiple Distribution Lines (Doc ID 854683.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

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.

Steps
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

Cause

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