Add Leaf Procedure Fails with Exceeds Limit of 256 Explicit Columns in SELECT List in OFSA 4.5
Last updated on JULY 28, 2017
Applies to:Oracle Financial Data Manager - Version 4.5.39 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
Note: All OFSA 4.5 products have reached sustaining support.
In Oracle Financial Services Applications (OFSA) 4.5.39, you cannot add a new user defined leaf to the OFSA environment. When you run the ADD_LEAF procedure, you receive the following error:
Leaf Colummn: PROD_COA_ID
Display Name : 'Prod COA ID'
Leaf Type: B
DBF Name: PRODCOA
Exceeds limit of 256 explicit columns in SELECT list
Use * in the SELECT list to reduce number of explicit columns
in the view SELECT list
The error is repeated for the following additional views:
The error causes the ADD_LEAF procedure to end without completing and the new user defined leaf is not added to OFSA_CATALOG_OF_LEAVES.
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