ELM 9.2: Performance Issue with Load Person Data in Process Asynchronous Data (AE LM_LD_ASYNC) (Doc ID 1679766.1)

Last updated on FEBRUARY 15, 2016

Applies to:

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

Symptoms

Performance issue with Process Asynchronous Data (AE LM_LD_ASYNC) with 25K or more job data rows or 4K Person data rows after loading data from message PERSON_BASIC_SYNC Incremental Sync.

Steps to Replicate Issue:

1) Publish from HRMS, PERSON_BASIC_SYNC Incremental Sync for 4K person data changes for employees such as new hires, scribing data into ELM staging tables.
2) Run Process Asynchronous Data ( AE LM_LD_ASYNC)



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