Financial Management - PSFT (MOSC)

MOSC Banner

Invoice date is missing on Remittance advice

edited Oct 27, 2019 5:02AM in Financial Management - PSFT (MOSC) 7 commentsAnswered

We have notice Invoice date is missing on Remittance advice

Steps

----------

1.) Create a Voucher
2.) Post the Voucher
3.) Setting Payment selection criteria
4.) Run Paycycle manager
5.) Select the Invoices for payment
6.) Send Payments for APWIRE( ACH)
7.) Run Payment History By Payment report
8.) Verify the report through Report Manager
9.) Run Import Acknowledgement Files (IMPORT_FILES)
10.) Remittance notification is sent to Vendor & Invoice Date is missing in the remittance file.

The DATE1 field in the XML file is not being populated. 


Data for the DATE1 field for the XML file is taken from the PS_RADV_DTL_TAOx table. The Insert is done in App Engine ONLINE_RADV.RemitAdv.PopDtl (below SQL is from AE_IMPORT_FILES process)

Tagged:

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