ELM: Message LM_DEPT_FULLSYNC Integrated with HCM Message DEPT_FULLSYNC Received Fatal SQL Error Occurred. (2,125)
(Doc ID 3049837.1)
Last updated on FEBRUARY 04, 2025
Applies to:
PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Message LM_DEPT_FULLSYNC Integrated with HCM Message DEPT_FULLSYNC Received Fatal SQL Error Occurred. (2,125).
Error Message:
Cannot insert the value NULL into column 'EFFDT', table '.....dbo.PS_LM_STG_DEPT'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has
Statement: INSERT INTO PS_LM_STG_DEPT (LM_HR_SETID,LM_HR_DEPTID,LM_EIP_CTRL_ID,EFF_STATUS,PROCESS_INSTANCE,LM_ORGANIZATION_ID,LM_ORG_DESCR,LM_ORG_SDESCR,LM_LE_ID,LM_ORG_TYPE,LM_MANAGER_ID,LM_MANAGER_POSN,COUNTRY,LM_TAXPAYER_ID,LM_PARENT_COMPANY,LM_COMPANY_URL,LM_STOCK_SYMBOL,LM_INDUSTRY,LM_BUSINESS,LM_CUSTOMER_TYPE,LM_MARKET,BUSINESS_UNIT_GL,LM_ROW_ADDED_OPRID,LM_ROW_MAINT_OPRID,LM_ACCOUNT,LM_ALTACCT,LM_BUDGET_REF,LM_CHARTFIELD1,LM_CHARTFIELD2,LM_CHARTFIELD3,LM_CLASS_FLD,LM_FUND_CODE,LM_OPERATING_UNIT,LM_PRODUCT,LM_PROGRAM_CODE,LM_PROJECT_ID,LM_HR_MANAGER_ID,LM_ENABLE_CASH,LM_ENABLE_CHECK,LM_ENABLE_CHGBK,LM_ENABLE_CRCARD,LM_ENABLE_PO,LM_ENABLE_TU,LM_ENABLE_DISCOUNT,LM_PYMT_DISCOUNT,LM_CUST_ID,LM_EIP_PRCS_STTS,LANGUAGE_CD,AUDIT_ACTN,BASE_LANGUAGE_CD,LM_HR_COMPANY) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51) Original Statement: %Insert(:1)
The issue can be reproduced at will with the following steps:
1. Log in HCM environment and ensure DEPT_FULLSYNC integrated to ELM environment, LM_DEPT_FULLSYNC
2. From HCM environment, run the process Initiate for message DEPT_FULLSYNC, which integrates to the ELM environment
LM_DEPT_FULLSYNC
3. In ELM environment., the LM_DEPT_FULLSYNC header message, receives an error message.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |