Once applied the patch DBA can examine if any table is modified with the column name. SELECT table_name, column_name FROM dba_tab_columns WHERE table_name IN ('AP_INVOICES_INTERFACE', 'AP_INVOICE_LINES_INTERFACE', 'AP_INVOICES_ALL', 'AP_INVOICE_DISTRIBUTIONS_ALL', 'AP_INVOICE_LINES_ALL', 'AP_INVOICE_PAYMENTS_ALL',...

Find out value of profile option at any level from backend.  User have to enter the name of profile during the execution of script. SELECT b.user_profile_option_name "Long Name", a.profile_option_name "Short...

DBA can investigation which objects are invalid and they can take necessary action for those object. Number of objects are invalid by object types SELECT object_type, COUNT ( * )...

Check file version in application through sql script & linux/sun os command. Enter file name in below script which provide file version with location. SELECT af.app_short_name "Application", af.filename "File Name",...