ALM Cash Flow Process Is Failing With Behavior Patterns and Full Table Records or More Records
(Doc ID 2972592.1)
Last updated on SEPTEMBER 22, 2023
Applies to:
Oracle Financial Services Asset Liability Management - Version 8.0.5 and laterInformation in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Symptoms
On ALM 8.0.5 version, the same ALM Cash Flow process is successful with behavior patterns and one record or few records, and also works if NOT using behavior pattern. But it is failing with behavior patterns and full table records or more records, there is not any error messages in the relevant process log file, the process just fails with log abruptly and ends with the select statement for example below:
Module Logging OFS calculation module data: select
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
a.PRODUCT_ID, a.LEGAL_ENTITY_ID, a.ALM_COA_ID, a.SBU_ID,
a.CUSTOMER_ID, a.iso_currency_cd, a.id_number, a.identity_code,
....
....
Steps:
The issue can be reproduced with the following steps:
1. Run ALM Cash Flow process with behavior patterns and Full Table Records or More Records
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |