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.
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