Getting error ORA-14552: cannot perform a DDL, commit or rollback inside a query while retrieving payroll balances by date using pay_balance_pkg.get_value
(Doc ID 2405542.1)
Last updated on DECEMBER 18, 2020
Applies to:
Oracle Payroll - Version 12.2.5 and laterInformation in this document applies to any platform.
Goal
Facing an error while retrieving balance using PAY_BALANCE_PKG.get_value
select pay_balance_pkg.get_value(<defined_balance_id>, <assignment_id>, <date> ) from dual;
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML ORA-06512: at "APPS.PAY_BALANCE_PKG", line 5653 ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML ORA-06512: at "APPS.PAY_BALANCE_PKG", line 5908 ORA-06512:
Solution
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
Goal |
Solution |
References |