prashanthapps.blogspot.com

oracle-appss.blogspot.com

Oracle Flashback Query: Recovering at the Row Level (Recover deleted rows) | Home

http://oracle-appss.blogspot.com/2011/09/oracle-flashback-query-recovering-at.html

Friday, September 16. Oracle Flashback Query: Recovering at the Row Level (Recover deleted rows). In a data recovery context, it is useful to be able to query the state of a table at a previous time. If, for instance, you discover that at 12:30 PM, an employee. Had been deleted from your. Querying the past state of the table is achieved using the. Statement. For example, the following query retrieves the state of the employee record for '. At 9:30AM, April 4, 2003:. SELECT * FROM EMPLOYEE AS OF TIMESTAMP.

oracle-appss.blogspot.com

Get all the views that refer a particular table : | Home

http://oracle-appss.blogspot.com/2011/09/get-all-views-that-refer-particular.html

Saturday, September 10. Get all the views that refer a particular table :. SELECT o.object name, o.status, o.last ddl time. FROM SYS.dba objects o. WHERE o.object type = 'VIEW'. FROM SYS.dba dependencies d. WHERE d.referenced type = 'TABLE'. AND dTYPE = 'VIEW'. AND downer = 'APPS'. AND dNAME = o.object name. AND dreferenced name LIKE ' TABLE NAME ');. Posted by Jithendra Kumar B. Subscribe to: Post Comments (Atom). Total no of Hits on my blog (As per date -Sep30 ). Usage of :$FLEX$ in oracle apps. Workin...

oracle-appss.blogspot.com

List of all active workflow users and their roles | Home

http://oracle-appss.blogspot.com/2011/09/list-of-all-active-workflow-users-and.html

Saturday, September 10. List of all active workflow users and their roles. Select wu.name user name,. From wf users wu,. Wf user roles wur,. Where wu.name = wur.user name. And wur.role name = wr.name. And wu.status = 'ACTIVE'. And wr.status = 'ACTIVE'. And wr.orig system = 'WF LOCAL ROLES'. Order by wu.name,. Posted by Jithendra Kumar B. Subscribe to: Post Comments (Atom). Total no of Hits on my blog (As per date -Sep30 ). Usage of :$FLEX$ in oracle apps. Oracle Apps Shortcut Keys. Working with Trace fil...

oracle-appss.blogspot.com

Query to find the user, responsibility and concurrent program details of submitted requests | Home

http://oracle-appss.blogspot.com/2011/08/query-to-find-user-responsibility-and.html

Friday, August 26. Query to find the user, responsibility and concurrent program details of submitted requests. Select B.user concurrent program name,C.user name,D.responsibility name, A.*. From apps.fnd concurrent requests A, apps.fnd concurrent programs tl B, Apps.fnd user C, apps.fnd responsibility tl D. And Buser concurrent program name like. Enter the concurrent program name '. And Bconcurrent program id=A.concurrent program id. And Arequested by=C.user id. Order by request date desc. Find Vacation ...

oracle-appss.blogspot.com

Check Current Applied Patch & Patch level status of all modules | Home

http://oracle-appss.blogspot.com/2011/09/check-current-applied-patch.html

Saturday, September 10. Check Current Applied Patch and Patch level status of all modules. Check Current Applied Patch. SELECT patch name, patch type,. Maint pack level,. FROM applsys.ad applied patches. ORDER BY creation date DESC. Query used to view the patch level status of all modules. SELECT a.application name,. DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,. FROM apps.fnd application vl a,. Appsfnd product installations b. WHERE a.application id = b.application id;. Script to dis...

oracle-appss.blogspot.com

XML Template code and template name | Home

http://oracle-appss.blogspot.com/2011/08/xdotemplates.html

Friday, August 26. XML Template code and template name. We can get Lob Code from this query to get the details of RTF files. Query with lob code in the application in case if we don't know the template name. Select * from XDO LOBS. Where file name like '%po terms%'. And XDO File type='RTF'. And trunc(last update date)=trunc(sysdate). Posted by Jithendra Kumar B. Subscribe to: Post Comments (Atom). Making field as mandatory using Forms Personalizat. How to get Login Passwords for application and Data .

oracle-appss.blogspot.com

sql / plsql | Home

http://oracle-appss.blogspot.com/p/sql-basic.html

This page covers on basic Sql and Plsql queries. Simple sub-queries and with Group functions. General Functions and Types. Conversion Functions in Oracle and Types. Number Functions in Oracle. Date Functions in Oracle. Arthemetic Functions In Oracle. Analytical functions, LISTAGG and XMLAGG. How to submit a concurrent program from pl sql. How to Register a Concurrent Program with a Responsibility. Script to asign Concurrent Program to a Request group. Script to set org context in Oracle apps R12 and 11i.

oracle-appss.blogspot.com

Get the complete history of concurrent program. | Home

http://oracle-appss.blogspot.com/2011/09/get-complete-history-of-concurrent.html

Saturday, September 10. Get the complete history of concurrent program. SELECT DISTINCT fcpt.user concurrent program name,. Frgrequest group name,. Fcpconcurrent program name,. Uncommment the above to get the list of responsibility's. FaAPPLICATION SHORT NAME,. FROM fnd request group units frgu,. Fnd concurrent programs fcp,. Fnd concurrent programs tl fcpt,. Fnd request groups frg,. Fnd executables fe,. Fnd responsibility fr,. Fnd responsibility tl frt,. Fnd application tl fat,. WHERE 1 = 1. How to Regi...

oracle-appss.blogspot.com

How to use regexp_substr | Home

http://oracle-appss.blogspot.com/2011/10/how-to-use-regexpsubstr.html

Friday, October 14. How to use regexp substr. Regexp substr cabe used to transpose the column values as rows. In the below example PRODUCT TAB is a table ename and product are columns. Product column has data like that only separated by commas. Output should be like this. If you want the above desired output please use the below solution. SELECT DISTINCT EMP,regexp substr (product, '[ ,] ', 1, level). CONNECT BY LEVEL = LENGTH (REGEXP REPLACE (product, '[ ,] ') 1. ORDER BY 1;. Posted by Jithendra Kumar B.

oracle-appss.blogspot.com

Script to display status of all the Concurrent Managers | Home

http://oracle-appss.blogspot.com/2011/09/script-to-display-status-of-all.html

Saturday, September 10. Script to display status of all the Concurrent Managers. Select distinct Concurrent Process Id CpId, PID Opid,. Os Process ID Osid,. QConcurrent Queue Name Manager,. Pprocess status code Status,. To Char(P.Process Start Date, 'MM-DD-YYYY HH:MI:SSAM') Started At. From Fnd Concurrent Processes P,. Fnd Concurrent Queues Q,. Where Q.Application Id = Queue Application ID. And QConcurrent Queue ID = P.Concurrent Queue ID. And Spid = Os Process ID. And Process Status Code not in ('K','S').