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

Last updated on OCTOBER 01, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.