Display HRMS View data in Toad

Display data form HRMS Views form Toad.



INSERT INTO FND_SESSIONS VALUES (USERENV ('SESSIONID'), SYSDATE);

Generate DDL Script (A Faster way)


SELECT dbms_metadata.get_ddl(Object_type,object_name,OWNER)
FROM all_objects
WHERE object_name LIKE 'XX%'
AND Object_type IN ( 'TABLE' ,'PACKAGE' , 'PROCEDURE' ,'FUNCTION' ,'SEQUENCE' ,'DIRECTORY' ,'TRIGGER' )
Order by Object_type

Restart Inactive Concurrent Manager (Concurrent Program Phase is "Inactive" and Status is "No Manager")

To re-start concurrent manager if Concurrent Program Phase is "Inactive" and Status is "No Manager"

Set the APPS Environment

Check the Status:

$adcmctl.sh status apps/<apps password>

To Stop:

adcmctl.sh stop apps/<apps password>

To start:

adcmctl.sh start apps/<apps password>