EBS R12 How to Autolaunch JNLP files (Java web start) on Modern Browsers ?

Unlike IE, when we open EBS forms (with JWS enabled) on Edge (or) chrome,  form (jnlp) files will be downloaded and we have to manually click and launch. Business users may not like this behaviour. Please find the steps to auto launch JWS forms on Edge, Firefox & Chrome 

Firefox:

a. Please open firefox .  Click on Menu -->Settinga

b.  In the search box, enter applications & Click on Jnlp content type and Choose the action as    C:\Program Files (x86) (or Program Files) \Java\<version>\bin\javaws.exe 

c. Open anew tab, type about:config in the address bar and press Enter/Return. Click the button accepting the risk -- this change involves some risk.

d. In the search box ,Enter browser.download.skipConfirmLaunchExecutable  & choose  Boolean and Click Add

e. Results should look like below.

f. Now Restart the browser and try to launch forms now. It should auto launch

Microsoft Edge:

IE mode in Edge allows organizations to continue to use legacy elements of Internet Explorer but within Microsoft Edge. Please follow below steps as a workaround.

To enable IE mode on Edge, Please follow these steps:

1. Open Microsoft Edge on Windows 10 & Click the Settings under menu button on the top-right corner.

2. Select the Settings option.

3. Click on Default browser.

4. Under the “Internet Explorer compatibility” section , Please select allow under  “Allow sites to be reloaded in Internet Explorer mode” 

5. Click the Restart button.

6. After restart , Please enter EBS URL on Edge and enter

7. Click menu button on the top-right corner & click on reload in internet explorer mode.

8. Now try to login and launch form (It should not download, instead it should launch directly)

Google Chrome:

Autolaunch of JNLP files on google chrome can't be controlled with browser options . Instead Chrome policies needs to be defined through GPO. Chrome policies are centrally managed by system administrators as Group Policy Object (GPO) using Microsoft Active Directory or Microsoft Intune. Deployment instructions supported by administrative templates (.admx).

EBS 12.2 ADOP useful Queries

 

EBS 12.2 adop queries:  

adop session status:

set pagesize 200;

set linesize 160;

col PREPARE_STATUS format a15

col node_name format a30

col APPLY_STATUS format a15

col CUTOVER_STATUS format a15

col ABORT_STATUS format a15

col STATUS format a15

select NODE_NAME,ADOP_SESSION_ID, PREPARE_STATUS , APPLY_STATUS  ,CUTOVER_STATUS , CLEANUP_STATUS , ABORT_STATUS , STATUS from AD_ADOP_SESSIONS where ADOP_SESSION_ID=66;

Note: Y denotes that the phase is done

N denotes that the phase has not been completed

X denotes that the phase is not applicable

R denotes that the phase is running (in progress)

F denotes that the phase has failed

P (is applicable only to APPLY phase) denotes at least one patch is already applied for the session id

C denotes that the status of this ADOP session has completed

cutover statuses:

cutover_status='Y' 'COMPLETED'

cutover_status not in ('N','Y','X') and status='F' 'FAILED'

cutover_status='0' 'CUTOVER STARTED'

cutover_status='1' 'SERVICES SHUTDOWN COMPLETED'

cutover_status='3' 'DB CUTOVER COMPLETED'

cutover_status='D' 'FLIP SNAPSHOTS COMPLETED'

cutover_status='4' 'FS CUTOVER COMPLETED'

cutover_status='5' 'ADMIN STARTUP COMPLETED'

cutover_status='6' 'SERVICES STARTUP COMPLETED'

cutover_status='N' 'NOT STARTED'

cutover_status='X' 'NOT APPLICABLE'

fs_clone status:

set linesize 300

col node_name format a15

col clone_status format a20

col driver_file_name format a20

col clone_status format a20

select node_name,clone_status,driver_file_name,status,to_char(start_date,'DD-MON-YYYY HH:MI:SS PM'),to_char(end_date,'DD-MON-YYYY HH:MI:SS PM') from ad_adop_session_patches where adop_session_id=89;

To find the patches applied in the particular adop session:

select distinct BUG_NUMBER from AD_ADOP_SESSION_PATCHES  where adop_session_id='&session_id';

set linesize 300;

select distinct bug_number,node_name,to_char(start_date ,'DD-MON-YYYY HH24:MI:SS') START_DATE,to_char(end_date,'DD-MON-YYYY HH24:MI:SS')END_DATE from ad_adop_session_patches where adop_session_id=67 group by bug_number,node_name,start_date,end_date order by bug_number;

select distinct bug_number,node_name,to_char(start_date ,'DD-MON-YYYY HH24:MI:SS') START_DATE,to_char(end_date,'DD-MON-YYYY HH24:MI:SS')END_DATE from ad_adop_session_patches where adop_session_id=&session_id  and bug_number='&bug_number' group by bug_number,node_name,start_date,end_date order by bug_number;

AD,TXK VERSIONS:

SELECT abbreviation, codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad');

ETCC QUERIES:

set linesize 300;

col node_name format a10;

col database_name format a10;

col check_message format a50;

select database_name,node_name ,check_date ,component_name,component_version,check_message from apps.TXK_TCC_RESULTS where database_name='&DB_NAME';

How to open discoverer plus in Microsoft Edge Browser

We all know oracle discoverer is already out of support from June 2014 onwards and It worked in the Internet explorer ,older versions of  Mozilla & Edge .  Internet Explorer is only a few months away from retirement & will be officially retired on June 15, 2022 .IE will fall out of support for multiple versions of Windows 10 & using the old version of browsers would not be secure. We can use the below workaround to access discoverer on Edge.

Solution:

IE mode in Edge allows organizations to continue to use legacy elements of Internet Explorer but within Microsoft Edge. Please follow below steps as a workaround.

Enable IE mode on Microsoft Edge (One Time Setup)

To enable IE mode on Edge, Please follow these steps:

1. Open Microsoft Edge on Windows 10 & Click the Settings under menu button on the top-right corner.
2. Select the Settings option.
3. Click on Default browser.
4. Under the “Internet Explorer compatibility” section , Please select allow under  “Allow sites to be reloaded in Internet Explorer mode” 
5. Click the Restart button.

Access Discoverer using Edge

1. After restart, Please enter the discoverer URL.
2. Click menu button on the top-right corner & click on "Reload in internet explorer mode"
3. Login using normal procedure & it should open forms now.

Note: Instead of selecting “Reload in Internet explorer mode" every time, we can add the site to  automatically launch  for 30 days. But after 30 days, we have to re-add it which would be difficult to educate to all the users. so instead of auto launch for 30 days, it is better to "Reload in internet explorer mode" every time.