FSG Profile Options Seem Missing [ID 191086.1]

纵横四海

• fact: NLS - National Language Support
• fact: Oracle General Ledger
• fact: Oracle System Administrator
• fact: FSG - Financial Statement Generator
• symptom: FSG profile options are missing
• change: NOTE ROLErofile options have 2 names: PROFILE_OPTION_NAME and USER_PROFILE_OPTION_NAME.The 2nd is the one as can be read in the application..Following are the FSG profiles available:.USER_PROFILE_OPTION_NAME            PROFILE_OPTION_NAMEFSG: Accounting Flexfield           REPORT_FLEX_CODEFSG: Allow Portrait Print Style     RG_ALLOW_PORTRAITFSG: Enable Search Optimization     RG_USE_NEW_FINDFSG: Enforce Segment Value Security RG_ENFORCE_SEGMENT_SECURITYFSG: Expand Parent Value            EXPAND_PARENT_VALUEFSG: Message Detail                 RG_LOGFILE_DETAIL_LEVELFSG: String Comparison Mode         RG_STRING_COMPARE_MODE FSG:Enable Attribute Reporting      ATTRIBUTE_REPORTING (Used for Public Setcor Financial).Use next sql script to determine the user name to query on in Oracle System Administrator (search_name) to locate the correct profile:.select user_profile_option_name search_name, profile_option_name internal_namefrom fnd_profile_options_vlwhere profile_option_name in ('PROFILE_OPTION_NAME','REPORT_FLEX_CODE','RG_ALLOW_PORTRAIT','RG_USE_NEW_FIND','RG_ENFORCE_SEGMENT_SECURITY','EXPAND_PARENT_VALUE','RG_LOGFILE_DETAIL_LEVEL','RG_STRING_COMPARE_MODE','ATTRIBUTE_REPORTING');
• cause: English translation used to query instead of installed language.
  

fix:Use the returned search_name from the above sql query to search on in the application.


该贴已经同步到 纵横四海的微博