No Tables Listed When Creating a Static Table Allocation with Portfolio Table

(Doc ID 1962264.1)

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:

  1. Go to Profitability Management
  2. Go to Rule Specification > Allocation Specification
  3. Create a new Allocation
  4. 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