Troubleshoot Balance Initialization Errors for the US
To help resolve common balance initialization issues, here are the kinds of messages the process can return, their solutions, and any additional notes.
Error message |
Solution |
Additional notes |
---|---|---|
A value was not provided for the CALC_BREAKDOWN_ID reference. |
Provide on the related batch line either:
|
The employee's person number must be prefixed with
Providing the person number helps avoid errors by allowing the process to derive the calculation breakdown ID based on it. |
No appropriate payroll time periods exist to allow the creation of a nonrecurring entry. |
Define least one active payroll period at the effective date for the upload date. |
If you are posting an initialization at the beginning of the year, you may need a period set up in the prior year depending on the dimension you are initializing. |
The balance doesn't exist. The balance dimension doesn't exist. |
Either correct the entry or create the missing balance or balance dimension. |
|
The adjustment isn't valid on {ADJ_DATE}. |
Correct the upload date in either the header or the batch line. |
The process was unable to create the adjustment due to the invalid date. The adjustment date is derived from the dimension specified. Some causes of this error can be:
|
The adjustment isn't valid on adjustment date {ADJ_DATE}. |
The payroll you specified isn't valid for the employee on the batch line.
|
|
ORA-01722: invalid number ORA XXXX: Number format error |
The data you entered in the upload file must be the same type as the underlying tables (pay_batch_lines, pay_batch_line_values). |
Some causes of this error can be:
|
ORA-20001: An assertion failure was detected at location pay_core_dates.fiscal_year:pasu_fiscal_year_start_date_missing. Details: Contact your help desk. ORA-06512: at "FUSION.PAY_BALANCE_VIEW_PKG", line 1290 ORA-06512: at line 1 |
Enter a Fiscal Year Start date for the legal entity. |
Use the Legal Entity HCM Information task, in the Payroll Statutory Unit tab, Payroll Statutory Unit Details link, to find this value. |
ORA-01861: literal doesn't match format string ORA-01843: not a valid month |
Enter the date in the correct format. |
Date must be in YYYY-MM-DD format, such as 2023-06-30. |