My Oracle Support Banner

EGL: If The Book Code Override Is Unchecked For An Account And An Invalid Book Code Is Entered For It On The Spreadsheet, The Book Code Is Changed To The Default Book Code Without Warning. (Doc ID 1530816.1)

Last updated on JULY 15, 2021

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 SP1 and later
Information in this document applies to any platform.

Symptoms

On :  9.1 version, Spreadsheet Journal Entry

ACTUAL BEHAVIOR  
---------------
If the book code override is unchecked for an account and an invalid book code is entered for it on the spreadsheet,  the book code is changed to the default book code without warning once journal is imported to the Peoplesoft system.


EXPECTED BEHAVIOR
-----------------------
If the book code override is unchecked and an invalid book code is entered for the account on the spreadsheet:
- an error should be displayed "invalid book code/account combination" (this should occur at the same time an error is displayed for an invalid value)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a spreadsheet journal with lines balanced on the book code.
    >> concerned account has "Book Code Override" unchecked.
    >> concerned journal has lines with book code other than the default book code.
2. Run journal import.
3. Review journal and noted that book code is updated to the default value for the account with "Book Code Override" unchecked and having invalid book code entered on the spreadsheet journal.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot easily identify the changed book code and then ensure journal is balanced on the book code.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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