My Oracle Support Banner

Error INV_ALL_SQL_ERROR inv_rcv_dir_rcpt_apis.create_rma_drct_dlvr_rti_rec ORA 6502 When Receiving RMA Using Mobile (MSCA) (Doc ID 2470740.1)

Last updated on AUGUST 11, 2022

Applies to:

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


In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

On : 12.1.3 version, Receiving Functions

RMA cant be received
Attribute8 in the Oe_Order_lines_All table is too long, so we receive the error message and the transaction fails. Is there a way we can make this length bigger or suggest a solution for this?
The workaround we are doing now is removing the text or make it shorter, but we would like to have the complete text on it at the receiving process.

INV_ALL_SQL_ERROR Create RMA interface record failed
Routine inv_rcv_dir_rcpt_apis.create_rma_drct_dlvr_rti_rec ORA 6502

The issue can be reproduced at will with the following steps:
1. Perform RMA Receipt using MSCA

2. See below information in the INV Debug log

3. This happens when there is a Descriptive Flexfield enabled for Order Lines and Receiving Transactions and user is trying to enter more than 150 chars in the DFF.


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.