Logo Background

Oracle Applications Management Query

  • By on September 17, 2008 | Comments Off on Oracle 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;
    Previous
    Next
    » Unix Zip Command Recursive