ELM 9.0: Process Fullsync Data AE (LM_LD_WKFC), Workforce Data Producing Incorrect Error Message: "Could Not Find the Organization for This Person in the LM_ORGANIZATION Table" (Doc ID 1299740.1)

Last updated on MAY 26, 2016

Applies to:

PeopleSoft Enterprise ELS Enterprise Learning Management - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 07-Jul-2014***

Symptoms

Process Fullsync Data (Application Engine LM_LD_STGDAT that dynamically calls LM_LD_WKFC) , Workforce Data produce incorrect error message: "Could not find the organization for this person in the LM_ORGANIZATION table".

The issue can be reproduced at will with the following steps:

  1. Run WORKFORCE_FULLSYNC messages from HCM to ELM, receive done status on messages.
  2. Verify data loaded into the ELM Staging tables.
  3. Run process Process Fullsync Data (AE LM_LD_STGDAT, which dynamically calls AE LM_LD_WKFC).
  4. Review the  Standard Report from the Process Fullsync Data, Workforce Data receive error message for Learner's Workforce data : "Could not find the organization for this person in the LM_ORGANIZATION table", even though Department is Active and in the Organization table for LM_HR_DEPTID in the Learner's LM_STG_PRS_JOB table data.

Administrators unable to view new Learners or  unable to view some of the existing Learners Job Information, because Job data not loaded in the ELM Workforce application tables.

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