How To Find A Patch Is Applied For A Bug
Posted by: Edi Yanto on: May 28, 2009
SELECT DISTINCT RPAD (ad.bug_number, 11) “Bug Number”,
RPAD (app.patch_name, 11) “Patch Name”,
RPAD (TRUNC (apr.end_date), 12) “End Date”,
RPAD (aprb.applied_flag, 4) “Applied?”
FROM ad_bugs ad,
ad_patch_run_bugs aprb,
ad_patch_runs apr,
ad_patch_drivers apd,
ad_applied_patches app
WHERE ad.bug_id = aprb.bug_id
AND aprb.patch_run_id = apr.patch_run_id
AND apr.patch_driver_id = apd.patch_driver_id
AND apd.applied_patch_id = app.applied_patch_id
AND ad.bug_number = nvl(:p_bug_number,ad.bug_number)
ORDER BY 1 DESC;
1 Response to "How To Find A Patch Is Applied For A Bug"
Leave a Reply
![[Google]]( http://www.ediyanto.co.cc/wp-content/plugins/easy-adsenser/google-light.gif)
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
RSS Syndication
- Edi Yanto: have you download the fndconc.pll at the above link (http://www.ediyanto.co.cc/wp-content/uploads/2009/07/fndconc.pll) ? Are u compile at the right
- Rahul: Hi, Very good article. Thanks for providing such great tip.
- Edi Yanto: Hi Herlambang, Untuk Internal Manager, sillahkan lakukan step dibawah ini: 1. login sebagai user oracle 2. masuk ke $APPLCSF/scripts/[SID]_[host
Edi Yanto (何万新)
- Migrate To New Domain http://ediyanto.co.cc April 21, 2009 Edi Yanto
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP April 19, 2009 Edi Yanto
- Bersyukurlah…. (4 Skenario) March 22, 2009 Edi Yanto
- David Hartanto Widjaja Tidak Bersalah! March 12, 2009 Edi Yanto
- UNIX Commands March 6, 2009 Edi Yanto
- Row Numbering With an Order By Clause March 6, 2009 Edi Yanto
- Various Backup and Restore Scripts March 6, 2009 Edi Yanto
- Activate Special Menu and Invoke Custom Form When Clicked on that Special Menu at Oracle Apps March 5, 2009 Edi Yanto
- Perempuan yang Dicintai Suamiku February 27, 2009 Edi Yanto
- Fenomena-Fenomena Alam yang Langka February 27, 2009 Edi Yanto
Blogs.oracle.com Recent Posts (all languages)
- The Oracle Australia Graduate Program 2010 is Open for Applications
- データベース・セキュリティ・コンソーシアムにて
- 最新 OFSAA5.1(Oracle Financial Services Analytical Applications) 系统
- 最新 OFSAA5.1(Oracle Financial Services Analytical Applications) 系统
- Google AppsとOracle CRM On Demandの連携が可能になります。
- Tuxedo Application Runtime (ART) Workshop - (11-12/Mar/10)
- Tri-ing Toward Victory
- How to configure Apache with Weblogic Server
- How to make two distributed web apps talk using foreign JNDI concept.
- Oracle Apex in neuem Master-Studiengang an der Hochschule Hof
Online Apps DBA
- How to integrate WebLogic with Oracle Internet Directory for Login : Authentication
- Overview of Securing Web Services in Fusion Middleware 11g (SOA / ADF / WebCenter)
- Reader’s Question : Autoconfig : What is difference between adautoconfig.sh, adautocfg.sh and adconfig.sh
- Upgrade Oracle Application Server 10g (SOA) to 10.1.3.5 - 8626084
- Oracle AIA 2.5 Installation Issues : Foundation Pack build failed - FPInstall.xml FPCheckSOAServerStatus AIAErrorTask Administration Process
Visitors
June 27, 2009 at 2:29 am
How to find the bug # ?
I mean the :p_bug_number
In RDM there are many customisation like using custom pll, custom discount type in advance pricing and many other things..example when creating SO line, when the engine want to calculate the price for an item that has a discount (Modifier) sometimes, Error messages appears like “Invalid number” / “Invalid Salesperson”, etc.. and many times, we cannot redo the error again eventough the steps are exactly the same, the frequency of the error cannot be predicted. Iman looking the metalink and found a patch for the R11.5.9 in RDM but has not been applied yet (we thought it could be an APPS bug).
But how to find a certain bug # in metalink for some case as above?