Posted by Please find the complete document from here download document
Reference Source: view original source
Steps: 1
- Log in to your database using SYS with SYSDBA privilege.
- Execute the below command:
|
1 2 3 4 5 6 |
begin apex_instance_admin.set_parameter( p_parameter => 'CLONE_SESSION_ENABLED', p_value => 'Y'); end; / |
Steps: 2
- Create a New Apex application page and a Classic Report Report Region
- Add the below SQL as query source, you can use with your own
|
1 2 3 4 5 6 7 8 9 10 11 12 |
select empno, ename, sal, job, hiredate, mgr, comm deptno, '<a href="'||'f?p=&APP_ID.:5:&APP_SESSION.'||':APEX_CLONE_SESSION::5:P5_EMPNO:'||EMPNO||'" target="_blank">'||'View details'||'</a>' as EmployeeDetails from emp |
- Go to the column property of classic report> column: EMPLOYEEDETAILS> set type = Percent Graph
Steps: 3
- Create another page (in my case the page No. 5) and add another classic report
- Add a Hidden Text Field “P5_EMPNO” in Page 5
- Add the below query source for classic report in page-5
|
1 |
select * from emp where empno = :P5_EMPNO |
- Go to the classic report property and change the following setting:
- Click “Attributes” of classic report
- Go to Appearance > Template : Select “Value attribute Pairs –Column”
- Go to Pagination > Type: select “No Pagination…”
- Save changes
Steps: 4
- Under Page property (Page-5) go to Security> Deep Linking: select “Enabled”
- Or you can do it from Shared components. Go to Shared components > Application Definition Attributes> Security> Session Management > Deep Linking: Enabled
Steps: 5
- Go to Page-1 and run the page
- Click any of the link button “View details” link button
- Page-5 will be appeared and EMPNO will be passed from Page -1 to P5_EMPNO field
- Page-5 will be appeared in a new tab along with new session id
- Each tab is independent for doing any transaction or any data processing. None of the tab will be overwritten or merged into single tab
Note: if any of the tab page is signed out, rest of the opened tab page will be signed out automatically.
Thank you for your patience.
Good Luck !!