FSG Profile Options

• Document 165339.1,Generating a FSG Report Application Does Not Find Profile Values for RG_LOGFILE_DETAIL_LEVEL and EXPAND_PARENT_VALUE

FSG: Message Detail = Normal
FSG: Expand Parent Value = No

• Document 191086.1,RGRARG FSG Profile Options Are Missing

Profile options have 2 names: PROFILE_OPTION_NAME and USER_PROFILE_OPTION_NAME. The 2nd is the one that can be read in the application. . Following are the FSG profiles available:

 

 

USER_PROFILE_OPTION_NAME	PROFILE_OPTION_NAME
FSG: Accounting Flexfield	REPORT_FLEX_CODE
FSG: Allow Portrait Print Style	RG_ALLOW_PORTRAIT
FSG: Enable Search Optimization	RG_USE_NEW_FIND
FSG: Enforce Segment Value Security	RG_ENFORCE_SEGMENT_SECURITY
FSG: Expand Parent Value	EXPAND_PARENT_VALUE
FSG: Message Detail	RG_LOGFILE_DETAIL_LEVEL
FSG: String Comparison Mode	RG_STRING_COMPARE_MODE
FSG: Enable Attribute Reporting	ATTRIBUTE_REPORTING (Used for Public Sector Financials)

 

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_name
from fnd_profile_options_vl
where 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');

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