ELM 9.2 : UpdateStats Function Not Working on LM_LD_STGDAT (Doc ID 1614500.1)

Last updated on JULY 03, 2017

Applies to:

PeopleSoft Enterprise ELS Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Statement Of Issue:

UpdateStats function not commited the data on LM_LD_STGDAT.  These ignore commit causes performance delay on AE process.


Replication Steps:

1) Login as Admin
2) Move the HRMS data to ELM
3)Run LM_LD_STGDAT process with trace options.

Log files:

-- 15.51.29 ...(LM_LD_WKFC.FS_INS.Step04) (SQL)
RECSTATS PS_LM_PRSJOB_TMP1 LOW
/
-- 15.51.29 UpdateStats ignored - COMMIT required

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