My Oracle Support Banner

PA_FP_GEN_AMT_WRP: Generating Financial Plans Gives ORA-01426: numeric overflow in Package PA_FP_GEN_FCST_AMT_PUB1 Procedure call_clnt_extn_and_update_bl (Doc ID 2708822.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

Oracle Project Planning and Control - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When generating a new version of ANY financial plan, the following error is received:

ORA-01426: numeric overflow in Package PA_FP_GEN_FCST_AMT_PUB1 Procedure call_clnt_extn_and_update_bl
User-Defined Exception in Package PA_FP_GEN_FCST_AMT_PUB Procedure GENERATE_FCST_AMT_WRP
User-Defined Exception in Package PA_FP_GEN_FCST_PG_PKG Procedure UPD_VER_DTLS_AND_GEN_AMT

Financial plans were successfully generating and then just began to error with no patches applied or known changes to the instance.  

Fnd_log_messages shows the issue in

pa.plsql.PA_RES_ASG_CURRENCY_PUB.MAINTAIN_DATA 5 After calling
PA_RES_ASG_CURRENCY_PUB.ROLLUP_AMOUNTS: S

call_clnt_extn_and_update_bl 5 Before collecting budget lines for a ra id
call_clnt_extn_and_update_bl 5 Unexpected ErrorORA-01426: numeric overflow

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.