Manage autoinvoice lines are not loading in excel only getting lines with exceptions

Summary:

Hi,

In reference to SR 4-0000546195, the Oracle engineer offered a solution to remove interface lines using Manage Autoinvoice lins excel add on.

The issue summary is below:

1. There was a recurring billing sales order. It got cancelled the next day by processing the referenced RMA and selecting the ordered date as the next day
2. I have tested that system automatically deletes the lines from fusion.ra_interface_lines_all table once the above step is done as all future period invoices wait in this table to be billed on their respective transaction date
3. The customer started getting billed after 1.5 years out of no where.