EGL9.1+: While Adding New Chartfields Encountered "The new prompt table name for <New CF Name> already exists in database. (9050,25)"

(Doc ID 2166555.1)

Last updated on NOVEMBER 16, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.



Unable to add a new chartfield on the advanced CF configuration page. Encountered a message : "The new prompt table name for xxxx already exists in database. (9050,25)" not able to proceed further.

Steps to replicate:
1. Navigate to Main Menu> Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Configure > Advanced Configuration
2. Click on 'Add New ChartField' Button.
3. On the next pop-up select Type of ChartField as 'Standard' & click OK.
3. Fill the New Cf name, Field length, Long name , short name.
4. Fill new prompt table names in the new name column of Prompt Tables grid & Click OK

Actual Behavior

The new prompt table name for <New CF Name> already exists in database. (9050,25)

Expected Behavior

No message should appear & new chartfield should be added on the Advanced CF configuration page.


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