How to clear records that are causing errors
I am testing the extraction of 810 credits in the eCommerce Gateway and received an error. I want to remove the records from ECE_AR_TRX_HEADERS and ECE_AR_TRX_LINES tables, but don't know how to do so. Is there a screen for these interface tables, or do I need to use SQL commands or PL/SQL to do this?
Cause
Each row in ECE_AR_TRX_HEADERS is purged after the data is written to the data file.
In this case that table was not purged from a previous run of the 810 Outbound (INO)
Solution
1. Remove the records from ECE_AR_TRX_HEADERS and ECE_AR_TRX_LINES table from the previous run.