When Adding an Order Line To a Booked Order Error QP_PREQ_GRP.Cache_Line_Qualifiers ORA-01555: snapshot too old: rollback segment number 47 with name "XXXX" too small
(Doc ID 2236400.1)
Last updated on APRIL 14, 2025
Applies to:
Oracle Order Management - Version 12.2 and laterOracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.
OEXOEORD.fmb - Sales Order Form
Quick Sales Order Form
Symptoms
When attempting to multiple order lines to booked order, the following error occurs.
ERROR
Error(s) occured in Oracle Pricing.
STEPS TO REPRODUCE THE ISSUE
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Quick Sales Order
3. Query order
4. Add an order line and save. This goes through fine.
4. Add more order lines and this will throw the Oracle pricing error
CHANGES
Applied <patch 21510787:R12.QP.C>
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 |