Column Missing from Allocation User Interface Screen (Doc ID 1273264.1)

Last updated on JANUARY 24, 2017

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 11-Nov-2013.

Symptoms

In Oracle Financial Services Profitability Management (PFT), you cannot see all columns from a table in the Allocation's Source or Outputs screens.  Some columns are missing from the "Column Name" drop down list.

For example, you may have just loaded a new user defined table into the database using Erwin.  However, you cannot see many columns from that table in the Allocation.  Custom columns also do not appear.

Steps to Reproduce:

  1. Add a new custom table to the Erwin Data Model
  2. Upload the new version of the Data Model using Unified Metadata Manager > Import Model
  3. Go to Financial Services Applications
  4. Go to Profitability Management > Rule Specification > Allocation Specification
  5. Create a new Allocation
  6. Go to the "Source" screen
  7. Select the new table from the Table Name list

There is only one column listed in the Column Name drop down list.

Cause

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