Lockbox exceptions table + audit info
Summary:
Hi team, I see a lockbox file loaded successfully into Oracle AR as per the following process ID confirmation email:
Job ID : 12425322, Job Name : Process Receipts through Lockbox, File Name : W_AR_IB_****-919220_2024061205362763.csv, Status : SUCCEEDED
I also confirmed there is a result of running the following script and rows exist:
select * from ar_transmissions_all where TRANSMISSION_NAME='919220_2024061205362763'
However when I check to see the receipts loaded which were in this file, they are not in Oracle, so I think someone might have deleted them.
select * from AR_PAYMENTS_INTERFACE_ALL where transmission_request_id=12425317
0