Financial Management - PSFT (MOSC)

MOSC Banner

Voucher -> Payment detail for Pcard

edited Jul 18, 2015 10:01AM in Financial Management - PSFT (MOSC) 3 commentsAnswered

Hi AP experts.

I'm having problems coming up with SQL that will find payment information(ex. payment date) for PROCARD vouchers paid to JPM.  I tried to join the PYMNT_VCHR_XREF to the PAYMENT_TBL, but I'm coming up with nothing.  I think this is because the PYMNT_ID is blank on the XREF table.  I notice that non-PROCARD(ex. employee reimbursements) have a PYMNT_ID on the XREF and thus the join to the PAYMENT_TBL works to get the payment date.  How is this payment verse to JPM(PCard) handled differently?  Is there a table I'm missing that links PCard vouchers to the payment table?  Note.  I can find

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