Unable To Revise Sales Audit Totals With Sequence Overrun Error
(Doc ID 2976901.1)
Last updated on SEPTEMBER 27, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
On : 19.3 version, ReSA - Others
ACTUAL BEHAVIOR
---------------
Production: Unable to revise Sales Audit Totals with sequence overrun error
Production: Unable to revise Sales Audit Totals with sequence overrun error
ORA-06502-PLSQL: numeric or value error: number precision to large returned by program_unit SA_REALM_SQL.GET_NEXT_ID
Next sequence value is in 7 digits, the local variable in the above function is number 6.
This needs to be increased to 10 so it aligned with SA_REALM.REALM_ID
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to revise an existing Sales Audit total
2. Put total back to worksheet status.
3. Revise a realm adding a new field
4. Include the new field in the restriction
5. attempt to re-approve the totals
6. Notice that the error "numeric or value error: number precision to large returned by program_unit SA_REALM_SQL.GET_NEXT_ID " is displayed.
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 |