Patch 7303030 Hxczzhxcmpps0343.ldt Failed including Many Other Ldt files For Product OTL (HXC)
Last updated on JULY 12, 2016
Applies to:Oracle Time and Labor - Version 12.0 HRMS RUP10 to 12.0 HRMS RUP10 [Release 12.0]
Information in this document applies to any platform.
During upgrade process from 12.0.4 to 12.1.3, when applying Patch 7303030 12.1.1 Maintenance Pack,
the following error occurs.
FAILED: file hxczzhxcmpps0343.ldt on worker 1.
FAILED: file hxczzhxcmpps0344.ldt on worker 2.
FAILED: file hxczzhxcmpps0345.ldt on worker 3.
FAILED: file hxczzhxcmpps0346.ldt on worker 4.
FAILED: file hxczzhxcmpps0347.ldt on worker 5.
FAILED: file hxczzhxcmpps0348.ldt on worker 6.
FAILED: file hxczzhxcmpps0349.ldt on worker 7.
FAILED: file hxczzhxcmpps0350.ldt on worker 8.
FAILED: file hxczzhxcmpps0351.ldt on worker 9.
FAILED: file hxczzhxcmpps0352.ldt on worker 10.
FAILED: file hxczzhxcmpps0353.ldt on worker 11.
FAILED: file hxczzhxcmpps0354.ldt on worker 12.
FAILED: file hxczzhxcmpps0355.ldt on worker 13.
FAILED: file hxczzhxcmpps0356.ldt on worker 14.
FAILED: file hxczzhxcmpps0357.ldt on worker 15.
FAILED: file hxczzhxcmpps0358.ldt on worker 16.
FAILED: file hxczzhxcmpps0359.ldt on worker 17.
FAILED: file hxczzhxcmpps0360.ldt on worker 18.
FAILED: file hxczzhxcmpps0361.ldt on worker 19.
FAILED: file hxczzhxcmpps0362.ldt on worker 20.
FAILED: file hxczzhxcmpps0363.ldt on worker 21.
FAILED: file hxczzhxcmpps0364.ldt on worker 22.
FAILED: file hxczzhxcmpps0365.ldt on worker 23.
FAILED: file hxczzhxcmpps0366.ldt on worker 24.
FAILED: file hxczzhxcmpps0367.ldt on worker 25.
FAILED: file hxczzhxcmpps0368.ldt on worker 26.
FAILED: file hxczzhxcmpps0369.ldt on worker 27.
FAILED: file hxczzhxcmpps0370.ldt on worker 28.
FAILED: file hxczzhxcmpps0371.ldt on worker 29.
FAILED: file hxczzhxcmpps0372.ldt on worker 30.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.All ldt files (343 to 372) failed with the below errors:
A syntax error occurred at line 192 in file /oaupg/r12/apps/apps_st/appl/hxc/12.0.0/patch/115/import/hxcmppsmappingld.lct
Current system time is Wed May 29 10:39:04 2013
Uploading from the data file /oaupg/r12/apps/apps_st/appl/hxc/12.0.0/patch/115/import/US/hxczzhxcmpps0354.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/oaupg/r12/apps/apps_st/appl/hxc/12.0.0/patch/115/import/hxcmppsmappingld.lct(120.0.12000000.2), /oaupg/r12/apps/apps_st/appl/hxc/12.0.0/patch/115/import/US/hxczzhxcmpps0354.ldt) to staging tables
Dumping LCT file /oaupg/r12/apps/apps_st/appl/hxc/12.0.0/patch/115/import/hxcmppsmappingld.lct(120.0.12000000.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file /oaupg/r12/apps/apps_st/appl/hxc/12.0.0/patch/115/import/US/hxczzhxcmpps0354.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (HXC_MAPPINGS OTL Deposit Process Mapping , HXC_MAPPING_COMP_USAGES LineComment12 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for HXC_MAPPING_COMP_USAGES: MAPPING_NAME = OTL Deposit Process Mapping, MAPPING_COMP_NAME = LineComment12, ORA-01403: no data found
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Apply Patch 7303030 12.1.1 Maintenance Pack
R12.0.4 instance had been upgraded to Patch 13774477 Oracle HRMS Release Update Pack 10 for 12.0 (R12.HR_PF.A.DELTA.10)
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