Linking Oracle Apex Application Page in an Email Notification. 1. Code your Apex notify process using APEX_UTIL.PREPARE_URL. Assign it to a variable Ex: v_url := v_url := APEX_UTIL.PREPARE_URL( p_url => 'f?p=' || :APP_ID || ':x:'||:APP_SESSION||'::NO:RP,5:P5_ID:'||:p5_id, p_checksum_type => 'PUBLIC_BOOKMARK'); 2. Use the variable v_url in your mail notification content. 3. On PXX_ID page item, go to security, set session state protection to Checksum Required - Session Level. 4. On Page XX, go to security settings, set Deep linking to "Enabled" and Page Access protection to "Arguments Must have checksum". The above steps will enable email notifications to directly link to an Apex application Page.
Posts
Showing posts from March, 2022