PRC: Transaction Import PAXTRTRX Ora-20004: Post_import:Ora-00060: Deadlock Detected (Doc ID 1433040.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

OTL retrieval process

Running PAXTRTRX module: PRC: Transaction Import

The following error occurs :

MSG-20004: ORA-20004: post_import:ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 2556
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 8992
ORA-06512: at "APPS.HXC_INTEGRATION_LAYER_V1_GRP", line 875
ORA-06512: at "APPS.PA_OTC_API", line 2438
ORA-04065: not executed, altered or dropped stored procedure "APPS.HXC_TIMECARD_SUMMARY_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.HXC_TIMECARD_SUMMARY_PKG"

 

Changes


Recompilation of a view might lead to inconsistent timestamps for some of the view's PLSQL dependents.

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