ORA-06502: NUMBER PRECISION TOO LARGE IN PACKAGE OE_BLANKET_UTIL PROCEDURE
(Doc ID 2749238.1)
Last updated on AUGUST 18, 2021
Applies to:
Oracle Order Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.9 version, Agreements/Blankets/Contracts
An error is coming from API "OE_BLANKET_PUB.PROCESS_BLANKET" when using Concurrent Program XXXXX_OM_QUOTE_BSA: XXXXXX OM Quote to BSA Conversion.
The error occurs when executing API to process with any Responsibilities except the Oracle Configurator Responsibility.
LOG FILE
-----------------------
Enter OE_Blanket_Line_Security.Attributes
LEAVING OE_MSG_PUB.ADD
Entering OE_BLANKET_UTIL.CONVERT_MISS_TO_NULL for Line
p_x_line_rec.accounting_rule_id :
Exiting OE_BLANKET_UTIL.CONVERT_MISS_TO_NULL for line
exit default attributes - Line
LEAVING OE_MSG_PUB.COUNT_AND_GET
OE_Blanket_PUB.Process_Blanket Return status - U Number of OE messages :1
Message :ORA-06502: PL/SQL: numeric or value error: number precision too large in Package OE_Blanket_Util Procedure API_Rec_To_RowType_Rec
ERROR
-----------------------
Error: ORA-06502: PL/SQL: numeric or value error: number precision too large in Package OE_Blanket_Util Procedure API_Rec_To_RowType_Rec
STEPS
-----------------------
The issue occurs when creating a Blanket Sales Agreement using OE_BLANKET_PUB.Procces_Blanket() API.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |