Value Too Large Error if Return Material Authorization is More Than 30 Bytes
(Doc ID 2494612.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle iProcurement - Version 12.2 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.
Return cannot be submitted if more than 30 bytes are entered in Return Material Authorization.
Application: ICX, Message Name: value too large for column "PO"."RCV_TRANSACTIONS_INTERFACE"."RMA_REFERENCE" (actual: 36, maximum: 30).
Steps to Reproduce
- Login to iProcurement
- Receiving > Return Items
- Enter "Return Quantity" and click Next
- Select Reason from LOV
- Enter more than 30 characters in "Return Material Authorization" field.
- Click Next
- Click Submit
- Error occurs: Your receipt could not be created successfully due to an unexpected error. Please contact your system administrator with the following information for further assistance. "Application: ICX, Message Name: value too large for column "PO"."RCV_TRANSACTIONS_INTERFACE"."RMA_REFERENCE" (actual: 36, maximum: 30)."
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