ORA-06502 PL/SQL: NUMERIC OR VALUE ERROR Error While Running New Business (Doc ID 1665787.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When running a new business rule with New Add Balance no data get generated in the result detail table and the following error occurs.

Error
FSI_BSP_PROCESS_LOG:

FN_BSP_INS_NB
CREATION OF INSTRUMENT RECORD FOR BSP NEW BUSS FAILED_200340
[MSG-FATAL]: ERROR OCCOURED WHILE CREATION OF INSTRUMENT RECORD FOR BSP NEW BUSS - PROCESS ID :200340 [ORA:ERR] ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR


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