Skip to Main Content

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!

Automations and REST Sync Are Disabled After Import

Alexander Kluev11 hours ago

Hello team,

APEX Automations and REST Source Sync Jobs are always disabled in the target environment even when they are enabled in source and recorded as enabled in f<app_id>.sql export file.

To work around it I have to call APIs to enable them after import, i.e.:

BEGIN
    apex_rest_source_sync.enable(
    p_application_id => 116,
    p_module_static_id => 'Quotesys_Trip' );
END;
/
BEGIN
    apex_automation.enable(
        p_application_id  => 116,
        p_static_id       => 'delete-asynchronous-processed-files-over-24-hours' );
END;
/

It works, but it sucks, because I have to maintain a list of what was enabled before export and what was not somewhere or rely on hardcoding… I have a big system with 25 apps, so this workaround does not scale well…

Questions:

Did I miss anything and maybe there is a something I can do to instruct application import to activate automations and synch jobs that were enabled before import after import is completed?

If not, can you file an enhancement request for it? If I live long enough to see the next version of APEX it would be nice to have it there …

I'm currently on 24.2.

Thanks,

Alex

Comments
Post Details
Added 11 hours ago
0 comments
21 views