My Oracle Support Banner

ORA-06502: NUMBER PRECISION TOO LARGE IN PACKAGE OE_BLANKET_UTIL PROCEDURE (Doc ID 2749238.1)

Last updated on FEBRUARY 15, 2021

Applies to:

Oracle Order Management - Version 12.2.9 and later
Information 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


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