EEX 9.1: Expense Report Line Amount Changes If Column Sorting Is Enabled
Last updated on MARCH 16, 2016
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
Expense Report Line amount changes if column sorting is enabled.
- Navigate to create Expense Report page.
- When page opens, click on Customize link on grid border:
- Add Expense Date for Sorting. This is to sort lines by Expense date.
- Create Expense Report from several lines. The test used was for 12 lines. 11 lines were in different Transaction Currency than Base Currency.
- Submit the transaction for approval.
- Manager Sign on to approve the Expense Report.
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
Two lines from those created in this expense report having different amount by one decimal places that was created by the user. As shown below line with amount 747.44 and line with amount 99.90 in user view are shown in approval page as : 747.43 and 99.91. But when return to user to view the transaction lines, then these two lines are seen as user entry amounts.
When this transaction is selected for payment,then the amounts seen by the approver were the ones to be paid.
This issue does not occur if sort by expense date was removed.
Expense Type Expense Date Amount Spent Currency Exchange Rate Dflt Reimburse Amt Currency Code
Postage 2/5/2015 30.00 EUR 4.9828941 Y 149.49 USD
Postage 2/5/2015 150.00 USD 1 Y 150.00 USD
Postage 2/4/2015 1,251.00 EUR 4.9828941 Y 6,233.60 USD
Postage 2/3/2015 150.00 EUR 4.9828941 Y 747.44 USD
Gratuity 2/6/2015 15.32 EUR 4.9828941 Y 76.34 USD
Gratuity 2/6/2015 14.15 EUR 4.9828941 Y 70.51 USD
Gratuity 2/6/2015 20.05 EUR 4.9828941 Y 99.90 USD
Gratuity 2/6/2015 35.66 EUR 4.9828941 Y 177.69 USD
Gratuity 2/7/2015 12.23 EUR 4.9828941 Y 60.94 USD
Gratuity 2/7/2015 35.99 EUR 4.9828941 Y 179.33 USD
Gratuity 2/7/2015 9.01 EUR 4.9828941 Y 44.90 USD
Gratuity 2/7/2015 4.62 EUR 4.9828941 Y 23.02 USD
As received: Audit has raised concerns that why line base amounts are different than what user is submitting and what approver is approving. The workaround proposed : (Remove Sorting by Expense date, Create expense report, no amount change between user view ER and approver Approve transaction occur) is not applicable.
As there are huge number of users for this system, and this is PeopleSoft feature to allow user see transactions (expense lines) in sorted order. It cannot be suggested to the Users to disable the sorting.
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