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
Last updated on JULY 28, 2017
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).
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