My Oracle Support Banner

ORA-01861 Error When Running Funds Allocation SQR Report (VC006.SQR) (Doc ID 2444165.1)

Last updated on MARCH 12, 2021

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

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


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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