No Autobalancing Results On ALM 220.127.116.11 With ORA- 06502: PL/ SQL: numeric or value error: number precision too large ORA- 06512: at "ATOMIC.AUTOBAL_DETERMINISTIC Errors
Last updated on JANUARY 05, 2018
Applies to:Oracle Financial Services Asset Liability Management - Version 18.104.22.168 to 8.0.0 [Release 6 to 8]
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)
On ALM 22.214.171.124, there are no autobalancing results generated from successful ALM dynamic deterministic process. The following error is found in the debug log:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  - oexec(),
oexn() SQL Function:  - PL/ SQL EXECUTE Oracle Error: ORA-
06502: PL/ SQL: numeric
or value error: number precision too large ORA- 06512: at
"ATOMIC.AUTOBAL_DETERMINISTIC", line 2817 ORA- 06512: at
"ATOMIC.AUTOBAL_DETERMINISTIC", line 1185 ORA- 06512: at line 1
Driver Function: drv_oci::Execute() SQL Statement: declare begin
Autobal_Deterministic.autobal(200448, 'APPADMIN' , '07/ 31/ 2014'
The issue can be reproduced at will with the following steps:
1. Create ALM process with autobalancing leaves set up in application preferences and Autobalancing checked in the process definition. Review results in Res_DTL_xxxxx.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms