Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Disable EBR during 19c database upgrade?

user1165418Apr 2 2020 — edited Apr 6 2020

Hi All,

We have upgraded Oracle EBS to 12.2.7. We are now prepping to upgrade the 12.1.0.2 Enterprise Database up to 19.3.

The 19c database upgrade instructions (Doc ID 2539778.1) say “Disable any custom triggers that would get executed before / after DDL. You can enable it once upgrade is completed.”

We are using Edition Based Redefinition (EBR).  Do we simply disable all triggers on tables owned by APPS?  Than re-enable them afterwards?

Any thoughts (and references) would be appreciated.

Comments

MichaelS
Maybe this:
BEGIN
   UPDATE    doc_number
         SET doc_nbr = doc_nbr + 1
       WHERE REGISTER = pregscode AND doc_code = pdoccode
   RETURNING TO_CHAR (doc_nbr, '0000000')
        INTO vdocno;

   IF SQL%ROWCOUNT = 0
   THEN
      INSERT INTO doc_number
           VALUES (myregister,
                   mydoc_code,
                   mydoc_nbr
                  )
        RETURNING TO_CHAR (doc_nbr, '0000000')
             INTO vdocno;
   END IF;
END;
/
1 - 1

Post Details

Added on Apr 2 2020
5 comments
918 views