ORA-01861 Error When Running Funds Allocation SQR Report (VC006.SQR)
(Doc ID 2444165.1)
Last updated on NOVEMBER 26, 2021
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When executing the Funding Allocation Report, VC006.SQR, the process goes to 'No Success' with the following error:
(SQR 5528) ORACLE OCIStmtExecute error 1861 in cursor 6:
ORA-01861: literal does not match format string
Error on line 205:
(SQR 3723) Problem executing cursor.
The issue can be reproduced at will with the following steps:
1. Navigation: Main Menu > Compensation > Variable Compensation > Variable Comp Reports > Funds Allocation
2. Run the Funding Allocations report (VC006)
3. Note above error is received
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document