ROI RMA Receipt Errors Explode_line_quantity-098: -1422 (Doc ID 750164.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:RVCTP - Receiving Transaction Processor


Symptoms

When attempting to perform RMA Receipt with the Receiving Open Interface, using RCV_TRANSACTIONS_INTERFACE Table, after running the receiving transaction Processor
the following error message can be seen in PO_INTERFACE_ERRORS table

ERROR
Error Message:
explode_line_quantity-098: -1422
Cause: A SQL error has occurred in explode_line_quantity. The SQL error is ORA-01422: exact fetch returns more than requested number of rows.

The issue occurs for one transaction, particular item.

When setting debug profile options per <Note 299497.1> and reprocessing records, RVCTP log file shows the following messages
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1210: Executing RMA Lines cursor with:
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1211: oe_order_header_id: 1604060
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1212: item_id: 265736
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1213: oe_order_line_num:
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1214: to_organization_id: 1607
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1215: customer_item_num:
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1472: Hit exit condition
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1473: Temp table size 0
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1474: Rows fetched 0
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1482: No rows were retrieved from cursor.
[07-NOV-08 11:35:20] RCV_ERROR_PKG begin: v--------Procedure Started-----------v
[07-NOV-08 11:35:20] RCV_ERROR_PKG 180: set error message token =
PO_ALL_SQL_ERROR
[07-NOV-08 11:35:20] RCV_ERROR_PKG 181: error stack from call to
set_error_message
...
[07-NOV-08 11:35:20] RCV_ERROR_PKG end_i: ^--------Implicit Procedure Exit-----^
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1695: 1
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1696: ORA-01422: exact fetch returns more than requested number of rows
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 1697: error 098
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS 353: RMA derive 170 error status: U
[07-NOV-08 11:35:20] RCV_RMA_TRANSACTIONS end_i: ^--------Implicit Procedure Exit-----^
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 1543: Back from derive routine with 0 rows
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 1544: Error Status U
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 1545: Error Message PO_ALL_SQL_ERROR
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 600: update_rti_error after process_line error
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 1813: Set rti row to error
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 1814: p_group_id 1452238
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 1815: p_interface_id 30261832
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 1816: p_header_interface_id
[07-NOV-08 11:35:20] RCV_ROI_PREPROCESSOR 1817: p_lpn_group_id
[07-NOV-08 11:35:20] RCV_ERROR_PKG begin: v--------Procedure Started-----------v
[07-NOV-08 11:35:20] RCV_ERROR_PKG 55: logging error explode_line_quantity-098:
-1422
Cause: A SQL error has occurred in explode_line_quantity. The SQL error is ORA-01422:
exact fetch returns more than requested number of rows.
Action: Take note of both this error number and the actions you were trying to perform.
Contact your system administrator for further assistance.
on column INTERFACE_TRANSACTION_ID

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Populate The interface table RCV_TRANSACTIONS_INTERFACE via a PL/SQL script for RMA receipt
2. Run Receiving Transaction Processor
3. See that the receipt failed and that in PO_INTERFACE_ERRORS table there is the error message

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