ELM 9.X: Process Asynchronous Data (AE LM_LD_ASYNC) With Non-English Base Language, User Receive Error Message ORA-00957: duplicate column for Language_Cd (Doc ID 1625044.1)

Last updated on FEBRUARY 29, 2016

Applies to:

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

Symptoms


For a Non-English based language set and logged in using Spanish (ESP ) and run the Process Asynchronous Data (AE LM_LD_ASYNC), if processing Department/Organization data receive
a SQL Error message that the a duplicate column exists.

Error Message
 
Stmt #: 5547 Error Position: 157 Return: 957 - ORA-00957: duplicate column
name
Failed SQL stmt:INSERT INTO
PS_LM_STG_DEPT_LG
(LM_HR_SETID,LM_HR_DEPTID,LM_EIP_CTRL_ID,EFFDT,PROCESS_INSTANCE,LM_ORGANIZATION_ID,LM_ORG_DESCR,LM_ORG_SDESCR,LM_EIP_PRCS_STTS,LANGUAGE_CD,
LANGUAGE_CD) VALUES (:1,:2,:3,TO_DATE(:4,'YYYY-MM-DD'),:5,:6,:7,:8,:9,:10, :11)


Steps to Replicate Error:

1.  Ensure HCM DEPT_SYNC and LM_DEPT_SYNC integrated with ELM.

2.  In HCM, Log in as an Administrator in Non-English language such as Spanish (ESP) in HCM, update a Department.
3.  After DEPT_SYNC message status done in HCM.
4.  Log in Spanish as a User with Administrator role and verify LM_DEPT_SYNC message status done and data loaded into the ELM Staging table.
5.  Navigate to Setup ELM > Process Asynchronous Data (AE LM_LD_ASYNC) and run
6.  Notice Process ends with Status No Success

 

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