EEX 9.1+: Select All Link From My Reservations Bring All Confirmed And Assigned Transactions Into New Expense Report (Doc ID 2104134.1)

Last updated on FEBRUARY 05, 2016

Applies to:

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

Symptoms

ISSUE:

A bug in the delivered codeline has been detected when an Expenses Employee is defaulting My Reservations transactions into an Expense Report. Even if the Employee in question has no outstanding transactions in the My Reservations main Records, (PS_TV_MYRESV_HDR, PS_TV_MYRESV_LINE, and PS_TV_MYRESV_DETAIL), if the User clicks on the Select All link from the 'Add My Confirmed Reservations' page (TV_ER_RESERVATION), at the time of going back to the Expense Report Entry main page, the system will have defaulted all Confirmed Reservations transactions as Expense Lines, even though they may already be assigned to other Expense Reports, and be fully processed. As long as the Reservations are confirmed, (Record Field PS_TV_MYRESV_LINE.CONFIRM_STATUS = 'C'), all existing transactions from that employee gets incorrectly brought into the Expense Report.

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 to select the checkbox named 'Use Travel Services'
     - Navigate to: Employee Self-Service > Travel and Expense Center > Expense Report > Create
     - Define Employee ID KU0042, and click on ADD button
     - From the Quick Start drop down list, select the option 'Entries from My Reservations'
     - Click on GO button
     - Manually select all listed My Reservations transactions
     - Click on DONE button
     - Back at the Expense Report Entry page, fill in all potential missing values from blank fields, and save the transaction
     - Query the Record PS_TV_MYRESV_LINE for the My Reservations transactions just defaulted, and make sure the below Fields are properly updated:
          - SHEET_ID = Value of the Expense Report just created
          - LINE_NBR = Value of the line number within the Expense Report
          - TXN_STATUS = A
     - Go back to the Homepage
     - Navigate to: Employee Self-Service > Travel and Expense Center > Expense Report > Create
     - Define Employee ID KU0042, and click on ADD button
     - From the Quick Start drop down list, select the option 'Entries from My Reservations'
     - Click on GO button
     - Click on the SELECT ALL link
     - Click on the DONE button
     - Back at the Expense Report Entry page, see how the system has once again defaulted My Reservations transactions that have already been assigned to prior Expense Reports, even though the Add My Confirmed Reservations page (TV_ER_RESERVATION) had nothing being displayed

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.

BUSINESS IMPACT:

This is confusing for the Expenses Employees, as they could see how even though at the 'Add My Confirmed Reservations' page (TV_ER_RESERVATION) there were no outstanding transactions, later on multiple old, confirmed, and already assigned Reservations are being brought over into the new Expense Report. Upon trying to save, diverse red flags are issued, stating that the transactions are already being used, or duplicates exist.

EXPECTED BEHAVIOR:

The My Reservations functionality should only be bringing into a new Expense Report those transactions selected by the Employee, and not those that have already been assigned (Record Field PS_TV_MYRESV_LINE.TXN_STATUS = 'A').

 

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