Tag Archives: Apps Useful script

Top 10 Useful oracle apps queries for DBA

Last updated on August 24th, 2016 at 06:27 pmOracle apps DBA has to often trouble shoot various issues. I am giving here Top 10 Useful oracle apps queries for DBA To find forms sesssion in database set linesize 1000 column username format a8 heading “User|Name” column sid format 9999 column serial# format 99999 column user_form_name format a25 column spid format a5 column unix_process format a7 … Continue reading Top 10 Useful oracle apps queries for DBA »

Awesome Useful Oracle Apps script to debug it

Last updated on September 14th, 2016 at 09:10 pmYou will need many scripts while troubleshooting,extracting data from Oracle E-business suite.Here I am giving very Useful Oracle Apps  script/code.   Script to find out patches applied select orig_bug_number,to_char(max(last_update_date),’DD-MON-YYYY hh24:mi:ss’) updated from ad_patch_run_bugs where orig_bug_number in ( select distinct app_patch.patch_name from ( select substr(ap.patch_name,1,10) patch_name from ad_patch_runs pr, ad_patch_drivers dr, ad_applied_patches ap where pr.start_date between to_date(‘&&1′,’MM/DD/YYYY’) and to_date(‘&&2′,’MM/DD/YYYY’) and … Continue reading Awesome Useful Oracle Apps script to debug it »