My Oracle Support Banner

Troubleshooting Cash Flow Loader Errors in ALM 8.0.x (Doc ID 2415226.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.2 to 8.0.2 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 8.0.2

Purpose

This document lists common errors received when running the Cash Flow Loader program for Oracle Financial Services Asset Liability Management (ALM) 8.0.2.  This program loads data from STG_ACCOUNT_CASH_FLOWS to ALM output tables like RES_DTL_xxxxxx.

Note the Cash Flow Loader requires the following before execution:

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. Batch Fails with 'Empty/Illegal Rule : No Jobs Found'
 2. Error in Log Message14: ORA-01400: cannot insert NULL into ("<atomic>"."RES_DTL_212145"."LEGAL_ENTITY_ID")
 3. Error in Log Message13: ORA-00979: not a GROUP BY expression
 4. Error in Log Message3: ORA-01427: single-row subquery returns more than one row
 5. Load Fail:For the N_SCENARIO_NO 1 mapped in the set up table, the dimension code given is incorrect
 6. Load Fails.The process id 212145 does not exists in the Table fsi_m_alm_process
 7. The Loaded Balances are Larger than Expected (ex. 3x expected balance)
 8. Error in Log Message3: ORA-01427: single-row subquery returns more than one row (after installing patch from #4)
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.