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: Hi Miki, How about the result if you change the data type of the image column to BLOB data type? Thanks, Edi
- Miki: Edi, All images are 900 x 1200 and have size about 100K. When I insert those images in table with READ_IMAGE_FILE(path, ‘JPG’, ‘PER_IMAG
- Edi Yanto: Hi Miki, Yes, I was suspicious the size of those images are the main problem.. over 3MB? it's about 2048 x 1536, so high resolution... You must conve
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)
- Enrcypted Document Ownership: Whose File is it Anyway?
- Oracle iReceipts - the First Apple iPhone Application for PeopleSoft Expenses!
- "Inside the soa manifesto" - podcast
- New OTN Whitepaper on Using 11.1.1.2 UI Shell
- 情報を盗む、ということ④
- Sizing an RTD installation - Part 1
- EA Bashing?!? Open Season on EA’s??? Who is at Fault? (Or should the question be how do we fix it?)
- Rethinking Information Architecture for the New World (Part 3)
- OSB 10gR3 High Availability
- HOPE Meeting
Online Apps DBA
- Oracle Service Bus 10.3.1 Installation
- Unable to call fnd_ldap_wrapper . create_user / update_user ORA-20001
- Custom Schemas are not analyzed when Gather Schema Statistics are submitted.
- How to create FMW 11g schemas (SOA, WebCenter) on Solaris (non Windows/Linux) platform ?
- oraInventory Location & oraInst.loc on Windows , Linux , Unix
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?