Cannot See Expression with Multiple Tables in Allocation Screen
Last updated on APRIL 29, 2016
Applies to:Oracle Financial Services Profitability Management - Version 5.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 13-May-2013.
In Oracle Financial Services Profitability Management (OFSPM) 5.2, you cannot see an Expression in the Allocation definition "Source" screen. The Expression drop down list is empty. The Expression contains two different tables in its formula.
For example, the Expression contains the following to calculate a rate:
Rate Lookup Table.EXCHANGE_RATE
Transaction Summary.Previous Day Rate
In the example, the Allocation's Source selects the Transaction Summary table. You expect to see the Expression created earlier in the Allocation's Source screen.
Steps to Replicate:
- Go to Master Maintenance > Expressions
- Create a new Expression
- In the Expression, select a column from two different Entities. One Entity should be the table used in the Allocation.
- Go to Profitability Management > Rule Specification > Allocation Specification
- Create a new Allocation
- Go to the Source screen and select a table used in the Expression.
In this screen, the Expression drop down list does not contain the Expression created earlier.
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