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 Even After Patch 32810935 (Doc ID 2884250.1)

Last updated on JULY 19, 2022

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 Per Diem Table
    - Patch 32810935 is already applied in the system, which addressed the problem raised by <Bug 32994189> - (EX: EXPENSE REPORT TOTAL AMOUNT AND LINE AMOUNT (PER DIEM LOCATION AMOUNT DEFAULTS) GET BLANKED OUT WHEN SECOND ER LINE IS ADDED)


    1.- Log into the FSCM Online Application as User ID VP1
    2.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Purchase > Create Expense Type Codes
    3.- Open existing Expense Type PERDIEM under Set ID SHARE
    4.- Ensure the below settings are defined:
             a) Required Field Description = Y
             b) Required Field Location = Y
             c) Expense Type Edit = Per Diem
             d) Rate Retrieval Table = Per Diem Table
    5.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Define Per Diem Ranges
    6.- For Range ID DAYS, define Country Code USA, and the From Value and To Value fields as needed
    7.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Define Per Diem Amounts
    8.- Configure Government and Active Amounts for the various fields under the following criteria:
             a) Set ID = SHARE
             b) Expense Type = PERDIEM
             c) Country Code = USA
             d) Currency Code = USD
             e) Range ID = DAYS
             f) Range Category = LOCAL
             g) Location = BOSTN
             h) Amounts = 100.00 USD
    9.- Navigate to: Travel and Expenses > Manage Employee Information > Update Employee Detail
    10.- Open existing Employee ID KU0021
    11.- At the User Defaults tab, define the following settings:
             a) Per Diem Range = -2 Days
             b) Billing Ty[e = Internal
             c) Payment Type = CSH
    12.- Log into the FSCM Online Application as User ID EXA1
    13.- Navigate to: Employee Self-Service > Employee Travel and Exp Center > Expense Reports > Create/Modify
    14.- Define Employee ID KU0021, and click on add a new value button
    15.- Proceed to enter all the Expense Report Header fields, including Default Location BOSTN
    16.- At the Expense Report Line level, select the Expense Date, and the Expense Type PERDIEM
    17.- Confirm that the Payment Type, Billing Type, Location, Per Diem Range, and Amount are all properly defaulted
    18.- At this stage, the Total Amount, and Line Amount fields store an expected amount of 100.00 USD
    19.- Click on the + icon to add a second Transaction Line into the existing Expense Report
    20.- ISSUE: While the system has added the second Transaction Line, the Total Amount field has been blanked out, the same as the Expense Report Line Amount to 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 100.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.