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: Person number of the employee prefixed with ET Calculation breakdown ID	The employee's person number must be prefixed with ET. 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 date required for the adjustment is after the upload date. There's an invalid date on the batch line itself. The upload date in the batch lines should not be populated unless different from the one specified in the batch header.
The adjustment isn't valid on adjustment date {ADJ_DATE}.	The payroll you specified isn't valid for the employee on the batch line. Assign the specified payroll to the employee. Correct the payroll for 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: There's a non-numeric value in the actual Balance Value column in the batch line. The file contains white space.
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.