Hi,
I have a questionnaire form in my application to insert values to database. Once the form is submitted, data gets inserted and a new unique id is generated. I was to send this unique id to the user in a email with a link to the record for this id. The link should open the form with all the details.
This is the email content:
"Hello,
<br>
<a href = "&P18_MY_HIDDEN_URL.">&P18_ID. </a> questionnaire has been updated for customer &P18_CUST.</a> in &P18_INDUSTRY. industry by &APP_USER.
<br>"
And P18_MY_HIDDEN_URL is obtained with code below
"DECLARE
l_app number := v('APP_ID');
l_session number := v('APP_SESSION');
l_url varchar(4000);
BEGIN
:P18_MY_HIDDEN_URL := APEX_UTIL.PREPARE_URL(
p_url => 'http://apex.oraclecorp.com/pls/apex/f?p=' || l_app || ':10:::NO:10:P10_ID:'||:P18_ID,
p_checksum_type => 'SESSION');
END;"
1.However when I try to open the link from email, it throws following error after login.
2.I noticed that though checksum is passed , it is not populated in the url. I do not want to set the page 10 unrestricted as I do not want to allow the user to modify the paramter in url and view other entries.
3.Note that i have enabled deep linking for the app.
4. Please let me know how to get this link working and why checksum is not being passed. Is it a bug from APex. I also noticed this post in the forum about the same checksum issue