Friday, June 20, 2014

PSON Number how to Map to Oracle Tables

PSON Number how to Map to Oracle Tables.   From Payments perspecitve, PSON (tangibleid) is the only link between AR and IBY.

You can confirm the receipt number using the PSON by below query

select receipt_number, approval_code
from ar_cash_receipts_all
where payment_server_order_num = '&PSON';

select * from RA_CUSTOMER_TRX_ALL where payment_trxn_extension_id in
(select trxn_extension_id from iby_fndcpt_tx_operations where transactionid in
(select transactionid from iby_trxn_summaries_all where tangibleid = '&PSON' ));