My Oracle Support Banner

ALM Autobalancing Process Does Not Output Any Autobalancing Products to the Result Detail Table (Doc ID 2675796.1)

Last updated on MAY 14, 2021

Applies to:

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

Symptoms

The ALM Dynamic Process with Autobalancing checked is not outputting any autobalancing products in Res Dtl table.

The process runs successfully, there are no errors in the ALM debug log and the FSI_PROCESS_ERRORS do not show any fatal errors.  Normal output does seem to be generated for the rest of the processed products.

The issue can be reproduced at will with the following steps:

1. Definition of tax rates and dividend amounts (if applicable) per modeling bucket in the Active ALM Time Bucket rule. This includes:
• Federal tax percentage
• State tax percentage
• Dividend amount
• Dividend percentage

2. Set-up of Product Characteristic information for the auto-balancing asset plug member and auto-balancing liability plug member

3. Verify that all auto-balancing product members are tied to Common COA Ids with the correct account type designation. The following mappings are required:

Auto-balancing Account
Account Type Attribute (through Common COA)
Asset
Earning Asset
Liability
Interest Bearing Liability
Retained Earnings
Equity
Dividends
Dividends
Federal Taxes
Taxes
State Taxes
Taxes
Accumulated Translation Balance
Equity

4. Percentage taxable information is correctly defined in Product Characteristics for each product member.

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
Cause
Solution
References


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