EEX 9.0+: Expense Location Amount Exception Comments Field (EE_LOCAMT_COMMENT) Not Displayed For Per Diem Expense Line (Doc ID 1681378.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

Issue:

Having selected the 'Override Per Diem' and 'Override Authorized Amounts' flags at the Expenses Definition Business Unit level, it is assumed that while Location Amounts and Per Diem Amounts may be defined in the system, the Business authorizes the Employees to create Expense Report Lines with greater Transaction Amounts if needed, and enable them to submit the transaction for approval provided that a proper justification is entered into the Location Amount Exception Comments field. These exception comments will be reviewed by the approvers, who in their turn will approve/correct/deny the transaction as needed.

However, a problem has been detected with this functionality, should the Employee have linked in their Expenses Profile an Expenses Role. If such Role has any configuration at the 'Expense Role Exceptions' with an Effective Date and Active Status, even if no Expense Type rows have been defined, the Expense Report Entry component will no longer display the EE_LOCAMT_COMMENT Field (Location Amount Exception Comment). This prevents the user from successfully Check Expense For Errors, Save For Later, or Submit For Approval an Expense Report with an entered Transaction Amount greater than the Location Amount or Per Diem Amount defined in the system.

Seems that this problem could have been introduced by the fix on <Bug 11558219> (EX: Location Comments Got Removed When Click On Additional Attendees), delivered in PeopleSoft Enterprise FSCM 9.0 ESA Bundle #24.

Replication Steps:

 - Log into the FSCM Online Application as User ID VP1
 - Navigate to: Set Up Financials/Supply Chain > Install > Installation Options > Expenses
 - Make sure that the 'Allow Overage Accounting' flag is not selected
 - Navigate to: Set Up Financials/Supply Chain > Business Unit Related > Expenses > Expenses Definition
 - Open the existing configuration for GL Business Unit US001
 - In the 'Business Unit 1' tab, make sure to select the flags of:
      - Override Authorized Amounts = Y
      - Override Per Diem = Y
 - Navigate to: Travel and Expenses > Manage Employee Information > Update Profile
 - Open the Expenses Profile from existing Employee ID KU0021
 - At the 'Organizational Data' tab, make sure the below values are configured properly:
      - GL Unit = US001
      - Department ID = 13000
      - Supervisor ID = KU0005
      - Expense Processing Role = Regular Employee
 - Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Purchase > Expense Type
 - Open the existing Expense Type ID PDIEMDY
 - In the 'Expense Types 1' tab, make sure to select the below values:
      - Location = Y
      - Expense Type Edit = Per Diem
      - Rate Retrieval Table = Per Diem Table
 - Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Per Diem Range
 - Open the existing Range ID DAYS under Set ID SHARE
 - Add a new row for Country ID USA
 - Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Per Diem Amount
 - Create a brand new ^Per Diem Amount entry with the following data:
      - Set ID = SHARE
      - Expense Type = PDIEMDY
      - Country Code = USA
      - Currency Code = USD
      - Range ID = DAYS
      - Location = NYMAN
      - All Amounts at 120.00 USD
 - Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Management > Expense Role Exceptions
 - Open the existing configuration for Expense Role EMP
 - Make sure that there is a row with:
      - Effective Date = January 1st 1900
      - Status = Active
      - Role Exception Setup row all in blank
 - Log into the FSCM Online Application as User ID EXA1
 - Navigate to: Employee Self-Service > Travel and Expense Center > Expense Report > Create
 - Select Employee ID KU0021, and click on ADD button
 - Enter the below listed values:
      - Description = GCS Location Amount Test
      - Business Purpose = Consulting Services
      - Default Location = NYMAN
      - Expense Type = PDIEMDY
      - Expense Date = May 26th 2014
      - Amount Spent = 300
      - Currency = USD
      - Payment Type = Cash
      - Billing Type = Internal
 - Click on the 'Detail' link at the Expense Line level
 - At the Expense Report Line Detail page, add the below further values:
      - Per Diem Range = 0 - 2 Days
      - Description = GCS Test
 - Click on the 'Check Expense For Errors' button, or 'Save For Later' Button, or 'Submit For Approval' Button
 

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.

Actual Result:

- The system flags the Expense Line in Error, and displays an Error Message, with no option to enter an Exception Comment for Location Amount functionality
 " Please enter or update the following information:
   Amount Spent -- Amount cannot be greater than authorized amount of 120.00. "

Expected Result:

The system should perform the necessary validations, and if it detects a Transaction Amount greater than the authorized Per Diem Amount for the location affected, should the 'Override Per Diem' flag be properly selected at the Expenses Definition Business Unit level, the system should ask the user to enter a justification in the Location Amount Exception Comments field, to allow further submission of the Expense Report for approval.
 

Cause

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