My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2022

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)


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.