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

    Section 2-2 Oracle E-Business Suite Upgrade Guide

    Beauty_and_dBest

      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

      complete.

       

      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 10.1.0.5.0 - 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 12.1.0.2.0 - 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

      Connected.

       

      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,