My Oracle Support Banner

IB Receiving Transactions Stuck With Error Message (Doc ID 1479866.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to process RMA return from depot repair (CSIRMARC) for an instance with a future active end date the following error occurs:

You have encountered an unexpected error in match_mtl_txn_for_txn_dtl, with error ORA-01403: no data found.
 The parameter value (Lot / Serial) for the parameter (Item attributes) is ignored. The transaction details entered do not match the inventory material transaction for one or more of the attributes. Pl. correct it and reprocess the error.

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Perform an RMA Receipt transaction for an active instance which has a future active end date

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.