No Tables Listed When Creating a Static Table Allocation with Portfolio Table
Last updated on JANUARY 21, 2015
Applies to:Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Service Profitability Management (PFT) 6.1, when trying to create a Static Driver Allocation using "Portfolio Table", no tables are listed under "Portfolio Table Details" > "Instrument Table Name".
Also, when you click on the "Select Table" icon, the message "No data found" appears.
You did run the Table Classification program, Batch_Table_Class_Req, successfully and the instrument tables have the required classification codes of 310 and 100 in the REV_TABLE_CLASS_ASSIGNMENTS table.
Steps to Reproduce:
- Go to Profitability Management
- Go to Rule Specification > Allocation Specification
- Create a new Allocation
- On the "Source" screen, set Table Name = 'Portfolio Table".
No instrument tables are listed under "Portfolio Table Details".
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