BI Publisher – SQL Get Profile Options Values
Get information on a profile option
SELECT * FROM FND_PROFILE_OPTIONS_B WHERE PROFILE_OPTION_NAME = '{profile option name}'
Get information on the levels set for a profile option
SELECT * FROM FND_PROFILE_OPTION_LEVELS WHERE PROFILE_OPTION_ID = ( SELECT PROFILE_OPTION_ID FROM FND_PROFILE_OPTIONS_B WHERE PROFILE_OPTION_NAME = '{profile option name}' )
Get information on the values of a specific profile option
SELECT * FROM FND_PROFILE_OPTION_LEVELS WHERE PROFILE_OPTION_ID = ( SELECT PROFILE_OPTION_ID FROM FND_PROFILE_OPTIONS_B WHERE PROFILE_OPTION_NAME = '{profile option name}' )
GET USER PROFILE VALUES
SELECT v.level_name, v.level_value, p.username, r.email_address as EMAIL, v.profile_option_value, v.creation_date, v.created_by, v.last_update_date, o.last_updated_by, o.profile_option_name FROM fnd_profile_option_values v, fnd_profile_options_b o, per_users p, hz_parties h, jtf_rs_resource_profiles r WHERE v.profile_option_id = o.profile_option_id AND o.profile_option_name = 'FND_NUMBER_FORMAT' AND v.level_value = p.user_guid AND v.level_name = 'USER' AND v.profile_option_value LIKE '%]' AND p.user_guid = h.user_guid and h.party_id = r.party_id
Check Object work-flow Task profile option
select * from fusion.Fnd_Profile_Option_Values v, fusion.Fnd_Profile_Options o where v.profile_option_id = o.profile_option_id and o.profile_option_name = 'HZ_INVOKE_OBJ_WF_ON_TRACKING';
Manage Document Sequences
SELECT * FROM FND_DOCUMENT_SEQUENCES SELECT * FROM FND_DOC_SEQUENCE_ASSIGNMENTS
Manage Document Sequences - Audit
SELECT FND_DOC_SEQUENCE_AUDIT.DOC_SEQUENCE_ID, FND_DOCUMENT_SEQUENCES.NAME, FND_DOC_SEQUENCE_AUDIT.DOC_SEQUENCE_VALUE, FND_DOC_SEQUENCE_AUDIT.LAST_UPDATE_DATE, HZ_PARTIES .PARTY_NAME Last_Updated_By FROM FND_DOC_SEQUENCE_AUDIT INNER JOIN HZ_PARTIES ON (HZ_PARTIES.USER_GUID = FND_DOC_SEQUENCE_AUDIT.LAST_UPDATED_BY) INNER JOIN FND_DOCUMENT_SEQUENCES ON (FND_DOCUMENT_SEQUENCES.DOC_SEQUENCE_ID = FND_DOC_SEQUENCE_AUDIT.DOC_SEQUENCE_ID) WHERE FND_DOC_SEQUENCE_AUDIT.DOC_SEQUENCE_ID = ( SELECT DOC_SEQUENCE_ID FROM FND_DOCUMENT_SEQUENCES WHERE NAME = 'MOO_REVN_SEQUENCE' )ORDER BY FND_DOC_SEQUENCE_AUDIT.LAST_UPDATE_DATE DESC