,

know the Instance Name of oracle apps

Following Query can be used to know the Instance Name you are working from the Backend.

SELECT UPPER(sys_context(‘USERENV’,’DB_NAME’)) “Instance”
FROM DUAL;
or
select instance_name from v$instance;

/by