After RPC5 Error QP_PREQ_GRP.Cache_Line_Qualifiers ORA-01722 If Number Format Is Set To 10.000,00

(Doc ID 2390655.1)

Last updated on MAY 01, 2018

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Entry

After applying RPC5, users are hitting an error when attempting to save sales order lines with qty.

The issue only occurs for users having number format Set To 10.000,00


ERROR
-----------------------
Error(s) occured in Oracle Pricing: Routine:QP_PREQ_GRP.Cache_Line_Qualifiers ORA-01722: invalid number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Sales Order Responsibility,
2. Sales Order Form,
3. Create a Sales Order,
4. Sales Order Tab,
5. Add a Sales Order line,
6. Attempt to save the Sales Order,
7. Error occurs.

 

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