Skip to main content
Question

Balance_Recon_Util_API.Automatic_Reconcile runs into an error

  • November 2, 2022
  • 1 reply
  • 60 views

Forum|alt.badge.img+6

Hi Community,

since a few days the database job Balance_Recon_Util_API.Automatic_Reconcile breaks with the error message "ORA-01400: cannot insert NULL into ("IFSAPP". "TIME_PERS_DIARY_RESULT_TAB". "ORG_CODE") ORA-06512:".

I think it is due to incorrectly set master data, but I don't know the data source for the job. Can someone tell me where I can search most sensibly?

Regards

André

1 reply

ADDMARIAE
Superhero (Partner)
Forum|alt.badge.img+14
  • Superhero (Partner)
  • 289 replies
  • November 3, 2022

Hi,

Sounds like one (or more) employee does not have a primary organization assignment for the time that is being reconciled.

Maybe you can compare employees in Balance Reconciliation Status to Organization and Position assignments to verify that everybody really has a primary assignment for the time.

Maybe also change to manual reconciliation and do it manually and then you can identify who it is stopping for. 

Unfortunately the error message on the scheduled task doesn’t include employee number… Should be reported to IFS support as a bug.

//Maria


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings