Error Message APP-PO-15556 on Lot Entry Form INVTTELT Delivering RMA / Incorrect Negative Quantity (Doc ID 1591357.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Receiving Functions

When attempting to deliver remaining quantity for a split Return Material Authorization (RMA) line
On Lot Entry  form  / In Lot Numbers tab

. The quantity is defaulting to  a negative quantity

. When attempting update the value to positive value get message


Steps
The issue can be reproduced at will with the following steps:

1) For an RMA line that has been already partially received / split

2) Navigate to Receiving Transactions form RCVTXERT
Search for RMA Number
See one record with Quantity N
Destination Type = Inventory
Enter Subinventory and Locator.
Click on Lot - Serial button.

3) In Lot Entry form, INVTTELT see the Item Quantity is Positive, but on the Lot Numbers tab, for Lot Number <lot> the Quantity is Negative.
Both fields are yellow.

4) You already have file versions at or above those in <Note 863645.1>

Version    Patch Number    File Versions
11.5.10     7195205     
$ONT_TOP/patch/115/sql      OEXLSRLB.pls      115.12.11510.4
$ONT_TOP/patch/115/sql      OEXLSRLS.pls      115.6.11510.1
$ONT_TOP/patch/115/sql      OEXUREQB.pls      115.189.11510.17
$ONT_TOP/patch/115/sql      OEXUREQS.pls      115.43.11510.2

R12.1     10028348   
$ONT_TOP/patch/115/sql      OEXLSRLB.pls      120.2.12010000.2
$ONT_TOP/patch/115/sql      OEXLSRLS.pls      120.0.12010000.1
$ONT_TOP/patch/115/sql      OEXUREQB.pls      120.23.12010000.10
$ONT_TOP/patch/115/sql      OEXUREQS.pls      120.1.12010000.3

(You can check these by running the 'Diagnostics: Apps Check' concurrent program for Order Management. Refer to <Note 276207.1>.)

 
5) When performing SQL trace
5.1) raw trace from RCVRCERC shows
SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY, SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_ID
Bind#0
 value="PO_RMA_QUANTITY_VAL_FAILED"

2) tkprofed trace shows last instruction is

********************************************************************************
SELECT SUM(MTLN.PRIMARY_QUANTITY)
FROM
MTL_MATERIAL_TRANSACTIONS MMT , MTL_TRANSACTION_LOT_NUMBERS MTLN WHERE
 MMT.TRX_SOURCE_LINE_ID IN (SELECT LINE_ID FROM OE_ORDER_LINES_ALL WHERE
 LINE_SET_ID = :B3 ) AND MMT.TRANSACTION_SOURCE_TYPE_ID = 12 AND
 MMT.TRANSACTION_ACTION_ID IN (1,27) AND MMT.TRANSACTION_TYPE_ID IN (15,36,
 37) AND MMT.INVENTORY_ITEM_ID = :B2 AND MMT.ORGANIZATION_ID = :B1 AND
 MTLN.TRANSACTION_ID = MMT.TRANSACTION_ID 
********************************************************************************

Note: Another symptom may be that issue occurs when receiving RMA when Sales order is created in UOM other than Primary UOM.

Cause

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