We are getting an error when the scheduled job “Schedule id 57 : Start Time Balance Reconciliation”
does not complete, so we have to manually reconcile. This has been going on for at least one month. No prior issues on Apps 10 since going live almost 3 years ago.
Hi,
What is the error message? The Time Balance reconciliation is a bit “sensitive”… Some times we experience problems also when we run it manunally many employees at a time, but when you run it one by one it works.
Most of the times it is error messages regarding future balance violations and also index problems. Would be interesting to know what errors you get.
Regards,
Maria
Posting on behalf of
When we do it manually, one at a time, we don’t get any error, correct Amy. Amy, do you do it for a small group all at once? If so, do you get an error ?
Here is the entirety of the error message :
ORA-01400: cannot insert NULL into ("ZEHR1APP"."TIME_PERS_DIARY_RESULT_TAB"."ORG_CODE")
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 2352
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 2439
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 774
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 788
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 380
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 380
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 387
ORA-06512: at "ZEHR1APP.TIME_BALANCE_VALUE_API", line 2635
ORA-06512: at "ZEHR1APP.TIME_BALANCE_VALUE_API", line 2643
ORA-06512: at "ZEHR1APP.TIME_BALANCE_VALUE_API", line 2252
ORA-06512: at "ZEHR1APP.TIME_BALANCE_VALUE_API", line 2274
ORA-06512: at "ZEHR1APP.BALANCE_RECON_UTIL_API", line 199
ORA-06512: at "ZEHR1APP.BALANCE_RECON_UTIL_API", line 337
ORA-06512: at "ZEHR1APP.BALANCE_RECON_UTIL_API", line 452
ORA-06512: at "ZEHR1APP.BALANCE_RECON_UTIL_API", line 452
ORA-06512: at "ZEHR1APP.BALANCE_RECON_UTIL_API", line 471
ORA-06512: at line 1
ORA-06512: at "ZEHR1APP.TRANSACTION_SYS", line 1895
ORA-06512: at "ZEHR1APP.TRANSACTION_SYS", line 276
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 2352
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 2439
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 774
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 788
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 380
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 380
ORA-06512: at "ZEHR1APP.TIME_BALANCE_CALC_UTIL_API", line 387
ORA-06512: at "ZEHR1APP.TIME_BALANCE_VALUE_API", line 2635
ORA-06512: at "ZEHR1APP.TIME_BALANCE_VALUE_API", line 2643
ORA-06512: at "ZEHR1APP.TIME_BALANCE_VALUE_API", line 2252
ORA-06512: at "ZEHR1APP.TIME_BALANCE_VALUE_API", line 2274
ORA-06512: at "ZEHR1APP.BALANCE_RECON_UTIL_API", line 199
ORA-06512: at "ZEHR1APP.BALANCE_RECON_UTIL_API", line 337
ORA-06512: at "ZEHR1APP.BALANCE_RECON
HI,
The first error sounds like the employee doesn’t have a primary job assignment on the date of reconciliation, but it could also be an access issue.
What user is it that has scheduled the database task - ZEHR1APP or another user? Note that for all HR tasks the user must have HR access not only full access through permission set. In time and attendance it is not even enough with HR Application manager but th euser must have HR access with a role that contains authorization rights and very often also access to transferred result. This is because some calculations and reconciliations requires removals of authorizations before recalculating and then redo the authorization again.
Regards,
Maria
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.