My Oracle Support Banner

Error Querying LM_SRCH_ACTSEC: "ORA-01861: literal does not match format string" (Doc ID 2077659.1)

Last updated on MAY 25, 2018

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When attempting to query LM_SRCH_ACTSEC, the following error occurs.


ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as literals in
  the format string (with the exception of leading whitespace). If the
  "FX" modifier has been toggled on, the literal must match exactly,
  with no extra whitespace.
*Action: Correct the format string to match the literal.


The issue can be reproduced at will with the following steps:
1. Run the following SQL on a latest ELM 92 Demo Database: 

select * from ps_LM_SRCH_ACTSEC;



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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