EEX9.1: Encumbrances Not Reversed For Rolled Travel Authorizations (Doc ID 2242753.1)

Last updated on MARCH 10, 2017

Applies to:

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

Symptoms

Issue
When a user creates a new Travel Authorization by copying from an existing previously rolled Travel Authorization, the ROLLOVER_STATUS field on the EX_TAUTH_HDR table copies over the value of ‘C’ on the new TA.  This causing the system to believe the new TA has already been rolled over.

Steps:

1) Create budget
2) Create Travel Authorization (TA) and budget check before approval
3) Rollover the Travel Authorization to new budget period

Followed with the following steps.

1. Locate a TA that has already been rolled, or roll an existing approved TA.
2. Navigate to: Main Menu > FSCM > Employee Self Service > Travel and Expense Center >Travel Authorizations > Create/Modify
3. Click Add button
4. Beside Quick Start choose the option for “An Existing Authorization”, and then click Go button
5. Select a TA that has previously been rolled over (has a ROLLOVER_STATUS on EX_TAUTH_HDR of ‘C’)
6. Change dates to be in the future, if needed
7. Click Save for Later button (Authorization ID is generated successfully) - Issue also occurs when submitting instead of saving
8. Run SQL to verify rollover status of new TA – Notice the ROLLOVER_STATUS copied over with a value of ‘C’. This status means it has already been rolled even though this is a new TA that has never been approved or rolled.

Expected Result:
When a user creates a new Travel Authorization by copying from an existing previously rolled Travel Authorization, the ROLLOVER_STATUS field on the EX_TAUTH_HDR table for the new TA should have a value of ‘N’ since no action for rolling over the TA has been completed.

Actual Result: Due to this after the new TA has been fully approved it is not available to rollover since the system believes it has already been rolled.

BUSINESS IMPACT
TA would have to be cancelled requiring the user to create a new one to process through approvals in order to have a TA to associate to their report. This could lead to cases where the travel dates have already past. This creates delays in reimbursement and additional work by customers to create new claims and process again through 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