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

Last updated on SEPTEMBER 10, 2024

Applies to:

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

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