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"
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***
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:
- Run WORKFORCE_FULLSYNC messages from HCM to ELM, receive done status on messages.
- Verify data loaded into the ELM Staging tables.
- Run process Process Fullsync Data (AE LM_LD_STGDAT, which dynamically calls AE LM_LD_WKFC).
- 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms