My Oracle Support Banner

Pricing Error On Sales Order Lines After Database Upgrade - Routine: QP_PREQ_GRP.Mini_Cache_Qualifiers ORA-01555 (Doc ID 2157734.1)

Last updated on FEBRUARY 27, 2019

Applies to:

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


On : 12.1.3 version, Pricing, Discounting & Charges

When attempting to enter an order line,
the following error occurs.

Error(s) occurred in Oracle Pricing:
Routine: QP_PREQ_GRP.Mini_Cache_Qualifiers ORA-01555:
Snapshot too old. Rollback segment number 38 with name
"$TEMPUNDOSEG" too small

The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Orders
3. Enter order line
Error message is shown.

Upgraded the database from to

Running the below 2 seeded concurrent requests does resolve the issue sometimes and Sales Order line is priced.
However, the same message shows up on the next sales order we enter

a. "Build Attribute Mapping Rules"
b. "QP: Maintains the denormalized data in QP Qualifiers"


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

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