Error While Trying To Update The Approver Group - ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
(Doc ID 3073357.1)
Last updated on FEBRUARY 26, 2025
Applies to:
Oracle Approvals Management - Version 12.1 HRMS RUP14 and laterInformation in this document applies to any platform.
Symptoms
When attempting to update an approval group, the following error occurs.
You have encountered an unexpected error. Please contact the System Administrator for assistance.
## Detail 0 ##
java.sql.SQLException: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 4104
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 3664
## Detail 0 ##
java.sql.SQLException: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 4104
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 3664
STEPS
The issue can be reproduced at will with the following steps:
1. Navigate to Approvals Management Business Analyst Responsibility -> Business Analyst Dashboard
2. click on the Setup icon for 'Purchase Order Approval' AME transaction type.
3. Click on Approval Group, click on Update on any Approval Group.
4. Shows Error.
To see the complete Java Error stack details please follow Note:297176.1 - Error Page : You have encountered an unexpected error. Please contact the System Administrator for assistance.
Java Error Details:
SELECT * FROM (SELECT ApproverGroupItemEO.APPROVAL_GROUP_ITEM_ID,
ApproverGroupItemEO.APPROVAL_GROUP_ID,
ApproverGroupItemEO.PARAMETER_NAME,
ApproverGroupItemEO.PARAMETER,
ApproverGroupItemEO.ORDER_NUMBER,
ApproverGroupItemEO.START_DATE,
ApproverGroupItemEO.END_DATE,
ApproverGroupItemEO.OBJECT_VERSION_NUMBER,
Approvers.APPROVER APP_NAME,
Approvers.APPROVER_TYPE ORIG_SYSTEM,
'deleteAllowed' DELETE_SWITCHER,
AppTypeLookups.Meaning APP_TYPE,
'OLD' AS STATUS_FLAG,
'OLD_VAL' AS NAME_FLAG,
Approvers.approver_type2 APPROVER_TYPE
FROM AME_APPROVAL_GROUP_ITEMS ApproverGroupItemEO,
(select ame_approver_type_pkg.getApproverDescription(agi.parameter) APPROVER
,ame_approver_type_pkg.getApproverOrigSystem2(agi.parameter) APPROVER_TYPE
,agi.order_number ORDER_NUMBER,agi.approval_group_id approval_group_id
,agi.approval_group_item_id approval_group_item_id,
'APPROVER' approver_type2
from ame_approval_group_items agi,
(select name,orig_system
from wf_roles where status = 'ACTIVE' AND
nvl(expiration_date,sysdate) >= sysdate AND
orig_system in ('PER','POS','FND_USR')) roles
where
sysdate between agi.start_date and nvl(agi.end_date-(1/86400),sysdate) AND
agi.parameter_name = 'wf_roles_name' AND
roles.name(+) = agi.parameter
union
select apg.name APPROVER,'NESTED_GROUP' APPROVER_TYPE,
agi.order_number ORDER_NUMBER,
agi.approval_group_id approval_group_id,
agi.approval_group_item_id approval_group_item_id,
'NESTED_GROUP' approver_type2
from ame_approval_groups apg,
ame_approval_group_items agi
where sysdate between agi.start_date and nvl(agi.end_date-(1/86400),sysdate) AND
sysdate between apg.start_date and nvl(apg.end_date-(1/86400),sysdate) AND
agi.parameter_name = 'OAM_group_id' AND
agi.parameter = to_char(apg.approval_group_id)) Approvers,
FND_LOOKUPS AppTypeLookups
WHERE sysdate between ApproverGroupItemEO.start_date and nvl(ApproverGroupItemEO.end_date-(1/84600),sysdate) AND
Approvers.approval_group_item_id = ApproverGroupItemEO.approval_group_item_id AND
(AppTypeLookups.lookup_type = 'FND_WF_ORIG_SYSTEMS' OR AppTypeLookups.lookup_type='AME_NESTED_GROUP')
AND AppTypeLookups.lookup_code = Approvers.APPROVER_TYPE) QRSLT WHERE (APPROVAL_GROUP_ID = :1)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
## Detail 0 ##
java.sql.SQLException: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 4104
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 3664
ORA-14551: cannot perform a DML operation inside a query
ORA-06512: at "APPS.AME_UTIL", line 3646
ORA-06512: at "APPS.AME_UTIL", line 4067
ORA-06512: at "APPS.AME_APPROVER_TYPE_PKG", line 19
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 4104
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 3664
ORA-14551: cannot perform a DML operation inside a query
ApproverGroupItemEO.APPROVAL_GROUP_ID,
ApproverGroupItemEO.PARAMETER_NAME,
ApproverGroupItemEO.PARAMETER,
ApproverGroupItemEO.ORDER_NUMBER,
ApproverGroupItemEO.START_DATE,
ApproverGroupItemEO.END_DATE,
ApproverGroupItemEO.OBJECT_VERSION_NUMBER,
Approvers.APPROVER APP_NAME,
Approvers.APPROVER_TYPE ORIG_SYSTEM,
'deleteAllowed' DELETE_SWITCHER,
AppTypeLookups.Meaning APP_TYPE,
'OLD' AS STATUS_FLAG,
'OLD_VAL' AS NAME_FLAG,
Approvers.approver_type2 APPROVER_TYPE
FROM AME_APPROVAL_GROUP_ITEMS ApproverGroupItemEO,
(select ame_approver_type_pkg.getApproverDescription(agi.parameter) APPROVER
,ame_approver_type_pkg.getApproverOrigSystem2(agi.parameter) APPROVER_TYPE
,agi.order_number ORDER_NUMBER,agi.approval_group_id approval_group_id
,agi.approval_group_item_id approval_group_item_id,
'APPROVER' approver_type2
from ame_approval_group_items agi,
(select name,orig_system
from wf_roles where status = 'ACTIVE' AND
nvl(expiration_date,sysdate) >= sysdate AND
orig_system in ('PER','POS','FND_USR')) roles
where
sysdate between agi.start_date and nvl(agi.end_date-(1/86400),sysdate) AND
agi.parameter_name = 'wf_roles_name' AND
roles.name(+) = agi.parameter
union
select apg.name APPROVER,'NESTED_GROUP' APPROVER_TYPE,
agi.order_number ORDER_NUMBER,
agi.approval_group_id approval_group_id,
agi.approval_group_item_id approval_group_item_id,
'NESTED_GROUP' approver_type2
from ame_approval_groups apg,
ame_approval_group_items agi
where sysdate between agi.start_date and nvl(agi.end_date-(1/86400),sysdate) AND
sysdate between apg.start_date and nvl(apg.end_date-(1/86400),sysdate) AND
agi.parameter_name = 'OAM_group_id' AND
agi.parameter = to_char(apg.approval_group_id)) Approvers,
FND_LOOKUPS AppTypeLookups
WHERE sysdate between ApproverGroupItemEO.start_date and nvl(ApproverGroupItemEO.end_date-(1/84600),sysdate) AND
Approvers.approval_group_item_id = ApproverGroupItemEO.approval_group_item_id AND
(AppTypeLookups.lookup_type = 'FND_WF_ORIG_SYSTEMS' OR AppTypeLookups.lookup_type='AME_NESTED_GROUP')
AND AppTypeLookups.lookup_code = Approvers.APPROVER_TYPE) QRSLT WHERE (APPROVAL_GROUP_ID = :1)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
## Detail 0 ##
java.sql.SQLException: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 4104
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 3664
ORA-14551: cannot perform a DML operation inside a query
ORA-06512: at "APPS.AME_UTIL", line 3646
ORA-06512: at "APPS.AME_UTIL", line 4067
ORA-06512: at "APPS.AME_APPROVER_TYPE_PKG", line 19
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 4104
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "APPS.AME_UTIL", line 3664
ORA-14551: cannot perform a DML operation inside a query
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |