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é
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.