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!

Apex 24.2: Application deployment from one environment to other hampers in-process workflows

Mohammed Sadiq3 days ago

Hi,

We are running Apex 24.2 on-premise and have 3 environments, DEV, TEST and PROD.

Whenever a bug is fixed or an enhancement is completed in DEV, we will take an application export and import it to higher environments, TEST & PROD, overwriting the existing application.

Later, we noticed that after every such migration of changes, the workflow transactions that are enroute is stuck with the last approver and do not proceed further, it will throw a NO DATA FOUND issue when the approver tries to take an action, because the relevant transaction goes missing in the APEX_TASKS table.

My question is, what is the right approach to migrate an application change from one instance to another (on-premise installation) and how to prevent this data loss?

Looking forward to getting advice to overcome this issue.

Regards,

Mohammed Sadiq

Comments
Post Details
Added 3 days ago
17 comments
85 views