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!

ORA-54013 while copying Automation

bp1974Jun 14 2023 — edited Jun 14 2023

I am trying to copy an Apex Automation from one application to another (APEX v21.2.3) , and getting the following error.

Querying for virtual columns, I see the following:

TABLE_NAME COLUMN_NAME
---------------------------------------- -----------------
WWV_FLOW_AUTOMATIONS SYS_NC00045$
WWV_FLOW_AUTOMATION_ACTIONS EMAIL_TEMPLATE_ID
WWV_FLOW_AUTOMATION_LOG1$ SYS_NC00011$
WWV_FLOW_AUTOMATION_LOG2$ SYS_NC00011$
WWV_FLOW_AUTOMATION_MSG_LOG1$ SYS_NC00009$
WWV_FLOW_AUTOMATION_MSG_LOG2$ SYS_NC00009$

EMAIL_TEMPLATE_ID is NULL, so the issue must be with one of the system generated columns.

Has anyone encountered this, or any suggestions to get past this?

Thanks,

Brian

This post has been answered by Ananya Chatterjee-Oracle on Jun 15 2023
Jump to Answer
Comments
Post Details
Added on Jun 14 2023
1 comment
256 views