ETL9.1 HCM MP5 Cumulative Fails While Running TL DMS Scripts on Fields TEMPLATE_TYPE, AE_SECTION, TL_AESTMTTYPE, PACKAGEROOT (Doc ID 1446799.1)

Last updated on FEBRUARY 16, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.
Currency Check as of 29-JUL-2014

Symptoms

 
ISSUE STATEMENT
---------------
HCM MP5 Cumulative Application failed on TL DMS scripts TL854530_01, TL830418_01, TL839864_01, TL841635_01 ,TL854530_01 ,TL862740_01, TL865279_01 ,TL863677_01 , TL869676_02
 
upd863677_msg_i.dms & DAT file is missing in MP5.
ERROR
---------------
1)Importing  TL_TMPLT_STEPS
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0  Error Position: 0 Return: 8010 - [Microsoft][SQL Native Client][SQL Server]Invalid column name 'TEMPLATE_TYPE'. 
Failed SQL stmt:INSERT INTO PS_TL_TMPLT_STEPS  (TEMPLATE_TYPE, TEMPLATE_ID
TL_RULE_STEP, RULE_OPERAND_TYPE, ACTION_ID, SQL_ID, RECNAME, DESCR100)
VALUES (:1, :2, :3, :4, :5, :6, :7, :8) (200,0) 
SQL Error. Error Position: 0  Return: 8010 - [Microsoft][SQL Native client][SQL Server]Invalid column name 'TEMPLATE_TYPE'. 
2)Importing TL_TMPLT_DEFN
 
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0
Return: 8010 - [Microsoft][SQL Native Client][SQL Server]Invalid column name
'AE_SECTION'. Failed SQL stmt:INSERT INTO PS_TL_TMPLT_DEFN (TEMPLATE_TYPE, TEMPLATE_ID, CORE_COMPONENT, DESCR, DESCRSHORT, TL_USER_EXIT, AE_SECTION, DESCRLONG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8) (200,0)
SQL Error. Error Position: 0 Return: 8010 - [Microsoft][SQL Native Client][SQL Server]Invalid column name 'AE_SECTION'.
3)Importing  TL_RULE_STEPS
Message Set Number: 200 
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 
  Return: 8601 - [Microsoft][SQL Native Client][SQL Server]Cannot insert the 
  value NULL into column 'TL_AESTMTTYPE', table 
  'PS9HRDMO.dbo.PS_TL_RULE_STEPS'; column does not allow nulls. INSERT fails. 
  [Microsoft][SQL Native Client][SQL Server]The statement has been termina 
  Failed SQL stmt:INSERT INTO PS_TL_RULE_STEPS  (TL_RULE_ID, TL_RULE_STEP, 
  RULE_OPERAND_TYPE, ACTION_ID, SQL_ID, RECNAME, DESCR100) VALUES (:1, :2, :3, 
  :4, :5, :6, :7) (200,0) 
 
4) 
TL854530_01.dms failing again after implementing the Step 1 of work around suggested by you with following message. (All other DMS referred in this SR ran to success)
Importing  TL_TMPLT_DEFN 
File: Data MoverSQL error. Stmt #: 0  Error Position: 0  Return: 1400 - ORA-01400: cannot insert NULL into ( SYSADM . PS_TL_TMPLT_DEFN . PACKAGEROOT ) 
Failed SQL stmt:INSERT INTO PS_TL_TMPLT_DEFN  (TEMPLATE_TYPE, TEMPLATE_ID, CORE_COMPONENT, DESCR, DESCRSHORT, TL_USER_EXIT, AE_SECTION, DESCRLONG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8)
Error: Unable to insert row 1
Error: SQL execute error for TL_TMPLT_DEFN
5) upd863677_msg_i.dms & DAT file is missing in MP5.
    
WHAT IS WORKING
---------------
Other than these DMS scripts rest of the MP5 is working fine. 
 
ENVIRONMENT
---------------
DB Platform : Any DB
Tools Version: 8.51
Application   Version: PeopleSoft HCM 9.1
Production/Development/Test : Test
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. Take GA database
2. Start applying MP5 (Cumulative) by using Change assistance.
3. MP5 fails with following error while executing following DMS scripts TL830418_01, TL839864_01, TL841635_01 ,TL854530_01 ,TL862740_01, TL865279_01 ,TL863677_01 , TL869676_02    TL854530_01 with errors listed above.
 
IMPACT
---------------
Customer is unable to complete MP5 application.

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