Access Australian Sick Leave Absence Produces Error - Ora-6510 Occurred At Line 111 Of Formula AU_ANNUAL_LEAVE_ACCRUAL_DAILY (Doc ID 739238.1)

Last updated on JULY 14, 2016

Applies to:

Oracle HRMS (Australia) - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting enter/ maintain absences from people screen in HRMS the following error is produced.

APP-PAY-33208: ORA-1841 occurred at line 111 of formula SICK_ACCRUAL_AU.
Cause: Whilst executing PL/SQL, an Oracle error occurred. The line number and line position, are given where available.

This issue is also replicated with the AU seeded formula:
AU_ANNUAL_LEAVE_ACCRUAL_DAILY - APP-PAY-33208: ORA-6510 OCCURRED AT LINE 111 OF FORMULA AU_ANNUAL_LEAVE_ACCRUAL_DAILY WORKAROUNDS


Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. In Australian HRMS Manager responsibility Enter People Maintain Absence Screen of an valid employee Captured absence

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms