Submit/Place Order for a Quote Error: " FLEXFIELDS SERVER-SIDE VALIDATION package: ORA-06502: PL/SQL: numeric or value error: character to number conversion error"

(Doc ID 1587976.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Quoting - Version 12.0.6 to 12.2 [Release 12.0 to 12.2]
Oracle iStore - Version 12.0.6 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.
FLEXFIELDS SERVER-SIDE VALIDATION
ORA-06502
numeric or value error: character to number conversion error
OE_Validate Procedure Header_Desc_Flex
OE_Validate Procedure Line_Desc_Flex

Symptoms

HTML User Interface

When attempting to Place Order in a HTML Quoting for a quote with several header level descriptive flexfields (DFFs) the following error occurs.

Error

Error messages from Order Management
Program error: Please inform your support representative that: FLEXFIELDS SERVER-SIDE VALIDATION package reports error: table_validate() exception: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
User-Defined Exception in Package OE_Validate Procedure Header_Desc_Flex
There is an error in order submission.


Steps to Reproduce

The issue can be reproduced at will with the following steps:

Quoting

  1. Responsibility: Oracle Quoting
  2. Navigation: Quote
  3. Create a new quote in HTML Quoting
  4. Add quote line
  5. Populate the header level descriptive flexfields and try to submit the quote

OR

iStore

  1. Choose Add To Cart for an item
  2. Choose Checkout and continue button,
  3. Try to choose the Place Order button in the Checkout: Review and Place Order page

 

Changes

 Descriptive Flexfield (DFF) setup changes.

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