My Oracle Support Banner

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:

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


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

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