Record and report on Spoiled payments?
We are on 12.1.3. Is there a standard report that displays spoiled payment batches? Our AP team uses the Payment Register to report on payments created for SOX compliance.
This payment register is based on ap_checks_all and reports actual checks. Spoiled and voided codes are located in the table IBY_PAYMENTS_ALL.PAYMENT_STATUS. Values for this column can be found here: select * from fnd_lookup_values where lookup_type='IBY_PAYMENT_STATUSES' .
For the following payment_status codes, these payment rows do not appear in ap_checks_all
REJECTED
VOID_BY_OVERFLOW
REMOVED_REQUEST_TERMINATED
REMOVED_DOCUMENT_SPOILED