APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX IR subscription stops working because next run date (APEX_APPLICATION_PAGE_IR_SUB.OFFSET_DATE) is in the past

PatrickCAug 22 2024

Sometimes an IR subscription is not triggered (eg. DB was down for maintenance on that particular date/time or it runs in an error and then the APEX_APPLICATION_PAGE_IR_SUB.OFFSET_DATE has a value in the past. From that moment in time this subscription stops working.

The only way to get it working again is to delete the subscription and create a new one.

We are on APEX 20.2 and Oracle 19c.

Is there another solution for this?

Added on Aug 22 2024

#apex20-2, #interactivereports, #subscriptions

0 comments

207 views