My Oracle Support Banner

EEX 9.1: Record Field PS_EX_TRANS.AIRFARE_RCPT_NBR Always Getting Populated Regardless Of Expense Type Being Airfare Or Not When Uploading Amex Credit Card Transactions Into My Wallet (Doc ID 2291775.1)

Last updated on APRIL 21, 2020

Applies to:

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



When Credit Card Upload AE Program (EX_DATA_LOAD) is used to interface American Express GL1025 credit card flat files into the Expenses My Wallet functionality (Record PS_EX_TRANS), it is assumed that only My Wallet items using the Expense Type of Airfare will be storing the Airfare Ticket Number value in Record Field PS_EX_TRANS.AIRFARE_RCPT_NBR, and not those other expenses that use other Expense Types, such as Hotel, Meals, and alike.

However, it has been detected that if in the flat file to be uploaded there is one Airfare Ticket Number value stored, all My Wallet Expenses Items interfaced on that run will store the same Airfare Ticket Number value, regardless of their Expense Type.


     1.- Have an American Express GL1025 flat file containing several Airfare transactions with an Airfare Ticket Number, and other expenses (using different Expense Types)
     2.- Run the Credit Card Upload process (EX_DATA_LOAD) for American Express GL1025
     3.- Check the resulting data impacted into the My Wallet feature (Record PS_EX_TRANS) and confirm that for all the transactions uploaded, the Field AIRFARE_RCPT_NBR is always populated, regardless of the Expense Type being Airfare or not

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.


Expense transactions that are not using an Expense Type of Airfare, are getting the PS_EX_TRANS.AIRFARE_RCPT_NBR incorrectly populated.


The PS_EX_TRANS.AIRFARE_RCPT_NBR Record Field, or PS_EX_AMEX_STG_ERR.AMX_TICKET_NBR if the transaction gets flagged as invalid/error, should only be populated when appropriate, (Expense Type = Airfare).


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.