ORA-6502 Error When Freight Payment Method Is Set as "CF" on Ordhead Screen (Doc ID 2065753.1)

Last updated on OCTOBER 13, 2015

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

When trying to use Freight Method as CF on [ordhead] (Order - Shipping Information) screen, the following error is received and changes are not saved to database:


Steps to Reproduce:


1. Create a new order from ordhead (PO Header Maintenance) screen.
2. Go to Options -> Shipping.
3. Choose freight payment method as CF.
4. Note that screen throws error : ORA-06502:numeric or value error returned by program unit LANGUAGE_SQL.GET_CODE_DESC

Cause

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 hundreds of Community platforms