AP_REMIT BI Publisher
Hello,
We are on Tools Release 8.55.25
Application Release Financials/SCM 9.10.00.000
I have modified AP_REMIT template to include
I am getting additional message however it is breaking on every lines, how can i get the message like this.
Here is the code that was modified AP engine PMT_DISPATCH to capture additional payment message from
Tables
SELECT * FROM PS_PYMNT_VCHR_MSG WHERE PYMNT_MESSAGE_CD ='000017'
SELECT * FROM PS_PYMNT_MSG_TBL WHERE MESSAGE_CD ='000017'
SELECT * FROM PS_PYMNT_MSG_LN WHERE MESSAGE_CD ='000017'
%InsertSelect(RADV_DTL_TAO, PMT_INVOICE_TBL,RADVISE_KEY = C.PMT_ID, REFERENCE_FLD = A.INVOICE_ID, DATE1 = A.INVOICE_DT,