Skip to main content
Question

How cancel a Subscription?

  • November 19, 2025
  • 2 replies
  • 32 views
C
Do Gooder (Partner)
Forum|alt.badge.img+6

Hi all.

 

I have a problem trying to unsubscribe of a Subscription (when a field is updated)

The version is:

Application service update: 24.1.1

Framework service update: 24.1.9

IFS Cloud Web version: 24.1.9.20250205094114.0

IFS OData provider version: 24.1.9.20250205063243.0

 

The steps:

  1. I edit the subscription.

 

  1. Then I click on Unsubscribe:

 

  1. And an error is displayed

 

The text is:

<<IFS Web Version: 24.1.9.20250205094114.0
Date: 2025-11-19T16:21:40.487Z

---------------------------------------------------------------------------

StreamSubscriptions/SubscriptionDialog@1 (server error)
Database error occurred. Contact administrator.
Error details: [{"code":4091,"message":"ORA-04091: table IFSAPP.FND_OBJ_SUBSCRIPTION_TAB is mutating, trigger/function may not see it"}]

Request Id: 7942b494-4c4f-4f04-8e2a-204add748161
Url: https://redeia.nbit.com.es/main/ifsapplications/projection/v1/StreamSubscriptions.svc/RemoveSubscription

--------------------------------------------------------------------------->>

 

Any idea??

 

Best regards

 

Sergio

 

 

    2 replies

    Tharindu Sooriyaarachchi
    Hero (Employee)
    Forum|alt.badge.img+7

    Hi ​@CedSergiG ,

     

    In general, the error 'ORA-04091: table IFSAPP.FND_OBJ_SUBSCRIPTION_TAB is mutating, trigger/function may not see it' occurs for the following reason:

     

    A trigger (or a user-defined PL/SQL function referenced within the statement) attempted to query or modify a table that was already in the middle of being modified by the statement that fired the trigger.

     

    As per the IFS Documentation, when a user subscribes to any row/object in a logical unit, a trigger is created (if not already created) on the base table of the logical unit. Only two triggers are created per logical unit no matter the number of users or objects subscribed in it. One trigger to capture when rows are updated identified by <LU_NAME>_TRK_U and another to to capture deleted rows identified by <LU_NAME>_TRK_D . 

     

    Can you check if you have any active subscriptions for the logical unit FndObjSubscription? You can verify this in the Object Subscription Overview window. If any exist, could you please clarify the business purpose for having them?

     

    Also, could you check whether the two triggers listed below exist in the database? It is possible that these triggers are what is preventing modifications to the table.

    FND_OBJ_SUBSCRIPTION_TRK_D

    FND_OBJ_SUBSCRIPTION_TRK_U



    Best Regards,
    Tharindu

    https://www.linkedin.com/in/tharindu-sooriyaarachchi-2239b2142/
    C
    Do Gooder (Partner)
    Forum|alt.badge.img+6
    • CedSergiG
    • Author
    • Do Gooder (Partner)
    • January 19, 2026

    Hi ​@Tharindu Sooriyaarachchi 

     

    I don’t have any subscription for unit FndObjSubscription as you can see in the screenshot:

     

    I still have the issue.

     

     

     

     

    Terms & ConditionsCookie settingsAccessibility statement