ORA-03113 ORA-03114 When Loading Pepyudttde.ldt (Doc ID 2180398.1)

Last updated on JULY 17, 2024

Applies to:

Oracle Payroll - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

Patch fails loading pepyudttde.ldt with the error below.

Uploading from the data file /oaint9/app/oracle/oaint9R12/fs1/EBSapps/appl/per/12.0.0/patch/115/import/D/loc_de/pepyudttde.ldt
Altering database NLS_LANGUAGE environment to GERMAN
Dump from LCT/LDT files (/oaint9/app/oracle/oaint9R12/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/pyudtt.lct(120.5.12020000.1), /oaint9/app/oracle/oaint9R12/fs1/EBSapps/appl/per/12.0.0/patch/115/import/D/loc_de/pepyudttde.ldt) to stage tables
Dump LCT file /oaint9/app/oracle/oaint9R12/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/pyudtt.lct(120.5.12020000.1) into FND_SEED_STAGE_CONFIG
Dump LDT file /oaint9/app/oracle/oaint9R12/fs1/EBSapps/appl/per/12.0.0/patch/115/import/D/loc_de/pepyudttde.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES_TL HR_DE_LINK_TYPE_MAPPINGS DE , PAY_USER_COLUMNS_TL HR_DE_COUNTRY_CODE DE VALUE ) into FND_SEED_STAGE_ENTITY
Upload from stage tables
A database error occurred:
ORA-03113: end-of-file on communication channel

The error occurred while executing the following statement:
BEGIN FND_SEED_STAGE_UTIL.upload(:lct_file, :proc_id, :debug, :abort, :warning, :err_cnt, :err_msgs); END;
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
APP-FND-01564: ORACLE error 3114 in close_server_files

Cause: close_server_files failed due to ORA-03114: not connected to ORACLE.

The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
ORACLE error 3114 in afpexcp

Cause: afpexcp failed due to ORA-03114: not connected to ORACLE
.

The SQL statement being executed at the time of the error was: and was executed from the file .

Event Trace show the following error stack.

ORA-07445: Exception aufgetreten: CORE Dump [slmecpy()+120] [SIGSEGV] [ADDR:0x0] [PC:0x107845A0C] [Address not mapped to object] []

========= Dump for incident 722553 (ORA 7445 [slmecpy()+120]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x107845A0C, slmecpy()+120] [flags: 0x0, count: 1]
Registers:
----------
%i0: 0x0000000001800000 %i1: 0x0000000000000198 %i2: 0x0000000000040800
%i3: 0x00000007c4fb0b68 %i4: 0x00000007c4fb0c50 %i5: 0xffffffff77f365b0
%i6: 0xffffffff7ffefb41 %fp: 0xffffffff7fff0340 %i7: 0x000000010586efbc
%l0: 0x0000000000000017 %l1: 0x0000000000003e10 %l2: 0x000000010d803000
%l3: 0x000000010bb6f000 %l4: 0x000000000010d803 %l5: 0x000000000010bb6f
%l6: 0xffffffff77f31d28 %l7: 0xffffffff76b313a8
%o0: 0xffffffff77f36e70 %o1: 0x0000000000000000 %o2: 0x0000000000000008
%o3: 0xffffffff77f36e70 %o4: 0x000000000010d800 %o5: 0x0000000000000008
%o6: 0xffffffff7ffefa81 %sp: 0xffffffff7fff0280 %o7: 0x000000010586d1c4
%g1: 0x0000000000000000 %g2: 0xffffffff77f36e40 %g3: 0x0000000000000030
%g4: 0x0000000000000000 %g5: 0x0000000000000004 %g6: 0x0000000000000000
%g7: 0xffffffff79a00200
%pc: 0x0000000107845a0c %npc: 0x0000000107845a10 %y: 0x0000000089ee182e
Stack info:
----------
ss_sp: 0xffffffff7e000400 ss_size: 0x0000000001fffc00 ss_flags: 0
Swap entries = 1
path=swap, size=68719435776, free=66605694976, length=134217648

*** 2016-08-01 14:15:39.202
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=0fb0kjrc367am) -----
UPDATE PAY_USER_COLUMNS_TL SET USER_COLUMN_NAME = NVL(:B2 ,USER_COLUMN_NAME), LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = DECODE(:B1 ,'SEED',1,0), LAST_UPDATE_LOGIN = 0, SOURCE_LANG = USERENV('LANG') WHERE USERENV('LANG') IN (LANGUAGE,SOURCE_LANG) AND USER_COLUMN_ID IN (SELECT USER_COLUMN_ID FROM PAY_USER_COLUMNS WHERE NVL(USER_COLUMN_NAME,'~null~')=NVL(:B4 ,'~null~') AND NVL(LEGISLATION_CODE,'~null~') = NVL(:B3 ,'~null~') AND BUSINESS_GROUP_ID IS NULL)
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
4a9cf43a8 397 package body APPS.PAY_USER_COLUMNS_PKG
4837803e8 164 anonymous block
473c625f0 162 package body APPS.FND_SEED_STAGE_UTIL
8a443b880 1 anonymous block

Steps to Reproduce:

The issue can be reproduced at will with the following steps: