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;
Leave a Reply
Want to join the discussion?Feel free to contribute!