'ORA-01403: NO DATA FOUND' Running Calculate After Issue Exporting Version Process Attributes (Doc ID 2237741.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

In Oracle Financial Services Balance Sheet Planning (BSP) 8.0.2.0.6, after adding a new Prepayment in Process Attributes > Version Attribute Definition, when you run a Calculate, the following errors are output to FSI_BSP_PROCESS_LOG:

[MSG-FATAL]: UNABLE TO GET THE PREPAY SYS ID FOR THE VERSION
[MSG-FATAL]: ERROR OCCOURED WHILE POPULATING FSI_FINANCIAL_PLAN [ORA:ERR] ORA-01403: NO DATA FOUND


As a result of this error, the calculate fails.

You notice, after adding the Prepayment and running 'Export Version Definition' from Process Attributes, the Prepayment selection is not exported successfully to FSI_VERSION_ATTIRUBTE.

Reviewing the log DBProcsFuncs_PAttrs_Call.log in $EPM_ORACLE_HOME/logs/bsplog, the PR_VERSION_ATTRIBUTE procedure ran successfully:

2017-02-04 16:26:49,772 INFO com.oracle.bsp.udf.BSPProcedureCall :: { call PR_VERSION_ATTRIBUTE}
2017-02-04 16:26:49,788 INFO com.oracle.bsp.udf.BSPProcedureCall :: stored procedure executed Sucessfully


You do not understand why the Prepayment export fails.

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