My Oracle Support Banner

EEX 9.2: Expense Report Total Amount and Line Amount (Per Diem Location Amount Defaults) Get Blanked Out When Second ER Line Is Added (Doc ID 2794277.1)

Last updated on JULY 23, 2021

Applies to:

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


A problem has been detected at the Expense Report creation level, where Expense Report Total and Line Amount fields get blanked out, and reset back to 0.00, when an additional Expense Report Line is being added online. This is taking place for the below criteria:

    - The Expense Report Line, whose Line Amount is blanked out, is using a Per Diem Expense Type
    - The Expense Type and Location combination use the Location Amount Table
    - This is only happening for GSA Amounts interfaced through CONUS/OCONUS
    - Also, it only is replicable for some Employees, but not all


    1.- Log into the FSCM Online Application as User ID VP1
    2.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Purchase > Expense Type
    3.- Open existing Expense Type LODGING under Set ID SHARE
    4.- Ensure the below settings are defined:
              a) Required Field Merchant = Y
              b) Required Field Location = Y
              c) Expense Type Edit = Per Diem
              d) Rate Retrieval Table = Location Amount Table
    5.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Expense Location Amount
    6.- Open the current configuration under Set ID SHARE, Expense Type LODGING, and Currency Code USD
    7.- Ensure that there is an Active row for Location DALL, with a Data Source of CONUS, and a GSA Amount of 89.00 USD
    8.- Navigate to: Travel and Expenses > Manage Employee Information > Update Profile
    9.- Open delivered Employee ID KUTZ499
    10.- At the Organizational Data tab, ensure the below settings:
              a) Per Diem Amount Type = Active Amounts
              b) GL Unit = US004
              c) Department = 11000
              d) Supervisor ID = KU0042
    11.- Navigate to: Travel and Expenses > Manage Expenses Security > Authorize Expense Users
    12.- Open Employee ID KUTZ499, and add Authorized User ID VP1 with 'Edit & Submit' authorization level
    13.- Navigate to: Employee Self-Service > Travel and Expenses Center > Expense Reports > Create/Modify
    14.- Enter the Employee ID KUTZ499, and click on ADD button
    15.- Define the required Expense Report Header fields (Business Purpose, Description, and Default Location as DALL)
    16.- On the initial Expense Report Line, choose an Expense Date, Expense Type LODGING, Payment Type CSH, enter a Description, and Select a Preferred Merchant
    17.- At this stage, the system has correctly defaulted a value of 89.00 USD to the Expense Report Line Amount field
    18.- Also, confirm that the Expense Report Header Total Amount field has also been calculated to 89.00 USD
    19.- Proceed to click on the + icon, to add a second Transaction Line to the Expense Report at hand
    20.- ISSUE: Confirm that the Expense Report Header Total Amount, and the initial Expense Report Line Amount have been reset from 89.00 USD to a value of 0.00 USD

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.

Users are getting confused because this is resetting to null the Report Total, and Line Amount fields, while at the same time, the Expense Report Line Distribution Accounting row still shows an amount of 89.00 USD. Saving the Expense Report does not trigger any Warnings/Errors for a line with a 0 amount.

When adding a new Expense Report Line, the system should not be blanking out the prior Transaction Line Amount, and hence, affecting the Expense Report Total Amount field as well.


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.




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.