My Oracle Support Banner

Install MRC, Run Script Advrfmrc.sql. Output Says Certain Triggers Are Missing In Your APPS Schema (Doc ID 272269.1)

Last updated on AUGUST 27, 2019

Applies to:

Oracle Receivables - Version 11.5.9 to 11.5.10.2 [Release 11.5.9 to 11.5.10]
Oracle Payables - Version 11.5.3 to 11.5.10.2 [Release 11.5]
Oracle Assets - Version 11.5.3 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

After installing MRC and executing the validator program, you find several triggers missing in the environment among other objects.

You find the following in the output of the script advrfmrc.sql

The following triggers are missing in your APPS schema:

ap_mrc_checks_biud
ap_mrc_invoice_dists_biud
ap_mrc_invoices_biud
ap_mrc_invoice_payments_bid
ap_mrc_payment_history_biud
ra_mrc_trx_line_gl_dist_biud
ar_mrc_distributions_biud
ar_mrc_receivable_apps_biud
fa_mc_adjustments_aiud
fa_mc_asset_invoices_aid
fa_mc_book_controls_ad
fa_mc_books_aiud

fa_mc_deprn_detail_aiud
fa_mc_deprn_periods_ad
fa_mc_deprn_summary_aiud
fa_mc_mass_additions_aiud
fa_mc_retirements_aiud
fa_mc_transaction_headers_ai

Changes

 You may encounter this on upgrading to 11.5.8 or higher.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.