My Oracle Support Banner

Lot Costing Process Errors With "FDPSTP failed due to ORA-03113: end-of-file on communication channel" and "APP-FND-01564: ORACLE Error 3114 In AFPGRG" (Doc ID 2946926.1)

Last updated on OCTOBER 09, 2024

Applies to:

Oracle Process Manufacturing Financials - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Lot Costs

When attempting to run the Lot Cost Process,
the following error occurs in the concurrent manger log file for the process.

ERROR
-----------------------
Cause: FDPSTP failed due to ORA-03113: end-of-file on communication channel

The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.A and was execu
APP-FND-01564: ORACLE error 3114 in AFPGRG

Cause: AFPGRG 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 AFPRSR-Resubmit_Time
Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE

The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.
ORA-03114: not connected to ORACLE
Routine AFPPRD has encountered a fatal error. ORA-03114: not connected to ORACLE



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: OPM Financials
2. Navigation: Lot Costs > Lot Cost Process
3. Submit Lot cost process
4. View > Requests, Find Lot Cost Process and View Log
5. View Log file for errors.



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.