Patch 7303030 Hxczzhxcmpps0343.ldt Failed including Many Other Ldt files For Product OTL (HXC) (Doc ID 1558546.1)

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.

Symptoms

During upgrade process from 12.0.4 to 12.1.3, when applying Patch 7303030 12.1.1 Maintenance Pack,
the following error occurs.

ATTENTION: All workers either have failed or are waiting:

  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


Changes

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)

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