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
Subscribe to:
Posts (Atom)