Hi,
I am wondering if I can review data after every step ? e.g. After import or validation. Is there any screen or report I can run ?
Cheers
Dinesh
bonnerjis - 20 July 2006 02:32 AM
“Process Lockbox” is the main program that fires. It is a ProC program - you can convert it to strings and will be able to see the SQLs behind it
There are 3 steps in the lockbox process -
1. Import -> basically a loader which loads data into ar_payment_interface_all.
2. Validation -> moves the data into ar_interim_cash_receipts_all and ar_interim_cash_recpt_lines_all
3. Post Quick Cash -> moves the data into the AR base tables - AR_CASH_RECEIPTS_ALL, AR_RECEIVABLES_APPLICATIONS_ALL, AR_CASH_RECEIPT_HISTORY_ALL
hope this helps.