Thursday, March 7, 2013

Peoplesoft: Prompts not working?

Setid based prompts require a row for current setid to be present in SET_CNTRL_TBL and a row in PS_INSTALLATION if anything deleted in them check if this is the reason prompts not working.

NLS_LENGTH_SEMANTIC

Before setting NLS_LENGTH_SEMANTIC = CHAR and recreating tables, check if tables are already created in unicode (CHAR) format. query user_tab_columns where char_length < data_length

The Economist: Daily news and views