My Oracle Support Banner

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

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