My Oracle Support Banner

EEX 9.2: The Period End Accrual Delete Page Purges All Reversal Accounting Entries from Expense Reports And My Wallet Transactions Outside of Defined Accounting Dates (Doc ID 2759198.1)

Last updated on MARCH 10, 2021

Applies to:

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

Symptoms


After a systems upgrade to PeopleSoft Enterprise FSCM 9.2 Image #36, the Period End Accrual Delete page in Expenses module is purging all Reversal Accounting Entries generated at the first of each following month, regardless of the Accounting Date range defined in the Search Criteria section, and even if those Accounting Entries had not been selected for deletion.

This was working fine prior to the upgrade, but seems that some codeline got modified by the solution created for <Bug 30935761> (EEX9.2:PERIOD END ACCRUAL DELETE FIRST ROW ERROR INVALID ROW NUMBER), and introduced this new problem.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as an System Administrator User
    2.- At the Expenses Definition level for the Business Unit, select the options to Accrue Unprocessed Expenses, as well as My Wallet Entries
    3.- Log into the FSCM Online Application as an Expenses Employee User
    4.- Create a couple of new My Wallet Credit Card transactions for an Employee, and set the Transaction Date to July 15th 2020
    5.- Default one of the My Wallet Transactions into a new Expense Report, and submit it for approval
    6.- Log into the FSCM Online Application as an Expenses Approver User
    7.- Open the submitted Expense Report, modify the Accounting Date to equal the Transaction Date at the Expense Line level, (July 15th 2020), and approve transaction
    8.- Log into the FSCM Online Application as an Expenses Administrator User
    9.- Launch the Period End Accrual Processing program for the Expenses Business Unit, and Accounting Date of July 31st 2020
    10.- Launch the Period End Accrual Processing program for the Expenses Business Unit, and Accounting Date of August 31st 2020
    11.- Launch the Period End Accrual Processing program for the Expenses Business Unit, and Accounting Date of September 30th 2020
    12.- Launch the Period End Accrual Processing program for the Expenses Business Unit, and Accounting Date of October 31st 2020
    13.- At this stage, Period End Accrual Accounting Entries for both Expense Report, and My Wallet transactions have been generated for the below dates:
              - Period End Accruals for July 31st 2020, and its respective Reversal dated on August 1st 2020
              - Period End Accruals for August 31st 2020, and its respective Reversal dated on September 1st 2020
              - Period End Accruals for September 30th 2020, and its respective Reversal dated on October 1st 2020
              - Period End Accruals for October 31st 2020, and its respective Reversal dated on November 1st 2020
    14.- Now, go to the Period End Accrual Delete page, and define the search criteria below:
              - Expenses Document Type = (Leave blank)
              - Employee Business Unit = (Business Unit value of the Employee that created Expense Report, and My Wallet transactions)
              - Accounting Date From = October 31st 2020
              - Accounting Date To = (Blank)
    15.- Click on the SEARCH button
    16.- This displays the Period End Accruals, and respective Reversals, for both the Expense Report and My Wallet transactions, dated from October 31st 2020, and November 1st 2020 (Reversals)
    17.- Select the Accounting Entries for both transactions
    18.- Click on the DELETE button
    19.- The system should delete the Period End Accrual Accounting Entries for Expense Report, and My Wallet transactions, dated from October 31st 2020, and their respective Reversals from November 1st 2020
    20.- ISSUE: On top of that though, the system has also deleted the Reversal Period End Accrual Accounting Entries for all periods outside of the Accounting Date range selected (August 1st 2020, September 1st 2020, October 1st 2020 Reversals have also been wrongfully deleted)

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

By deleting the Reversal Accounting Entries from all prior periods, the Period End Accrual Accounting Entries at the end of the month are no longer being balanced. Even further, those old Reversal Accounting Entries may have already been interfaced into the General Ledger, with Journal Entries posted into the Ledger, leaving now those GL Entries orphan.

The functionality behind the Period End Accrual Delete page should only delete those Accounting Entries manually selected from the search list, nothing else.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.