EGL9.1+: Wrong Error (5040,126) is Triggered When Saving Closing Rule After Changing Effective Date.

(Doc ID 1954039.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Closing

When attempting to save a Closing Rule after changing the Closing Rule effective date the following error occurs.

ERROR
-----------------------
Non-overrideable Account XXXXXX: should not retain book code. (5040,126)
Please either choose an overrideable Account or do not retain book code value.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Make sure Book Code is enabled in Overall Installation Options.
  2. Activate several book codes in Account Balancing Group and make one of them default.
  3. Add a new account 360360 using effective date 01/01/2014.
  4. Navigate to General Ledger > Close Ledgers > Closing Rules and add a new closing rule using effective date 01/01/2014.
  5. On tab 'Closing Options' enter chartfield 360000 for Default Retained Earnings and Book Code with Retain Value.
  6. On tab 'Net Income/Retained Earnings' enable ‘Close To Multiple Ret Earnings’, enter a Chartfield Value Set, enter chartfield 360360 (created in step 3) for Retained Earnings and Book Code with Retain Value.
  7. Define Journal Options and Roll Forward Options (Do Not Roll Forward Zero Bal) and save Closing Rule.
  8. Go back to tab ‘Closing Options’, change effective date from 01/01/2014 to 01/01/2013 and save changes.
  9. Wrong message is triggered: Non-overrideable Account 360360: should not retain book code. (5040,126). Please either choose an overrideable Account or do not retain book code value.
  10. System should give an effective date related error.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are confused because the error message is misleading.

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