Use Detail Leaves Account Type Not Picked Up From Common COA Dimension Member Gives Incorrect Signage in Ledger Stat Allocation Output (Doc ID 1911802.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 to 8.0.1 [Release 6 to 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Profitability Management (PFT) 6.1.0.3, when using Detail Leaves for the Account Type for Financial Element dimension members, the correct account type is not picked up from the output Common COA dimension member.

ACTUAL BEHAVIOR
Earning Asset account type seems to always be used instead of the account type of the Common COA dimension member.

EXPECTED BEHAVIOR
Per Appendix E Debit & Credit Conventions of the PFT User guide:

Determining Account Type
In examining any output row (whether from an allocation's debit specification or its
credit specification) the allocation engine employs the following logic:
• Examine the row's Financial Element
• Determine the value of the Financial Element's Account Type attribute
• If the Financial Element's Account Type attribute cannot determine account type,
examine the row's Common Chart of Accounts (Common COA) value
• Determine the value of the Common COA's Account Type attribute

Determine the Account Type of the Common Chart of Accounts
When a row's fundamental account type (DR or CR) cannot be determined from the
Account Type attribute associated with its Financial Element (i.e., when the Account
Type attribute takes on the special < Use Detail Leaves > value), the allocation engine
determines the row's debit or credit status by examining the Account Type attribute
associated with its Common Chart of Account value.

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

1. Run either a constant allocation or static driver allocation
2. Check the output:

 FE = 100 with account type = "Detail Leaves" and COMMON account type = Earning Asset. DR = 100 CR = -100
 FE = 100 with account type = "Detail Leaves" and COMMON account type = Interest-Bearing Liabilities DR = 100 CR = -100

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