Use Following Script:
CLEAR COL BREAK COMPUTE
SET PAGES 100 PAUSE OFF VERIFY OFF FEEDBACK ON ECHO OFF
COL object_name FORMAT A35
COL type FORMAT A20
COL sid FORMAT 9999
COL held FORMAT A5
COL request FORMAT A7
SELECT session_id sid,
WHERE name LIKE UPPER('%&object_name%')
SET PAGES 32 PAUSE OFF VERIFY OFF FEEDBACK ON ECHO OFF
When prompts give Package name
Integrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for SPWA - Supply Planning Work Area What is Oracle ADF? Orac...
R12.2. Services Start and Stop Procedure All components - Application (Middle Tier) START $INST_TOP/admin/scripts adstrtal.s...
Enabling TLS in Oracle Apps R12.2 Here we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: ...
Apps password change routine in Release 12.2 E-Business Suite changed a little bit. We have now extra options to change password, as well ...