Payroll Error: ORA-1840 Occurred At Line 232 Of Formula NI (Doc ID 1958893.1)

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, UK Payroll

When attempting to Payroll, the following error occurs.
Have NI Retro enabled. But for the assignment where error is raised, there is not retrospective change on NI Category and still the formula errors.

ERROR
-----------------------
"assignment action rowid = AABC54AGIAABKg8AAH
max errors allowed = 20
errors encountered = 1
In { pyflflog
Out } pyflflog
In { pylogseh
 In { pyxpmsh
 Out } pyxpmsh
 In { pylogpop
 Out } pylogpop
HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO 3716635
APP-PAY-51118: Error was encountered when processing assignment XXXXX
 In { pyxipmt
message text = Error was encountered when processing assignment XXXXX
message level = F,F
payroll_id text = 62
source_id text = 6,299764
line_text = 56, Error was encountered when processing assignment XXXXX
 Out } pyxipmt
 In { pylogpop
 Out } pylogpop
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME NI
APP-PAY-51119: Error was encountered when processing Element Type NI
 In { pyxipmt
message text = Error was encountered when processing Element Type NI
message level = F,F
payroll_id text = 62
source_id text = 6,299764
line_text = 53, Error was encountered when processing Element Type NI
 Out } pyxipmt
 In { pylogpop
 Out } pylogpop

..............
R_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT ORA-1840 occurred at line 232 of formula NI

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

Action: Please refer to your system administrator.
(4=0)
APP-PAY-06867: An error occurred during formula execution:

ORA-1840 occurred at line 232 of formula NI

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

Action: Please refer to your system administrator.
(4=0)"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform Initial Balance Upload for the assignments
2. Ran payroll for all assignments
3. Results were checked, it was identified few balances were incorrect
4. Perform balance adjustment. This sets the balances to correct value
5. Mark the assignments payroll run action for retry
6.  Retry the payroll run process
7. It fails with error stated

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to use retro NI

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