Skip to main content

Error: 'KEY-COMMIT TRIGGER Raised unhandled exception ORA-29282'

When generating the GL, the screen just hangs and the GL will not run. The following error appears at the bottom left of the Generate GL Interface screen.

O
Written by Onyema Onyejekwe
Updated over 3 months ago

If generating a GL causes the screen to hang and the GL does not run, you may be facing one of three potential issues.

We have compiled a list of these issues along with their resolutions.


Hourly, daily or annual rate of pay

This issue may relate to the employee's hourly, daily, or annual rate of pay. Specifically, if the value of the daily or hourly rate is too high, it may cause the GL to fail, or there could be a system-level data mapping error.

To resolve this issue, our support team will need to run some scripts.

Please raise a new case online and reference the title of this article. Include the following details:

  • Pay group

  • Payroll period

  • The correct daily or hourly rate for the employee.


Data mapping issue

There may be a system-level data mapping issue, which could include missing or duplicated entries.

To resolve this issue, our support team will need to run some scripts.

Please raise a new case online and reference the title of this article. Include the following details:

  • Pay group

  • Payroll period


Company reference

A missing company reference in the back-end tables may also lead to this problem.

To resolve this issue, our support team will need to run some scripts.

Please raise a new case online and reference the title of this article. Include the following details:

  • Pay group

  • Payroll period

Did this answer your question?