R12: GLPARV Program - Automatic Reversal Fails With Error ORA-00060 When Opening Period For A Ledger Set (Doc ID 812968.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Sep-2013***
Executable:GLPARV - Program - Automatic Reversal


Symptoms

You have submitted 'GLOOAP module: Periods - Open Period' process for your ledger set hence an 'open period' process is triggered in each ledger concurrently. Each of them completes normally.

GLPARV module: Program - Automatic Reversal is triggered similarly upon completion of Open Period. You have noticed that for each ledger the request for this program fails, returning error messages in the logfile:

ERROR
>> glprgi() 23-MAR-2009 17:15:30>>
>>SHRD0018: Oracle database error trapped at function: GLPRGI - label: glprgi_err>>
>>ORA-00060: deadlock detected while waiting for resource>>
>> >>
>><x glprgi() 23-MAR-2009 17:15:33>>
>>SHRD0014: GLPREV - process exiting with failure.>>
>>
>><x glprev() 23-MAR-2009 17:15:33>>
>>SHRD0199: Error calling glprevs_reverse_header( ).>>
>>SHRD0018: Oracle database error trapped at function: GLPRGI - label: glprgi_err>>
> />>>


Note: Autoreversal works fine if the period open process is submitted manually for each ledger.

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