GL Balances Corruption Fix Script
---------------------------------
The GL Balances Corruption Fix script allows customers to safely detect
and/or fix corrupt actual balance data in their gl_balances table. It
is intended to resolve balance issues introduced through sql*plus updates,
concurrency problems, account type changes, retained earnings account
changes, or any other issue that would require fixes in the gl_balances
table.
This version of the GL Balances Corruption Fix script is designed for
release 11.5 only. It works for version 11.5.1 through 11.5.10 CU2 of
applications. If you have an 11.5 version of applications after
11.5.10 CU2, then please check on metalink to verify that this script
is appropriate for your release. This script is not intended to work
with release 11.0, release 12.0, release 10.7, or any other release of
Oracle Applications other than release 11.5.
The GL Balances Corruption Fix script is not intended to diagnose the
cause of the corruption. If such diagnosis is necessary, it is strongly
recommended that it either be done before using this script to fix
balances, or that the backup of the gl_balances table made before running
this script be retained until after the root cause analysis is completed.
When this script is used to fix balances in the gl_balances table, it
updates the table in such a way that data necessary to diagnose the
cause of the problem may be overwritten or lost.
The GL Balances Corruption Fix script assumes that your journal entry
information is accurate. In its detection of balance corruption, it
compares the gl_balances table with your journal entries tables, and
reports any discrepancies. In its correction of balance corruption, it
fixes the gl_balances table to match the information in your journal
entries tables. If it is suspected that your journal entry information
is incorrect or incomplete, then any problems with your journal entry
information should be resolved before running this script, to avoid
having the problems propagated into the gl_balances table.
The GL Balances Corruption Fix script assumes that your summary template
account hierarchies are accurate. When fixing balance corruption, it
makes fixes to any summary accounts based upon the associated detail
account fixes and the current account hierarchy. If your current
account hierarchy is inaccurate or if your summary accounts have
balances inconsistent with the detail balances, then the issue needs to
be resolved separately, generally by dropping and recreating the summary
template.
The GL Balances Corruption Fix script only fixes issues in the
gl_balances table. It does not fix issues in gl_daily_balances, in
gl_code_combinations, in gl_period_statuses, in gl_je_batches,
in gl_je_headers, in gl_je_lines, in gl_account_hierarchies, etc.
Before running the GL Balance Corruption Fix script to fix gl_balances
data, you should backup your gl_balances table. You should also make
sure that the following Oracle General Ledger concurrent programs
are prevented from running while the script is running: Posting,
Open Period, Translation, Add/Delete Summary Templates, and
Program - Incremental Add/Delete Summary Templates. These programs
can be safely run for sets of books other than the one being
corrected, but it is generally easier and safer to block them out
completely. Note that many programs submit Posting, so it isn't
sufficient to just prevent access to the Post Journals form. Backing
up the gl_balances table and blocking out the concurrent programs is
unnecessary if you are only running the GL Balances Corruption Fix
script in report only mode, and are not asking it to fix any
corruption found.
You should prevent users from reserving funds while the GL Balance
Corruption Fix script is running. Funds reservation done while the GL
Balance Corruption Fix script is running may be inaccurate, and may
allow funds to be overspent.
The GL Balances Corruption Fix script can safely be run without the
assistance of Oracle Support Services. However, we recommend involving
Oracle Support Services in any corruption fix that necessitates using
the GL Balances Corruption Fix script, especially if it is the first
time you have used the script.
Note that the performance of the GL Balances Corruption Fix script
depends upon both the number of balances to be verified as well as
the number of balances to be fixed. Even if there is no or minimal
data that needs to be fixed, the script may take a long time to run
if run for a large range of accounts or a large number of periods.
To improve performance, please make sure that your GL schema has
been analyzed shortly before running this script.
If you need to kill the GL Balances Corruption Fix script, it can be
done safely. All of the work done will be rolled back.
Types of Corruption Resolved
----------------------------
The GL Balances Corruption Fix script is designed to fix all types
of corruption encountered in the gl_balances table. Specifically,
it can detect and fix the following:
(The text in parenthesis is the text that shows up in the report
when this problem is detected.)
1. Period to Date Balances (Bad PTD Amount)
The GL Balances Corruption Fix script verifies that your period
to date balances match your posted journal lines. It checks
and fixes your foreign entered, functional, and statistical
actual period to date balances.
2. Quarter to Date Balances (Bad QTD Amount)
The GL Balances Corruption Fix script verifies that your
opening quarter to date balances match the closing quarter to
date balances for the prior period, assuming it is in the
same quarter. Note that this check checks opening balances,
not the total quarter to date balance. The period to date
portion of the total quarter to date balance is checked by the
period to date balances check above. The script checks and
fixes your foreign entered, functional, and statistical
actual opening quarter to date balances.
3. Year to Date Balances (Bad YTD Amount)
The GL Balances Corruption Fix script verifies that your
opening year to date balances match the closing year to
date balances for the prior period, assuming it is in the
same year or is a balance sheet account. Note that this
check checks opening balances, not the total year to date
balance. The period to date portion of the total year to
date balance is checked by the period to date balances check
above. The script checks and fixes your foreign entered,
functional, and statistical actual opening year to date balances.
4. Retained Earnings Balances (Bad YTD Amount)
The GL Balances Corruption Fix script verifies that your retained
earnings opening balances are correct at the beginning of each year,
given your retained earnings ending balances for the prior year
and the balances of your income statement accounts at the end of
the prior year. It checks and fixes your foreign entered,
functional, and statistical actual retained earnings balances.
Note that retained earnings balances are only checked if the
account range specified when running the GL Balances Corruption
Fix script either contains the retained earnings account or contains
an income statement account.
5. Project to Date Balances (Bad PJTD Amount)
The GL Balances Corruption Fix script verifies that your
opening project to date balances match the closing project to
date balances for the prior period. Note that this check checks
opening balances, not the total project to date balance. The
period to date portion of the total project to date balance
is checked by the period to date balances check above. The
script checks and fixes your foreign entered, functional,
and statistical actual opening project to date balances.
6. Duplicate Balances (Duplicate Row)
The GL Balances Corruption Fix script checks for actual rows that
violate the primary key of the gl_balances table, by having
the same values for all of the columns in the primary key as
some other row. It deletes all but one of these duplicates. If
necessary, it will then correct the balances of the remaining row.
Note that the GL Balances Corruption Fix script, when run
in report only mode, may produce unusual output in the report
when it encounters duplicates. It will report the duplicates
correctly, but if one or both of the duplicates have other
problems, say if they have incorrect period to date balances,
then these problems will also be reported. If both duplicates
have the problem, then the problem will be reported twice. If
one duplicate has the problem, then it will be reported once
even though the other duplicate doesn't have the problem.
Also, if the duplicates are for an income statement account, then
the retained earnings calculation may double count the
contribution of that account for the purposes of the report.
When the GL Balance Corruption Fix script is run to fix balances,
not just report on them, then these problems shouldn't occur. All
but one of the duplicates will be deleted before the rest of the
analysis occurs, so the retained earnings calculations will be
correct. If the duplicate row that was retained has other
problems, for example an incorrect period to date balance, then this
will also be corrected and reported on.
7. Extra Balances (Extra Row)
The GL Balances script checks for actual rows in gl_balances that
are for a period that is not opened, closed, or permanently closed.
It reports on and deletes these rows.
Limitations and Warnings
------------------------
1. The GL Balances Corruption Fix script assumes that your journal entry
information is accurate. In its detection of balance corruption, it
compares the gl_balances table with your journal entries tables, and
reports any discrepancies. In its correction of balance corruption, it
fixes the gl_balances table to match the information in your journal
entries tables. If it is suspected that your journal entry information
is incorrect or incomplete, then any problems with your journal entry
information should be resolved before running this script, to avoid
having the problems being propagated into the gl_balances table.
2. The GL Balances Corruption Fix script assumes that your summary
template account hierarchies are accurate. When fixing balance
corruption, it makes fixes to any summary accounts based upon the
associated detail account fixes and the current account hierarchy.
If your current account hierarchy is inaccurate or if your summary
accounts have balances inconsistent with the detail balances, then
the issue needs to be resolved separately, generally by dropping and
recreating the summary template.
3. The GL Balances Corruption Fix script only works on actual balances.
It does not fix problems with budget or encumbrance balances.
4. The GL Balances Corruption Fix script only fixes issues in the
gl_balances table. It does not fix issues in gl_daily_balances, in
gl_code_combinations, in gl_period_statuses, in gl_je_batches,
in gl_je_headers, in gl_je_lines, in gl_account_hierarchies, etc.
5. The GL Balances Corruption Fix script does not fix daily balances.
Customers who maintain daily balances can run this script, but need
to be aware that it will only fix their gl_balances table, not their
gl_daily_balances table.
6. The GL Balances Corruption Fix script does not maintain budgetary
dr and budgetary cr balances. Customers who use the budgetary
dr and budgetary cr account types cannot use this script. The
script will error out if it detects that the customer is using
budgetary dr and/or budgetary cr account types.
7. The GL Balances Corruption Fix script does not maintain functional
entered balances. Customers who have the maintenance of functional
entered balances turned on (aka who have the
track_entered_func_curr_flag column set to 'Y' in gl_sets_of_books),
cannot use this script. The script will error out if it detects
that the maintenance of entered functional balances is turned on.
8. The GL Balance Corruption Fix script expects that each year has
the same number of periods. If after the specified start period,
some years have more periods than others, the script will error
out.
9. The GL Balances Corruption Fix script cannot be run for the first
period ever defined in your calendar. It can be run for the first
opened period for your set of books, but there must be a period
defined, though potentially not opened, that is before this period.
The script will error out if it is run for the first period in your
calendar.
10. The GL Balances Corruption Fix script cannot be run for periods for
which journals have been purged. The script will error out if it
is run for periods in which journals have been purged.
11. The GL Balances Corruption Fix script cannot be run for periods for
which balances have been purged. It also cannot be run for a
period where the period immediately prior to that period has had
balances purged. The script will error out if it is run for periods
that satisfy these criteria.
12. The GL Balances Corruption Fix script will use the current retained
earnings account defined for your set of books. If you have
changed retained earnings accounts, then the script may move balances
from your old retained earnings account to the current one. The
script will do this for all fiscal years where the period immediately
following the fiscal year (aka the first period of the next year)
is equal to or later than the start period specified when the
script was started.
For example, if your fiscal year starts in January, and you specify
a start period of jan-04 when running the GL Balances Corruption
Fix program, then the balances for 2003, 2004, etc would be moved
to the new retained earnings account, but the balances for 2002,
2001, etc would be left with the old retained earnings account.
13. The GL Balances Corruption Fix script will attempt to retrieve all
retained earnings accounts that have balancing segment values that
fall into the specified account range, even if the balancing
segment value has never been posted to and does not have balances
that need to be fixed. If the appropriate retained earnings
account does not exist, the script will attempt to create it. The
script will fail to run if the account cannot be created. If
the account does exist, it will be used even if it is disabled,
out of date, or secured.
14. The GL Balances Corruption Fix script will use the current account
type for each account. If an account was treated as an income
statement account for some years and a balance sheet account for
others, the balances for the account will be changed to be
consistently treated as the current account type for all of the
years processed by the script. The script will do this for all
fiscal years where the period immediately following the fiscal
year (aka the first period of the next year) is equal to or later
than the start period specified when the script was started.
For example, if your fiscal year starts in January, and you specify
a start period of jan-04 when running the GL Balances Corruption
Fix program, then the balances for 2003, 2004, etc would be moved
to the new account type, but the balances for 2002, 2001, etc
would be left with the old account type.
15. The GL Balances Corruption Fix script doesn't recalculate
translations. After running the script, you may need to rerun
translation to get up to date translated balances.
16. The GL Balances Corruption Fix script will rollback any sql*plus
updates to the gl_balances table that result in actual balances
that don't match journals. It will do this even if the updates
were intentional; for example to seed opening balances. It will
only do this for periods equal to or after the start period
specified when running the script.
Setting up your environment
---------------------------
Before the GL Balances Corruption Fix script can run successfully
against your environment, the objects that it needs need to be
installed in your database. This can be done as follows:
1. Uncompress the provided file.
2. Run glqblfix.sql against your apps account. Glqblfix.sql will
create all of the necessary temporary tables, add any missing
columns to gl_sets_of_books, and will analyze the new tables.
Glqblfix.sql will request the name of your gl account, your
gl password, the name of your apps account, and your apps
password.
Please note that if one or more of the necessary objects already
exists, glqblfix.sql will produce error messages, and then
continue on with the next object. These error messages are expected
and can be ignored.
Example
-------
sqlplus apps/apps @glqblfix.sql
3. Run glublfxs.pls against your apps account. Glublfxs.pls will
create the specification for the gl_balance_fix package.
Glublfxs.pls should not produce any errors when run. If it
produces errors, then you may need to contact Oracle Support
Services to get them resolved.
Example
-------
sqlplus apps/apps @glublfxs.pls
4. Run glublfxb.pls against your apps account. Glublfxb.pls will
create the body for the gl_balance_fix package.
Glublfxb.pls should not produce any errors when run. If it
produces errors, then you may need to contact Oracle Support
Services to get them resolved.
Example
-------
sqlplus apps/apps @glublfxb.pls
5. Verify that the gl_balance_fix package exists in your database
and has successfully compiled.
Running the Script
------------------
To run the GL Balances Corruption Fix script, you need to do the
following:
1. Read this entire document first.
2. Back up your gl_balances table if you are going to use the
script to fix balances, not just to report
3. Take the necessary steps to make sure the Posting,
Open Period, Translation, Add/Delete Summary Templates, and
Program - Incremental Add/Delete Summary Templates programs don't
run while the GL Balances Corruption Fix script is running.
These programs can be safely run for sets of books other
than the one being corrected, but it is generally easier
and safer to block them out completely. Note that many programs
submit Posting, so it isn't sufficient to just prevent access to
the Post Journals form.
4. Take the necessary steps to make sure funds aren't reserved while
the GL Balance Corruption Fix script is running. Funds
reservation done while the GL Balance Corruption Fix script is
running may be inaccurate, and may allow funds to be overspent.
5. The report that results from running this script will be dumped
out to your screen. Make sure that you are running the report
in such a way that you can handle a potentially many page report
with a page width of 132 characters being dumped out to your
screen.
6. Start the script by running it using sql*plus against the apps
account.
sqlplus apps/apps @glbalfix.sql
7. The program will ask you to confirm that you have read this
documentation and have backed up the gl_balances table. Press
*Return* to confirm this.
8. When prompted, enter the name of the set of books for which
balances are to be checked and/or fixed. Note that case
and punctuation is important; you want to enter the name
exactly as it appears in the Set of Books form.
9. When prompted, enter the period to start fixing or checking
balances from. Balances will be checked and/or fixed from this
period through the latest opened period. Balances before this
period will not be checked and/or fixed, though the ending
balances of the period immediately before this one will be used
to verify the opening balances for this period.
10. When prompted, enter the low and high range of accounts that the
program is to run for. You can either leave both of these values
empty, in which case the program will run for all accounts, or you
can specify a low and high account for the range, in which case
only accounts within that range will be processed. If you specify
a value for the low account, you must also specify a value for the
high account, and vica versa. If you specify values for the
low and high accounts, you must specify values for each segment,
as well as the necessary delimiters. For example, you might
specify a value for the low account of 01-000-1100-0000-000 and
a value for the high account of 01-200-2100-0000-ZZZ.
11. When prompted, enter the user name of the user who is executing this
program. This should be the user name as used in logging into
applications. Any inserts or updates on gl_balances will be
stamped with this user.
12. When prompted, enter whether you want to run this script in report
only mode. Entering a value of 'N' runs the report in fix mode,
in which it fixes the balances. Entering any other value for
this parameter will cause the script to run in report only mode.
It will produce a report indicating the problems with the
gl_balances table, but it will not resolve these problems.
13. Once the report runs, review the results.
14. If desired, once the results have been reviewed, run Translation
to do any necessary corrections to your translated balances.
Example Run
-----------
sqlplus apps/apps @glbalfix.sql
SQL*Plus: Release 8.0.6.0.0 - Production on Fri Jun 2 16:06:22 2006
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
This is the GL Balances datafix corruption script. Please review
the documentation thoroughly before running this script. Please
also backup your gl_balances table before running this script
unless you are going to run it in reporting mode only.
Press RETURN to continue.
Set of books: Vision Operations (USA)
Start period: Jan-01
Account range low: 08-000-1000-0000-000
Account range high: 08-000-8000-0000-000
User: OPERATIONS
Report only (Y/N): Y
No bad balances found.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Reviewing the Report
--------------------
When the GL Balances Corruption Fix script has completed, it will
display either 'No bad balances found.' which indicates that it found
no corruption, or it will display an error message if it found an
error (the errors are discussed in a later section), or it will display
a report that indicates the detected balance corruption.
An example of such a report is as follows:
Balance Corruption Fix Results Date: 02-JUN-06 16:34
Page: 1
Set of Books: Vision Operations (USA)
Start Period: Jan-01
Account Low: 08-000-1000-0000-000
Account High: 08-000-8000-0000-000
Account Currency Period Problem
----------------------------------------------------------------- ---------- --------------- -------------------------
New Dr New Cr New Converted Dr New Converted Dr
--------------------------- --------------------------- --------------------------- ---------------------------
Old Dr Old Cr Old Converted Dr Old Converted Dr
--------------------------- --------------------------- --------------------------- ---------------------------
08-000-1110-0000-000 CAD Nov-04 Bad PTD Amount
0.00 0.00 0.00 0.00
0.00 1,000.00 0.00 1,200.00
08-000-1110-0000-000 USD Nov-04 Bad PTD Amount
0.00 0.00
0.00 1,200.00
08-000-5341-0000-000 CAD Nov-04 Bad PTD Amount
0.00 0.00 0.00 0.00
1,000.00 0.00 1,200.00 0.00
08-000-5341-0000-000 USD Nov-04 Bad PTD Amount
0.00 0.00
1,200.00 0.00
The heading of the report gives the set of books, the start period, and
the account range the report was run for, as well as giving the date and
time on which it was run. This information is repeated on each page.
The body of the report details any corruption that was found. It
indicates the account, currency, and period in which the corruption
can be found, the type of corruption, the new (correct) balances and
the old (incorrect) balances.
The types of corruption are Bad PTD Amount, Bad QTD Amount, Bad
YTD Amount, Bad PJTD Amount, Extra Row, and Duplicate Row. They
are described above in the "Type of Corruption Resolved" section.
Note that bad retained earnings opening balances are reported as
Bad YTD Amount corruption.
Note that for QTD, YTD, and PJTD problems, the balances shown are
the opening QTD, YTD, and PJTD balances. They don't include the
current period activity, they only include the QTD, YTD, and PJTD
impact from prior periods.
The converted amount columns are only populated for foreign currency
balances with Bad PTD Amount or Bad YTD Amount corruption.
None of the amount columns are populated for Extra Row and Duplicate
Row corruption.
Note that one problem row is displayed for each problem detected in
each row in gl_balances. However, multiple rows may be in reality
impacted by the same problem. In the above case, a foreign currency
transaction that impacted both the foreign currency (CAD) as well as
the cumulative functional currency (USD) balances was deleted, so both
sets of rows were impacted.
Another example of this would be as follows:
Account Currency Period Problem
----------------------------------------------------------------- ---------- --------------- -------------------------
New Dr New Cr New Converted Dr New Converted Dr
--------------------------- --------------------------- --------------------------- ---------------------------
Old Dr Old Cr Old Converted Dr Old Converted Dr
--------------------------- --------------------------- --------------------------- ---------------------------
08-000-2110-0000-000 USD Nov-04 Bad PTD Amount
0.00 50.00
0.00 0.00
08-000-2110-0000-000 USD Dec-04 Bad QTD Amount
0.00 0.00
0.00 50.00
08-000-2110-0000-000 USD Dec-04 Bad YTD Amount
0.00 0.00
0.00 50.00
08-000-2110-0000-000 USD Dec-04 Bad PJTD Amount
0.00 0.00
0.00 50.00
In this case, the $50.00 amount never made it to the Nov-04 row in
gl_balances, but it did impact the Dec-04 QTD, YTD, and PJTD balances.
So four errors are reported ... first the error that the $50 journal
line in Nov-04 doesn't have corresponding amounts in the gl_balances
table, then the errors that the Dec-04 opening QTD, YTD, and PJTD
balances don't match the Nov-04 ending QTD, YTD, and PJTD balances.
When fixing gl_balances, the GL Balances Corruption Fix script would
net out these two issues, resulting in the Nov-04 PTD Cr balance
being changed to $50.00, while the Dec-04 QTD, YTD, and PJTD
balances would be left alone, since the $50 rollforward from Nov-04
and the -$50 reduction to fix the bad QTD, YTD, and PJTD would net out
to zero.
Errors Reported
---------------
The following errors will be caught and reported by the GL Balances
Corruption Fix script:
Error 1: The set of books name provided isn't a set of books name that
is defined on the system.
This error occurs when the set of books name specified when running
the GL Balances Corruption Fix script doesn't match the name of
any of the set of books defined on the system. If you receive this
error, you may want to check the case and punctuation of the set of
books name you provided. The set of books name should be entered
exactly as it appears in the Set of Books form. The full name should
be entered, not the short name.
Error 2: The set of books has an accounted period type that doesn't
exist in the gl_period_types table.
This error occurs when the set of books specified has an accounted
period type that isn't defined. This sort of data corruption should
never occur. If you see this error message, please contact Oracle
Support Services.
Error 3: The start period provided either doesn't exist, isn't
opened, or has a period number less than 1 or greater than the
maximum number of periods per year
This error occurs when the start period specified when running the
GL Balances Corruption Fix script is not valid in some way. Either
no period with that name has ever been defined for the calendar and
accounted period type of the specified set of books, or the period
hasn't been opened for the specified set of books, or the period
number of the period is less than 1 or greater than the maximum
number of periods per year for the accounted period type of the
specified set of books. If you receive this error, you should
double check the start period name you provided.
Error 4: The latest opened period for this set of books either
doesn't exist, isn't opened, or has a period number less than 1 or
greater than the maximum number of periods per year.
This error occurs when the latest opened period of the specified
set of books is not valid in some way. Either no period with that
name has ever been defined for the calendar and accounted period
type of the specified set of books, or the period hasn't been
opened for the specified set of books, or the period number of the
period is less than 1 or greater than the maximum number of periods
per year for the accounted period type of the specified set of books.
None of these should ever occur. If you see this error message,
please contact Oracle Support Services.
Error 5: The low value provided for the account range is invalid.
This error occurs when an account range is specified, but the low
value of the account range is not valid. If you encounter this
error, check to make sure that values are specified for all segments
and the correct delimiter is used to separate segment values.
Error 6: The high value provided for the account range is invalid.
This error occurs when an account range is specified, but the high
value of the account range is not valid. If you encounter this
error, check to make sure that values are specified for all segments
and the correct delimiter is used to separate segment values.
Error 7: Values were not specified for one or more segments in
the account range.
This error occurs when an account ranges is specified, but values
were not specified for one or more segments. If you specify an
account range, you must specify values for all segments. If you
encounter this error, verify that you have specified low and
high values for all segments.
Error 8: There exist undefined or unopened periods between the
start period and the latest opened period.
This error occurs when there is either an unopened period between
the specified start period and the latest opened period of the
specified set of books, or when one or more periods within this
range are undefined. If you encounter this error, check and make
sure that all period years within this range have periods defined
for period number one through the maximum number of periods per
year for the accounted period type of the specified set of books.
If all such periods are defined, with no gaps or extra periods and
with the correct period type, then check to make sure that they are
all opened, closed, or permanently closed. If you do find a missing
period or one that is not opened, then please contact Oracle Support
Services.
Error 9: There exists a period with an invalid period number
between the start period and the latest opened period.
This error occurs when there is a period between the specified start
period and the latest opened period of the specified set of books
with a period number less than 1 or greater than the maximum number
of periods per year for the accounted period type of the specified
set of books. If you encounter this error, then please look for such
a period. If you do find one, then please contact Oracle Support
Services.
Error 10: The start period is the first period defined in this
calendar.
This error occurs when the specified start period is the very first
period defined in the calendar used by the specified set of books
for the accounted period type used by the specified set of books.
If you encounter this error, then please either choose a later period
as the start period or define a period immediately before this period
in the correct calendar and with the correct period type.
Error 11: Tracking of entered functional currency balances is turned
on.
This error occurs when tracking of entered functional currency
balances is on for the specified set of books. If you encounter
this error, then you will need to use an alternative solution to
detect and fix any balance corruption.
Error 12: Journals have been purged for the start period or for
periods after the start period.
This error occurs when journals have been purged for the specified
start period or for periods after it. If you encounter this error,
you either need to choose a later period as the start period or use
an alternative solution to detect and fix any balance corruption.
Error 13: Your chart of accounts contains budgetary dr or budgetary
cr accounts.
This error occurs when the chart of accounts of the specified set
of books contains accounts with an account type of budgetary dr
or budgetary cr. If you encounter this error, then you will need
to use an alternative solution to detect and fix any balance corruption.
Error 14: Unable to retrieve segment values associated with your
retained earnings ccid 999.
This error occurs when the retained earnings account associated with
your set of books is undefined or invalid. The code combination id
of the retained earnings account that the GL Balances Corruption Fix
script attempted to use is displayed in the error instead of the 999.
If you encounter this error, then you should go into the Set of Books
form and check your retained earnings account definition. You may
need to fix it.
Error 15: Flexfield creation failed with following error:
This error occurs when the GL Balances Corruption Fix script
attempted unsuccessfully to create a retained earnings account.
If you encounter this error, then please review the text of the
attached message, and either resolve the issue, or create all
necessary retained earnings account manually before running the
program again.
Error 16: Balances have been purged for the period immediately
before the start period, for the start period, or for periods after
the start period.
This error occurs when balances have been purged for the specified
start period, for the period immediately before the specified start
period, or for periods after it. If you encounter this error, you
either need to choose a later period as the start period or use an
alternative solution to detect and fix any balance corruption.
Error 17: The user name provided isn't a user name that is defined
on the system.
This error occurs when the user name specified when running
the GL Balances Corruption Fix script doesn't match the name of
any of the users defined on the system. If you receive this
error, you may want to check the case of the user name you provided.
The user name should be entered exactly as it appears in the Users form.
Error 18: The posted status or period for one of your lines doesn't
match the information at batch or journal level.
This error occurs when the posted status or the period for one or
more of your journal lines doesn't match the posted status or the
period of the batch or journal that contains it. If you encounter
this error, please contact Oracle Support Services.
Error 19: There exists an opened period after the latest opened period.
This error occurs when a period after the latest opened period of the
specified set of books has a status of open, closed, or permanently
closed. If you encounter this error, please contact Oracle Support
Services.
Fixing Concurrency Issues
-------------------------
The GL Balances Corruption Fix script should not be run at the same
time as the following programs: Posting, Open Period, Translation,
Add/Delete Summary Templates, and Program - Incremental Add/Delete
Summary Templates. These programs can be safely run at the same
time for sets of books other than the one being corrected, but it
is generally easier and safer to block them out completely.
If one of these programs is accidentally run at the same time as the
GL Balances Corruption Fix script and for the same set of books, then
depending upon which program it was, this can be resolved as follows:
1. Posting
If Posting and the GL Balances Corruption Fix script were accidentally
run at the same time for the same set of books, then rerun the
GL Balances Corruption Fix script for the same set of parameters to
detect and resolve any corruption. Be aware that you may also need
to drop and recreate your summary templates.
2. Open Period
If Open Period and the GL Balances Corruption Fix script were
accidentally run at the same time for the same set of books, then
rerun the GL Balances Corruption Fix script for the same set of
parameters to detect and resolve any corruption. Be aware that
you may also need to drop and recreate your summary templates.
3. Translation
If Translation and the GL Balances Corruption Fix script were
accidentally run at the same time for the same set of books, then
you may need to purge and retranslate balances, starting from the
earliest period modified by both programs.
4. Add/Delete Summary Templates / Program - Incremental Add/Delete
Summary Templates
If Add/Delete Summary Templates or Program - Incremental Add/Delete
Summary Templates and the GL Balances Corruption Fix script were
accidentally run at the same time for the same set of books, then
you should drop and recreate any impacted summary templatessql.
