9 Replies Latest reply on Sep 20, 2018 1:58 AM by Beauty_and_dBest

    Section 2-2 Oracle E-Business Suite Upgrade Guide


      EBS 12.0.6 upgrade to 12.2.6 or 12.2.7

      12c database


      Oracle® E-Business Suite

      Upgrade Guide

      Release 12.0 and 12.1 to 12.2

      Part No. E48839-16

      September 2017


      Hi ALL,


      In section 2-2 of above docs , it mentioned:


      Drop event alert triggers in custom schemas (conditional):

      To drop all event alert database triggers in custom schemas, run the alrdtrig.sql script,

      located in $ALR_TOP/patch/115/sql. Re-create the triggers after the upgrade is



      Where schema do I login to run this program alrdtrig.sql? Is it SYSTEM, SYS, or APPS?


      Is it not possible that the developer created a custom trigger in APPS schema, and not in a "certain" custom schema?

      How do I know if an schema is a custom schema if there is no proper documentation? or documentations are gone?

      Can oracle script not able to identify which?



      For example below I run the program in a "certain" schema I just suspect as custom.


      [applmgr@oraapps-2 sql]$ sqlplus apps/apps


      SQL*Plus: Release - Production on Tue Sep 18 20:01:20 2018


      Copyright (c) 1982, 2005, Oracle.  All rights reserved.



      Connected to:

      Oracle Database 12c Enterprise Edition Release - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt                              ions


      SQL> @alrdtrig.sql

      Enter username for custom schema.

      Username: iports

      Enter password for custom schema.

      Password: iports



      Rerun alrdtrig.sql, which is located in the preupg subdirectory of the

      admin directory under APPL_TOP, for each custom schema.


      If alrdtrig.sql has been run for all custom schemas, then open

      each [schema].sql (created by this script), which can be found in the

      current directory, and manually delete the drop trigger statements

      which do not belong.

      Then run the following statement for each schema:

      sqlplus apps_username/password @[schema].sql



      The above instruction is so confusing

      Can you explain please....



      Kind regards,