My Oracle Support Banner

Error Shown When Shipping a Return To Vendor (RTV) (Doc ID 2784507.1)

Last updated on AUGUST 25, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

Scenario#1:

When shipping a specific Return to Vendor below error shown:

ERROR
--------

Error ORA-06502: PL/SQL: numeric or value error: character to number conversion error returned by program unit STKLEDGR_SQL.POST_COST_VARIANCE.


Steps to Recreate:

  1. Create RTV with required details. Note: Alphanumeric value in ret_auth_num field , Different cost than item unit cost.
  2. Try to search the created and approved RTV.
  3. Ship using the option available on the RTV screen.Error shown: ORA-06502: PL/SQL: numeric or value error: character to number conversion error returned by program unit STKLEDGR_SQL.POST_COST_VARIANCE.

 
Scenario #2:

Encountered the below error in SOAP UI when sending an RTVCre message type to RMS.

ERROR
-----------------------
 Error ORA-06502: PL/SQL: numeric or value error: character to number conversion error returned by program unit STKLEDGR_SQL.POST_COST_VARIANCE.


Steps To Recreate:

1. Invoke RTVCre  Message from SOAP UI.

  xml message and all of the data in the message confirm on the required data type and length.

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.