Total Entitlement not Displayed When Using NZ_SICK_LEAVE_ACCRUAL (Doc ID 2153866.1)

Last updated on JULY 17, 2017

Applies to:

Oracle HRMS (New Zealand) - Version 12.1.3 to 12.1 HRMS RUP9 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Problem Statement:

<Issue 1>

On the Accruals form the Total Entitlements is field is not displaying correctly for the Accrual Plan.


<Issue 2>

If the employee's hire date is in between 28th to 30th, Accrual form throws APP-PAY-33208.

APP-PAY-33208: ORA-1839 occured at line 177 of formula ANNZ_SICK_LEAVE_ACCRUAL

Cause: Whilst executing PL/SQL, an Oracle error occurred. The line number and line position, are give where available

Action: Please refer to your system administrator.

 

Steps to Reproduce:

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


<Issue 1>

  1.  Create elements.
    a.
    Name: XXSick Leave
    Primary Classification: Sick Leave Absence
    Type: Nonrecurring
    Input Value: Days (Day)

    b.
    Name: XXSick Leave Opening Balance
    Primary Classification: Information
    Type: Nonrecurring
    Input Value: Entry Effective Date(Date), Plan Days(Day)

  2. Create element links.
  3.  Create Absence Type "XXSick Leave Type" that uses element "XXSick Leave".
  4.  Create Accrual Plan "XXSick Leave Plan" and use the seeded formula NZ_SICK_LEAVE_ACCRUAL for the Accrual Plan.
     Add "XXSick Leave Opening Balance" in the net calculation rule.
  5. Create element entry "XXSick Leave Plan" and "XXSick Leave Opening balance"=15 days.
  6. Create absence record.
    Type: Sick Leave Type
    Actual Start: 01-JAN-2017
    Actual End: 01-JAN-2017
    Hours: 8
  7. Go to Accrual form.
  8. Total Entitlements are not showing the correct values.


<Issue 2>

  1.  Create element "XXSick Leave".
  2.  Create Absence Type "XXSick Leave Type" that uses element "XXSick Leave".
  3.  Create Accrual Plan "XXSick Leave Plan" and use the seeded formula NZ_SICK_LEAVE_ACCRUAL for the Accrual Plan.
  4.  Hire employee on 28-AUG-2015.
  5. Create element entry "XXSick Leave Plan".
  6. Create absence record.
    Type: Sick Leave Type
    Actual Start: 01-AUG-2017
    Actual End: 01-AUG-2017
    Hours: 8
  7. Go to Accrual form.
  8. Error occurs.

 

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