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.
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
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
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