My Oracle Support Banner

EEX9.2: Open Transactions For Inactive Employee Grid Inaccurately Shows Zeros For Travel Authorizations (Doc ID 2762330.1)

Last updated on JUNE 17, 2022

Applies to:

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


Open Transactions for Inactive Employee grid inaccurately shows zeros for Travel Authorizations.



The issue can be reproduced at will with the following steps:

  1. Log in with VP1 - Create Travel Authorization;
  2. Upon populating fields, click on Submit Travel Authorization;
  3. Click on OK;
  4. Travel Authorization has been submitted for approval;
  5. Go to Update Profile and inactivate EMPLID KU0021;
  6. Supervisor ID is KU006 (William Scott);
  7. Check WorkCenter- there is no Open Transaction for Inactive Employee yet;
  8. Go to Peopletools/Security/User Profiles/ User Profiles and check for William Scott;
  9. Log in with Supervisor ID MGR1 (William Scott) to approve TA;
  10. Click on Approve for Authorization ID created previously - Successfully approved;
  11. Now link to Open Transactions for Inactive Employee is active;
  12. Travel Authorization is 0 and Total Amount is 0 as well- which is not correct;
  13. Check the table:

SELECT * FROM PS_EX_TAUTH_HDR WHERE EMPLID ='KU0021' The total amount is populated in the table correctly.

For reviewing all the steps from above, please check Replication_File.

NOTE: In 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.