Hi @Gene C ,

You can check the following note: General Ledger FAQ for Retained Earnings (REA) (Doc ID 136510.1) :

Section 9. Unable to Open the first period in the next fiscal year because GLOOAP - Open Period fails with SHRD0180 :

During the Open/Close program, the "gloire" process will verify that there is a valid, enabled retained earnings account for each balancing segment value which had any activity during the prior years. The process needs this retained earnings account even if all the transactions for a balancing segment value net to an ending balance of zero.

See Note:1966123.1 for more information.

GLOOAP: Opening First Period of the Year finishes in error SHRD0180: gloire - Performing Action >> Ret CCID which failed Validation, does not exist (Doc ID 363583.1) :

Open Period creates the retained earnings balances for each balancing segment. In the previous year some of the companies (balancing segments) had transactions, but in the new year their segment values were disabled. Because of this Open Period request errors while trying to create balances for retained earnings(RE). The error can be also generated due to Cross Validation Rules preventing the Open Period program to create retained earnings accounts.

The code combination needs to be enabled because there are transactions for these segment values from the RE combination (even in the past). Even reversing the transactions does not resolve the issue since the balances (gl_balances table) will no longer be null values, but zero values (which is not the same and RE will still be needed).

The following sample script can help to identify the problematic code combination id; adjust this one to match your structure, please.
SELECT code_combination_id,
account_type,
start_date_active,
end_date_active,
enabled_flag,
detail_posting_allowed_flag
FROM gl_code_combinations
WHERE segment1 = &segment1
AND segment2 = &segment2
AND segment3 = &segment3
AND segment4 = &segment4
AND segment5 = &segment5
AND segment6 = &segment6
AND segment7 = &segment7;

Follow these steps:

1. You need to consult the log file and check for which values and code combinations the Open Period request is failing
2. General Ledger Responsibility > Setup > Financials > Flexfields > Key > Values > Query for your structure > Enable the required segment values (see the RE account defined in the Ledger/Set of Books and balancing segment values)
3. Check the Cross Validation Rules and Security Rules that may prevent the code combinations from being created
4. Verify Dynamic Insertion is allowed for the chart of accounts (General Ledger Responsibility > Setup > Financials > Flexfields > Key > Segments > Query for your structure and verify the check box for the purpose; else you may pre-create the accounts as needed, manually
5. Run the Open Period program again
6. Should it complete fine this time, verify the balance for the Retained Earnings accounts/code combinations
7. You may disable back the segment values enabled in step2 if needed;you may enable back any Cross Validation Rules and Security Rules that were disabled in step3; you may remove the Dynamic Insertion option if enabled for step4

Thanks and regards,

Anca