Skip to content
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