Error In Process 'Social Security Affiliation Report' ORA-03114: Not Connected to ORACLE AFPRSR-Resubmit_Time (Doc ID 2038161.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle HRMS (Mexico) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Social Security

When attempting to process the Social Security Affiliation report
the following error occurs.

ERROR
-----------------------
Program was terminated by signal 9

Shutting down Concurrent Manager : 21-JUL-2015 18:33:31
ORA-03114: not connected to ORACLE

ORACLE error 3114 in AFPRSR-Resubmit_Time

Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Social Security Archiver
2. Run the Social Security Affiliation Report
3. Report is not generating the expected files as it is ending in error


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