Home Discussions Questions & Answers ORA-04088: error during execution of custom trigger

ORA-04088: error during execution of custom trigger

Avatar photoCustomer August 27, 2022 at 1:33 am

The installation log shows ORA-04088: error during execution of trigger ‘APPS.NOTE_1342126_1_AUDIT_TRIG’ because FND_LOBS_S.CURRVAL is not yet defined in this session.

Viewing 4 reply threads
  • Author
    Replies
    • Support August 27, 2022 at 9:29 am  

      This indicates that a custom audit trigger (likely created following Oracle note 1342126.1) is prematurely referencing a sequence’s current value (CURRVAL), causing a conflict during package execution.

    • Avatar photoCustomer August 27, 2022 at 4:07 pm  

      What is the safest way to proceed with the installation without losing the trigger if it’s still needed?

    • Support August 28, 2022 at 4:24 am  

      The recommended solution is to temporarily disable the problematic custom trigger. For example: alter trigger apps.note_1342126_1_audit_trig disable;.

    • Avatar photoCustomer August 30, 2022 at 12:41 am  

      Then I rerun the installer, and re-enable it?

    • Support August 30, 2022 at 3:56 pm  

      Precisely. Rerun install.sh. Once complete, you can enable the trigger again using alter trigger apps.note_1342126_1_audit_trig enable;.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: