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"
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
numeric or value error: character to number conversion error
OE_Validate Procedure Header_Desc_Flex
OE_Validate Procedure Line_Desc_Flex
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 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:
- Responsibility: Oracle Quoting
- Navigation: Quote
- Create a new quote in HTML Quoting
- Add quote line
- Populate the header level descriptive flexfields and try to submit the quote
- Choose Add To Cart for an item
- Choose Checkout and continue button,
- Try to choose the Place Order button in the Checkout: Review and Place Order page
Descriptive Flexfield (DFF) setup changes.
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