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 MARCH 05, 2019
Applies to:Oracle Financial Services Profitability Management - Version 126.96.36.199 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) 188.8.131.52, 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
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