My Oracle Support Banner

RTV Maintenance Window [rtv] Throws ORA-06502 and ORA-01403 Errors (Doc ID 1668908.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.6 to 13.2.8 [Release 13.2]
Oracle Retail Merchandising System - Version 14.0 to 14.0.2 [Release 14.0]
Information in this document applies to any platform.


If a long string for VPN is entered in the VPN field of an Item Supplier, Return To Vendor (RTV) creation for that item will fail with below errors:



"ORA-06502 : PL/SQL numeric or value error."

"ORA-01403 : no data found."


Steps to recreate

  1. Create an item
  2. Add a supplier.
  3. Add a long VPN string such as 'SIT BEAUTY CREATE FRO: SIT TES'
  4. Create a new RTV
  5. Add a supplier.
  6. Add a store for which stock on hand for the item is greater than 0.
  7. Add the item.
  8. Add “quantity returned”
  9. Click on Apply.
  10. Following error occurs:

      ORA-06502 : PL/SQL numeric or value error.

      ORA-01403 : no data found.





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.