My Oracle Support Banner

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

Last updated on APRIL 04, 2025

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
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() <DATE TIME>>>
>>SHRD0018: Oracle database error trapped at function: GLPRGI - label: glprgi_err>>
>>ORA-00060: deadlock detected while waiting for resource>>
>> >>
>><x glprgi() <DATE TIME>>>
>>SHRD0014: GLPREV - process exiting with failure.>>
>>
>><x glprev() <DATE TIME>>>
>>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.

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!

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