When Running UIF Pre-Process, Errors: ORA-06512: At "APPS.PAY_ARCHIVE", Line 1207 (Doc ID 1622984.1)

Last updated on JULY 27, 2017

Applies to:

Oracle HRMS (South African) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, South African Payroll, on production, patched to RUP6

When attempting to process the UIF Preprocess concurrent request, the following error occurs.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01476: divisor is equal to zero
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-01476: divisor is equal to zero
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

Cause: an oracle error has occurred. The failure was reported on table pay_archive.process_employee at location 1108 with the error text ORA-01476: divisor is equal to zero
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3



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

1. From ZA HRMS Manager
2. Run the payroll processes for the current pay period, for the consultants payroll, then run the UIF preprocess.
3. Review the log file generated.


Changes

 

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