Upgrade to 12.1.1 Patch 6678700 FAILED: File Fem_calendar.ldt On Worker 1 ORA-01438: value larger than specified precision allowed for this column (Doc ID 1466817.1)

Last updated on MARCH 06, 2014

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 and later
Information in this document applies to any platform.
FEM
EPF

Checked for relevance on 06-MAR-2014.

Symptoms

While upgrading from 11.5.10.2 to R12.1.1 (6678700) worker 1 failed to complete fem_calendar.ldt task. The following error appears in the log file:

ERROR
Uploading from the data file /u01/oracle/appl/DEV/apps/apps_st/appl/fem/12.0.0/patch/115/import/US/fem_calendar.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01/oracle/appl/DEV/apps/apps_st/appl/fem/12.0.0/patch/115/import/fem_calendar.lct(120.0), /u01/oracle/appl/DEV/apps/apps_st/appl/fem/12.0.0/patch/115/import/US/fem_calendar.ldt) to staging tables
Dumping LCT file /u01/oracle/appl/DEV/apps/apps_st/appl/fem/12.0.0/patch/115/import/fem_calendar.lct(120.0) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u01/oracle/appl/DEV/apps/apps_st/appl/fem/12.0.0/patch/115/import/US/fem_calendar.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FEM_CALENDARS_B Default , FEM_CALENDARS_ATTR SOURCE_SYSTEM_CODE 199 20 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for FEM_CALENDARS_B: CALENDAR_DISPLAY_CODE = Default, ORA-01438: value larger than specified precision allowed for this column
ORA-01403: no data found
Concurrent request completed

STEPS
The issue can be reproduced at will with the following steps:
1. Run the upgrade driver for 11.5.10.2 to R12.1.1
2. Check the log files for the failure reported on:

Fixed: file fem_calendar.ldt on worker 1 for product fem username APPS.

Time is: Tue Jun 12 2012 12:55:30

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