No Autobalancing Results On ALM 6.1.0.3 With ORA- 06502: PL/ SQL: numeric or value error: number precision too large ORA- 06512: at "ATOMIC.AUTOBAL_DETERMINISTIC Errors (Doc ID 1930273.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On ALM 6.1.0.3, there are no autobalancing results generated from successful ALM dynamic deterministic process. The following error is found in the debug log:

ERROR

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [34] - 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'
, 407);end;


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.

Cause

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