Blanket Sales Agreement Creation Via API OE_BLANKET_PUB.Process_Blanket Errors - "ORA-06502: PL/SQL numeric or value error: number precision too large in Package OE_Blanket_Util Procedure API_Rec_To_RowType_Rec" (Doc ID 2942208.1)

Last updated on MARCH 12, 2024

Applies to:

Symptoms

When attempting to creates Blanket Sales Agreements via the API OE_BLANKET_PUB.Process_Blanket the following error occurs.

ERROR
Error occurring while creating Blanket Sales Agreement using OE_BLANKET_PUB.Process_Blanket() API:
ORA-06502: PL/SQL numeric or value error: number precision too large in Package OE_Blanket_Util Procedure
API_Rec_To_RowType_Rec

STEPS

1. Create a PLSQL script through which API OE_BLANKET_PUB.Process_Blanket is invoked to create Blanket Sales Agreement
2. Execute the PLSQL script via SQL Developer or through a custom concurrent program which invokes this PLSQL procedure
3. 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

Cause

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