Error(s) In Oracle Pricing: Routine:QP_PREQ_GRP.Cache_Line_Qualifiers ORA-01722: (Doc ID 2294570.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Pricing, Discounting & Charges

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

We applied the patch 25942264 last night and ran a batch. We are seeing below errors with Order import program now. Not seen these before. I am uploading the entire log file as well. Please advise. Thanks


Failed to perform Action Request BOOK_ORDER
Failed to perform Action Request BOOK_ORDER
Failed to perform Action Request BOOK_ORDER
Failed to perform Action Request BOOK_ORDER
Failed to perform Action Request BOOK_ORDER
No. of orders found: 909
No. of orders imported: 0
No. of orders failed: 909


Source/Order/Seq/Line Message
1001/11222021522//81/2007631 Error(s) occured in Oracle Pricing: Routine:QP_PREQ_GRP.Cache_Line_Qualifiers ORA-01722: invalid number

Also happens when entering order manually.

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. Run Order Import
2. Getting the error on all orders - Error(s) occured in Oracle Pricing: Routine:QP_PREQ_GRP.Cache_Line_Qualifiers ORA-01722: invalid number
Also, seen when entering order manually.

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