Oracle Applications Management QueryOracle Applications Management Query
How to check whether we have patch X applied in Oracle Applications 11i or R12? Use the SQL below for the checking: -
SQL> SELECT * FROM apps.ad_bugs WHERE BUG_NUMBER IN ('1238573', '1313962');
And how about you want to analyze which forms and reports impacted by the patch when knowing there’s change on the database object? Use the UNIX command below for the checking: -
UNIX> cd $AP_TOP/forms/US UNIX> grep -i AP_INVOICES_ALL * UNIX> cd $AP_TOP/reports/US UNIX> grep -i AP_INVOICES_ALL *
Once you have the forms and reports executable on hand, you may find their executable name using the SQL below: -
Forms Name -
SQL> SELECT a.form_name||' - '||nvl(b.description, b.user_form_name) FROM APPS.FND_FORM a, APPS.FND_FORM_TL b WHERE a.form_id = b.form_id AND a.form_name IN ('IGIPAPPR');
Reports Name -
SQL> SELECT b.executable_name||' - '||c.description FROM APPS.FND_CONCURRENT_PROGRAMS a, APPS.FND_EXECUTABLES b, APPS.FND_CONCURRENT_PROGRAMS_TL c WHERE a.executable_id = b.executable_id AND a.concurrent_program_id = c.concurrent_program_id AND b.execution_file_name IN ('APXTRSWP');
You may check what is the database objects that use the objects and files which was changed by the patch using the SQL below: -
SQL> SELECT DISTINCT type||' - '||name FROM DBA_DEPENDENCIES WHERE referenced_name IN ('AP_INVOICE_DISTRIBUTIONS_V','AP_VENDOR_SITES_PKG', 'AP_APPROVAL_MATCHED_PKG' ,'AP_APPROVAL_MATCHED_PKG', 'AP_FUNDS_CONTROL_PKG' ,'AP_PREPAY_PKG', 'AP_RECT_MATCH_PKG' ,'AP_MATCHING_PKG', 'AP_INVOICES_PKG' ,'AP_INVOICE_DISTRIBUTIONS_PKG', 'AP_IMPORT_INVOICES_PKG' ,'AP_CHECKS_PKG', 'AP_CANCEL_PKG' ,'AP_CUSTOM_INV_VALIDATION_PKG', 'AP_PAY_IN_FULL_PKG' ,'AP_CUSTOM_INV_VALIDATION_PKG', 'AP_APPROVAL_PKG' ,'AP_AMT_RECT_MATCH_PKG', 'AP_AC_TABLE_HANDLER_PKG') ORDER BY type||' - '||name;
Recent Comments