Financial and Pension Reporting Audit Log Errors

This section lists common Financial reporting related errors that may appear in Audit log when you running payroll from XCD.

Message (on Click Log):

Insert failed. First exception on row 0; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record or 20 records: Salesforce record ID

User message description:

Financial Reporting record was not created

Resolution

This error means there are two processes were trying to create the finance report at the same time.

We recommend you wait if other user were creating finance report at the same time, if not, please try running finance report again.

Message (on Click Log):

Blank

User message description:

Insertion process failed for the following instance : {Financial reporting record details} Please review the record and do correction before repeat the process.

1)We can't save this record because the “process builder name” process failed.

Resolution

This error may caused by a customised process builder which is running at the same time when creating finance reporting record.

We recommend you to contact support to review the custom process builder before re-try creating finance reports

Message (on Click Log):

Attempt to de-reference a null object 

User message description:

An Exception has occurred while creating Pension reporting record for employee : Employee's name

Resolution

This error may caused by various reasons:

• FTE salary or Annual salary is blank

• some or all of the pension pay details have not linked successfully to a job role record or Compensation record 

We recommend you check the following then try re-run the Pension report:

• On Employee's Compensation record - check FTE salary and Annual salary are entered, if is non-salary compensation record, ensure 0 value is entered instead of being null

• Within employee's pay summary > open each pension pay details and check if the job role field and Compensation are populated. If not, link it to the current job role and Compensation record

Message (on Click Log):

Attempt to de-reference a null object 

User message description:

Financial Reporting record was not created for PD-xxxxxxx for Employee's name. Incorrect values in paydetail fields. 

Resolution

This error may caused by multiple expense / mileage record linked to different job roles.

We recommend you check the following then try re-run the Pension report:

• Any pay details which are created from the Claim

• In the claim record, check the linked expense or mileage record

• Check if all expense or mileage records are linked to the same job role

• On financial report, check if there is any pay detail created with the total claim value, if so, the error can be ignored