Worker Fails with ORA-01012: not logged on When Applying Patch

(Doc ID 2129289.1)

Last updated on APRIL 20, 2016

Applies to:

Oracle Human Resources - Version 12.2 and later
Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.

Goal

Problem Statement:

When applying patch, worker job fails with the following error.

Concurrent program returned no reason for failure.
Program exited with error.
ORACLE error 1012 in FDPCLS

Cause: FDPCLS failed due to ORA-01012: not logged on.

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

AD Worker error:
The above program failed with error code 1.
See the AD Worker log file and/or the program log file for details.

 

 

Steps to Reproduce:

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

  1.  Apply patch.
  2.  Worker fails.

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