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',
'AP_PREPAY_APP_DISTS',
'AP_PREPAY_HISTORY_ALL',
'AP_CHECKS_ALL',
'AP_PAYMENT_HISTORY_ALL',
'AP_PAYMENT_HISTORY_ALL',
'AP_PAYMENT_SCHEDULES_ALL',
'CE_BANK_ACCT_USES',
'CE_STATEMENT_HEADERS_INT',
'CE_STATEMENT_LINES_INTERFACE',
'CE_STATEMENT_HEADERS',
'CE_STATEMENT_LINES',
'XLA_AE_HEADERS',
'XLA_AE_LINES',
'XLA_TRANSACTION_ENTITIES',
'GL_JE_HEADERS',
'GL_JE_LINES',
'GL_JE_BATCHES',
'GL_IMPORT_REFERENCES',
'GL_INTERFACE',
'FA_DEPRN_PERIODS',
'FA_DEPRN_DETAIL',
'FA_DEPRN_PERIODS',
'FA_ASSET_INVOICES',
'FA_TRANSACTION_HEADERS',
'FA_RETIREMENTS',
'FA_DEPRN_SUMMARY',
'FA_ADDITIONS_B',
'FA_ADDITIONS_TL',
'FA_ASSET_KEYWORDS',
'FA_BOOKS_V',
'FA_DISTRIBUTION_HISTORY',
'FA_DISTRIBUTION_ACCOUNTS',
'FA_LOCATIONS',
'FA_CATEGORIES_B',
'FA_CATEGORY_BOOKS',
'FA_ADDITIONS_B',
'FA_ASSET_DISTRIBUTION_V',
'FA_ASSET_HISTORY',
'FA_MASS_ADDITIONS',
'FA_MASSADD_DISTRIBUTIONS',
'JAI_AP_MATCH_INV_TAXES',
'JAI_AP_TDS_INV_CANCELS',
'JAI_AP_TDS_INVOICES',
'JAI_AP_TDS_INV_PAYMENTS',
'JAI_AP_TDS_PREPAYMENTS',
'JAI_AP_TDS_THHOLD_TRXS',
'JAI_CMN_BOE_DTLS',
'JAI_CMN_BOE_HDRS',
'JAI_CMN_DOCUMENT_TAXES',
'JA.JAI_AP_INVOICE_LINES',
'JAI_RGM_TRX_RECORDS',
'JAI_RGM_TRX_REFS',
'JAI_FA_AST_BLOCK_DTLS',
'JAI_FA_AST_BLOCKS',
'RA_INTERFACE_LINES_ALL,',
'RA_INTERFACE_DISTRIBUTIONS_ALL',
'RA_INTERFACE_SALESCREDITS_ALL,',
'RA_INTERFACE_ERRORS_ALL',
'RA_CUSTOMER_TRX_ALL,',
'RA_CUSTOMER_TRX_LINES_ALL,',
'RA_CUST_TRX_LINE_GL_DIST_ALL,',
'RA_CUST_TRX_LINE_SALESREPS_ALL,',
'AR_CASH_RECEIPTS_ALL,',
'AR_RECEIVABLE_APPLICATIONS_ALL,',
'AR_PAYMENT_SCHEDULES_ALL,',
'AR_CASH_RECEIPT_HISTORY_ALL,',
'AR_ADJUSTMENTS_ALL')
MINUS
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',
'AP_PREPAY_APP_DISTS',
'AP_PREPAY_HISTORY_ALL',
'AP_CHECKS_ALL',
'AP_PAYMENT_HISTORY_ALL',
'AP_PAYMENT_HISTORY_ALL',
'AP_PAYMENT_SCHEDULES_ALL',
'CE_BANK_ACCT_USES',
'CE_STATEMENT_HEADERS_INT',
'CE_STATEMENT_LINES_INTERFACE',
'CE_STATEMENT_HEADERS',
'CE_STATEMENT_LINES',
'XLA_AE_HEADERS',
'XLA_AE_LINES',
'XLA_TRANSACTION_ENTITIES',
'GL_JE_HEADERS',
'GL_JE_LINES',
'GL_JE_BATCHES',
'GL_IMPORT_REFERENCES',
'GL_INTERFACE',
'FA_DEPRN_PERIODS',
'FA_DEPRN_DETAIL',
'FA_DEPRN_PERIODS',
'FA_ASSET_INVOICES',
'FA_TRANSACTION_HEADERS',
'FA_RETIREMENTS',
'FA_DEPRN_SUMMARY',
'FA_ADDITIONS_B',
'FA_ADDITIONS_TL',
'FA_ASSET_KEYWORDS',
'FA_BOOKS_V',
'FA_DISTRIBUTION_HISTORY',
'FA_DISTRIBUTION_ACCOUNTS',
'FA_LOCATIONS',
'FA_CATEGORIES_B',
'FA_CATEGORY_BOOKS',
'FA_ADDITIONS_B',
'FA_ASSET_DISTRIBUTION_V',
'FA_ASSET_HISTORY',
'FA_MASS_ADDITIONS',
'FA_MASSADD_DISTRIBUTIONS',
'JAI_AP_MATCH_INV_TAXES',
'JAI_AP_TDS_INV_CANCELS',
'JAI_AP_TDS_INVOICES',
'JAI_AP_TDS_INV_PAYMENTS',
'JAI_AP_TDS_PREPAYMENTS',
'JAI_AP_TDS_THHOLD_TRXS',
'JAI_CMN_BOE_DTLS',
'JAI_CMN_BOE_HDRS',
'JAI_CMN_DOCUMENT_TAXES',
'JA.JAI_AP_INVOICE_LINES',
'JAI_RGM_TRX_RECORDS',
'JAI_RGM_TRX_REFS',
'JAI_FA_AST_BLOCK_DTLS',
'JAI_FA_AST_BLOCKS',
'RA_INTERFACE_LINES_ALL,',
'RA_INTERFACE_DISTRIBUTIONS_ALL',
'RA_INTERFACE_SALESCREDITS_ALL,',
'RA_INTERFACE_ERRORS_ALL',
'RA_CUSTOMER_TRX_ALL,',
'RA_CUSTOMER_TRX_LINES_ALL,',
'RA_CUST_TRX_LINE_GL_DIST_ALL,',
'RA_CUST_TRX_LINE_SALESREPS_ALL,',
'AR_CASH_RECEIPTS_ALL,',
'AR_RECEIVABLE_APPLICATIONS_ALL,',
'AR_PAYMENT_SCHEDULES_ALL,',
'AR_CASH_RECEIPT_HISTORY_ALL,',
'AR_ADJUSTMENTS_ALL');Inspects any index is modified during applied patches on instance
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',
'AP_PREPAY_APP_DISTS',
'AP_PREPAY_HISTORY_ALL',
'AP_CHECKS_ALL',
'AP_PAYMENT_HISTORY_ALL',
'AP_PAYMENT_HISTORY_ALL',
'AP_PAYMENT_SCHEDULES_ALL',
'CE_BANK_ACCT_USES',
'CE_STATEMENT_HEADERS_INT',
'CE_STATEMENT_LINES_INTERFACE',
'CE_STATEMENT_HEADERS',
'CE_STATEMENT_LINES',
'XLA_AE_HEADERS',
'XLA_AE_LINES',
'XLA_TRANSACTION_ENTITIES',
'GL_JE_HEADERS',
'GL_JE_LINES',
'GL_JE_BATCHES',
'GL_IMPORT_REFERENCES',
'GL_INTERFACE',
'FA_DEPRN_PERIODS',
'FA_DEPRN_DETAIL',
'FA_DEPRN_PERIODS',
'FA_ASSET_INVOICES',
'FA_TRANSACTION_HEADERS',
'FA_RETIREMENTS',
'FA_DEPRN_SUMMARY',
'FA_ADDITIONS_B',
'FA_ADDITIONS_TL',
'FA_ASSET_KEYWORDS',
'FA_BOOKS_V',
'FA_DISTRIBUTION_HISTORY',
'FA_DISTRIBUTION_ACCOUNTS',
'FA_LOCATIONS',
'FA_CATEGORIES_B',
'FA_CATEGORY_BOOKS',
'FA_ADDITIONS_B',
'FA_ASSET_DISTRIBUTION_V',
'FA_ASSET_HISTORY',
'FA_MASS_ADDITIONS',
'FA_MASSADD_DISTRIBUTIONS',
'JAI_AP_MATCH_INV_TAXES',
'JAI_AP_TDS_INV_CANCELS',
'JAI_AP_TDS_INVOICES',
'JAI_AP_TDS_INV_PAYMENTS',
'JAI_AP_TDS_PREPAYMENTS',
'JAI_AP_TDS_THHOLD_TRXS',
'JAI_CMN_BOE_DTLS',
'JAI_CMN_BOE_HDRS',
'JAI_CMN_DOCUMENT_TAXES',
'JA.JAI_AP_INVOICE_LINES',
'JAI_RGM_TRX_RECORDS',
'JAI_RGM_TRX_REFS',
'JAI_FA_AST_BLOCK_DTLS',
'JAI_FA_AST_BLOCKS',
'RA_INTERFACE_LINES_ALL,',
'RA_INTERFACE_DISTRIBUTIONS_ALL',
'RA_INTERFACE_SALESCREDITS_ALL,',
'RA_INTERFACE_ERRORS_ALL',
'RA_CUSTOMER_TRX_ALL,',
'RA_CUSTOMER_TRX_LINES_ALL,',
'RA_CUST_TRX_LINE_GL_DIST_ALL,',
'RA_CUST_TRX_LINE_SALESREPS_ALL,',
'AR_CASH_RECEIPTS_ALL,',
'AR_RECEIVABLE_APPLICATIONS_ALL,',
'AR_PAYMENT_SCHEDULES_ALL,',
'AR_CASH_RECEIPT_HISTORY_ALL,',
'AR_ADJUSTMENTS_ALL')
MINUS
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',
'AP_PREPAY_APP_DISTS',
'AP_PREPAY_HISTORY_ALL',
'AP_CHECKS_ALL',
'AP_PAYMENT_HISTORY_ALL',
'AP_PAYMENT_HISTORY_ALL',
'AP_PAYMENT_SCHEDULES_ALL',
'CE_BANK_ACCT_USES',
'CE_STATEMENT_HEADERS_INT',
'CE_STATEMENT_LINES_INTERFACE',
'CE_STATEMENT_HEADERS',
'CE_STATEMENT_LINES',
'XLA_AE_HEADERS',
'XLA_AE_LINES',
'XLA_TRANSACTION_ENTITIES',
'GL_JE_HEADERS',
'GL_JE_LINES',
'GL_JE_BATCHES',
'GL_IMPORT_REFERENCES',
'GL_INTERFACE',
'FA_DEPRN_PERIODS',
'FA_DEPRN_DETAIL',
'FA_DEPRN_PERIODS',
'FA_ASSET_INVOICES',
'FA_TRANSACTION_HEADERS',
'FA_RETIREMENTS',
'FA_DEPRN_SUMMARY',
'FA_ADDITIONS_B',
'FA_ADDITIONS_TL',
'FA_ASSET_KEYWORDS',
'FA_BOOKS_V',
'FA_DISTRIBUTION_HISTORY',
'FA_DISTRIBUTION_ACCOUNTS',
'FA_LOCATIONS',
'FA_CATEGORIES_B',
'FA_CATEGORY_BOOKS',
'FA_ADDITIONS_B',
'FA_ASSET_DISTRIBUTION_V',
'FA_ASSET_HISTORY',
'FA_MASS_ADDITIONS',
'FA_MASSADD_DISTRIBUTIONS',
'JAI_AP_MATCH_INV_TAXES',
'JAI_AP_TDS_INV_CANCELS',
'JAI_AP_TDS_INVOICES',
'JAI_AP_TDS_INV_PAYMENTS',
'JAI_AP_TDS_PREPAYMENTS',
'JAI_AP_TDS_THHOLD_TRXS',
'JAI_CMN_BOE_DTLS',
'JAI_CMN_BOE_HDRS',
'JAI_CMN_DOCUMENT_TAXES',
'JA.JAI_AP_INVOICE_LINES',
'JAI_RGM_TRX_RECORDS',
'JAI_RGM_TRX_REFS',
'JAI_FA_AST_BLOCK_DTLS',
'JAI_FA_AST_BLOCKS',
'RA_INTERFACE_LINES_ALL,',
'RA_INTERFACE_DISTRIBUTIONS_ALL',
'RA_INTERFACE_SALESCREDITS_ALL,',
'RA_INTERFACE_ERRORS_ALL',
'RA_CUSTOMER_TRX_ALL,',
'RA_CUSTOMER_TRX_LINES_ALL,',
'RA_CUST_TRX_LINE_GL_DIST_ALL,',
'RA_CUST_TRX_LINE_SALESREPS_ALL,',
'AR_CASH_RECEIPTS_ALL,',
'AR_RECEIVABLE_APPLICATIONS_ALL,',
'AR_PAYMENT_SCHEDULES_ALL,',
'AR_CASH_RECEIPT_HISTORY_ALL,',
'AR_ADJUSTMENTS_ALL');