AU : Single Touch Payroll Report 2022 - Request Set Errors With ORA-01843: Not A Valid Month (Doc ID 2965599.1)

Last updated on AUGUST 03, 2023

Applies to:

Symptoms

When attempting to run request set for Single Touch Payroll Report 2022 to run the report for all different Legal Employers,
the following error occurs.

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01843: not a valid month

SQL_NO 466
TABLE_NAME FND_SESSIONS
APP-PAY-06881: Error ORA-01843: not a valid month
 has occurred in table FND_SESSIONS at location 466

Cause: an oracle error has occurred. The failure was reported on table FND_SESSIONS at location 466 with the error text ORA-01843: not a valid month.
Action: Please contact your support representative.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as  Australian HRMS Manager responsibility 
2. View > Submit Request
3. Submit Request Set "XX STP Report Set 2022"
4. Error

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.