/********************************************************* *PURPOSE: To list physical path of APPL_TOPs in unix * * and its Parameters * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT variable_name, VALUE FROM… Read More »SQL Query to findout Application Tops unix physical path
Purpose of Learning Path: A learning path is a catalog object that is used to group sequence of courses together and tracked as a whole.… Read More »Learning Paths in Oracle Learning Management
/******************************************************************** *PURPOSE: To list information about Executable, Concurrent Program * * and its Parameters * *AUTHOR: Shailender Thallam * *********************************************************************/ SELECT DISTINCT fcpl.user_concurrent_program_name "Concurrent… Read More »SQL Query to findout Executable, Concurrent Program and its Parameters information
Some times we might end up in a situation to delete Data Definition and Template but interestingly oracle doesn’t provide the option to delete.. As… Read More »How to Delete XML Publisher Definition and Template
ICX_PARAMETERS table helps us to find out the application URL. SELECT home_url FROM icx_parameters;SELECT home_url FROM icx_parameters; We can also get the application URL from… Read More »To Findout Oracle Application URL from Database
SELECT e.empno, e.ename , e.deptno , d.dname FROM emp e, dept d WHERE 1 = 1 AND e.deptno=d.deptno;SELECT e.empno, e.ename , e.deptno , d.dname FROM… Read More »Backward ‘Like’ Statement
Oracle has provided an API UTL_SMTP which can be used to send email from PL/SQL. UTL_SMTP uses SMTP (Simple Mail Transfer Protocol) sever to send… Read More »UTL_SMTP API to send HTML Emails from PL/SQL
Method I : ‘ADIDENT’ utility To find out a file version, oracle have provided ‘ADIDENT’ utility (AD Identification). This is an oracle apps based utility.… Read More »How to find report/package file version in Oracle Apps
/********************************************************* *PURPOSE: To list information about the users who are * * loggedin in past 1 hour * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT DISTINCT… Read More »SQL Query to findout list of users connected to Oracle Apps Instance
Here are some of the important XMLP tables. Table Name Description XDO_CONFIG_PROPERTIES_B Stores the XML Publisher Administration configuration properties that are accessible from the OA… Read More »XDO – XMLP Important Base Tables