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

Last updated on APRIL 24, 2017

Applies to:

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

Symptoms


When attempting to query LM_SRCH_ACTSEC, the following error occurs.

ERROR

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.


STEPS

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

select * from ps_LM_SRCH_ACTSEC;


Changes


Cause

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 hundreds of Community platforms