Unable to reverse budget journal after upgrade

Unable to reverse budget journal after upgrade 

+---------------------------------------------------------------------------+
General Ledger: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

GLPREV module: Reverse Journals
+---------------------------------------------------------------------------+

Current system time is 30-JUN-2015 12:17:21

+---------------------------------------------------------------------------+


>> glprgi() 30-JUN-2015 12:17:21

PREV0005: Invalid reversing period Jan-15



<x glprgi() 30-JUN-2015 12:17:21
SHRD0014: GLPREV - process exiting with failure.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size: 
0


Output is not being printed because:
The print option has been disabled for this report.


Finished executing request completion options.


Deleting output file.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 30-JUN-2015 12:17:21

+---------------------------------------------------------------------------+

APPLIES TO:
Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Nov-2013*** 

GLPREV module: Reverse Journals



SYMPTOMS

When attempting to reverse the Posted Budget Journals ,
the following error occurs.

ERROR
-----------------------
Error PREV0005: Invalid reversing period

The steps to reproduce the issue:

The issue can be reproduced at will with the following steps:
1.Create Budget Versions with 6 years duration starting from Current
Financial Year and require journals
2.Open all the 6 years of budget versions
3.Download General Ledgers -Journals Web ADI with Budget Journals - Multiple
Layout
4.Fill 6 years budget and Upload
5.Post all 6 years budget.
6.Reverse all 6 years budget.
7.Only the current year budget can be successfully reverse and the rest of
it fail

The customer has received the following error while running GLPREV module:
Reverse Journals for six years in advance :
PREV0005: Invalid reversing period APR-20xx
The error occurs in glprev.lpc

CAUSE

This works fine if the periods have status of Open or Future enterable.
For budget journals, the program, GLPREV is checking for open or future status for reversal period causing the error. These periods has a status of 'Never Opened' causing, Error PREV0005: Invalid reversing period.

SOLUTION

To implement the solution, please execute the following steps::

1. Download and review the readme and pre-requisites for the relevant patch to get on the latest version of the code.

For 12.0.x apply Patch:13400286:R12.GL.A
Note: If a password is required to download this patch, please open a service request to get the proper password.

For 12.1.x apply Patch:11830885:R12.GL.B

2. Apply the patch in a test environment.

3. Follow any post-installation requirements, including stopping and restarting Apache

4. Confirm the following file versions:

For 12.0.x - glprev.lpc 120.26.12000000.11
For 12.1.x - glprev.lpc 120.27.12010000.9

5. Retest the issue. If the issue is resolved, migrate the solution to other environments as appropriate.