EEX 9.1: Expense Report Line Amount Changes If Column Sorting Is Enabled

(Doc ID 2079821.1)

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