My Oracle Support Banner

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 DECEMBER 04, 2019

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

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.