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

ORA-04088: error during execution of custom trigger

Avatar photoCustomer Questions & Answers 5 replies

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.

5 replies

  • Support Enginatics

    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

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

  • Support Enginatics

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

  • Avatar photoCustomer

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

  • Support Enginatics

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

  • You must be logged in to reply to this post.