Error "ORA-03113: end-of-file on communication channel" when Generating Accounting Lines (Doc ID 620927.1)

Last updated on AUGUST 12, 2016

Applies to:

PeopleSoft Enterprise SCM Cost Management - Version 8.4 and later
PeopleSoft Enterprise SCM Inventory - Version 8.4 and later
PeopleSoft Enterprise SCM Manufacturing - Version 8.4 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 200758108


Goal

How to resolve the following error which is issued by the 'Set GL Distrib Status' process (CM_GL_ACCTG) called by the Costing process:

* Releases 8.4 to 8.8 SP1: 'Create Accounting Lines' process (CM_ACCTG) (navigation: Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Accounting Line Creation)
* Releases >= 8.8 SP1:     'Cost Accounting Creation' process (CM_CSTACCTG) with the 'Create Accounting Lines' check box selected (navigation: Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation)

SQL Error: ORA-03114: not connected to ORACLE

SQL error. Stmt #: 1355 Error Position: 189 Return: 3113 - ORA-03113: end-of-file on communication channel

Process %1 ABENDED at Step %2.%3.%4 (%5) -- RC = %6 (108,524)
16.59.10 SQL Error: ORA-03114: not connected to ORACLE

Timings written to trace file (/usr/local/pcsys/fscm/appserv/prcs/FSSYS/log_output/AE_CM_GL_ACCTG_167324/AE_CM_GL_ACCTG_167324.AET)

PSAESRV completed service request at 16.59.10 2003-10-21

-- 16.48.52 .(CM_GL_ACCTG.MAIN.Update) (SQL)
UPDATE PS_CM_ACCTG_LINE SET GL_DISTRIB_STATUS = 'N', PROCESS_INSTANCE =
167324 WHERE BUSINESS_UNIT = 'CFC01' AND CM_BOOK = 'FIN' AND
GL_DISTRIB_STATUS = 'H' AND BUDGET_HDR_STATUS = 'V' AND CM_IU_STATUS IN
('B','I','X') AND EXISTS ( SELECT 'X' FROM PS_CM_KK_BCHK_REQ WHERE
PS_CM_KK_BCHK_REQ.OPRID = 'jkrumlau' AND PS_CM_KK_BCHK_REQ.RUN_CNTL_ID =
'jdkcm' AND PS_CM_KK_BCHK_REQ.BUSINESS_UNIT = PS_CM_ACCTG_LINE.BUSINESS_UNIT
AND PS_CM_KK_BCHK_REQ.CM_BOOK = PS_CM_ACCTG_LINE.CM_BOOK AND
PS_CM_KK_BCHK_REQ.PROCESS_FREQUENCY IN ('A','O'))
/
-- Row(s) affected: 0
-- 16.59.10 Process 167324 ABENDED at Step CM_GL_ACCTG.MAIN.Update (Action SQL) -- RC = ?
ROLLBACK
/
-- 16.59.10 SQL Error: ORA-03114: not connected to ORACLE.

 

Solution

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