Use Detail Leaves Account Type Not Picked Up From Common COA Dimension Member Gives Incorrect Signage in Ledger Stat Allocation Output
Last updated on NOVEMBER 10, 2016
Applies to:Oracle Financial Services Profitability Management - Version 22.214.171.124 to 8.0.1 [Release 6 to 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Profitability Management (PFT) 126.96.36.199, 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.
Earning Asset account type seems to always be used instead of the account type of the Common COA dimension member.
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
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