Payables and Cash Management - EBS (MOSC)

MOSC Banner

Identify Payment transactions in ap_credit_card_trxns_all table for AMEX

Hello,

Background:

By looking at AMEX credit card statements, it was identified that credit card Payments done by employees to AMEX are showing up in ERP iExpense,

when users prepare their exp reports, amex payments trx are visible under credit card transactions tab.

Hence we need to delete those Payment transactions of AMEX credit cards.

So can you pls help on which criteria or Columns of ap_credit_card_trxns_all table , the query should be written so that it ONLY returns the AMEX Payment transactions ??

For sample payment trx , i found below column values in the table :

table :: ap_credit_card_trxns_all

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center