My Oracle Support Banner

EEX 9.2: Expense Report Containing Prepaid Expenses Displays Incorrect Total Amount Values When Save For Later Or Submitting For Approval (Doc ID 2613443.1)

Last updated on APRIL 21, 2021

Applies to:

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


When adding prepaid expense lines to an Expense Report, at the time of saving the transaction, submitting it for approval, and reviewing it during approvals, several Total Amount fields are incorrectly being calculated:

    - Expense Report Total (At the Expense Report creation page)
    - Employee Expenses
    - Amount Due to Company
    - Total Amount (At the Approve Transactions page)

These incorrect calculations of amounts seem to resolve themselves once the transaction is closed, and re-opened. It only takes place when the transaction is being created, and submitted.


    1.- Log into the FSCM Online Application as an Expenses User
    2.- Create a brand new Expense Report, with two Expense Line using Payment Type Prepaid
    3.- Save For Later the newly created Expense Report, and see how the Total field is calculated at 0.00 USD
    4.- Click on Summary & Submit link
    5.- Click on Submit for approval
    6.- Log into the FSCM Online Application as an Expenses Approver User
    7.- Open the routed Expense Report, add a comment, and Send Back For Revision
    8.- Log into the FSCM Online Application as an Expenses User
    9.- Open the returned Expense Report, and add a new Expense Line, again using Payment Type Prepaid, and Save For Later
    10.- Confirm that the Total field is again wrongly calculated, completely disregarding the new line's amount
    11.- Click on the Summary & Submit link
    12.- Note that at this stage, from the Totals section, two fields are wrongly calculated:
            a) Employee Expenses is listing all existing lines (3), but the amount is only counting the original 2
            b) Amount Due to Company shows the amount of the latest 3 prepaid line, while it should be: Amount Due to Employee = 0.00 USD
    13.- Submit the Expense Report once again for Approval
    14.- Log into the FSCM Online Application as an Expenses Approver User
    15.- At the Approve Transactions Overall page, the routed Expense Report is displayed, but the Total column shows an amount equal to the sum of the first 2 prepaid lines, not including the 3rd line's amount

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.

Due to this problem, Expense Employees get very confused when creating the Expense Report containing prepaid expense lines, as the amounts do not reflect the expected values. The same happens for the Expense Approver Users, who get displayed incorrect amounts when reviewing the routed transactions. This makes it complicated to streamline Expense Report approvals, as Users keep having doubts on the transaction's displayed/calculated amounts.

Whenever prepaid Expense Lines are included within an Expense Report, the system should be able to calculate at all times the Total fields, with the correct amounts.

NOTE: In 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.




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

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