Production Task - ERS Payables Import – Inactive Tax Code Error

We have a scenario as below.

 

1)     Invoice is not getting generated for  ERS Purchase order due to Inactive Tax code.

2)     Upon research it is found that TAX CODE is active and the tax_id in AP_TAX_CODES_ALL is inactive. We have same TAX_CODE (name) and the tax_id is different due to different tax rate.

3)     The tax_code_id is in AP_INVOICE_LINES_INTERFACE and this is derived from the PO_LINE_LOCATIONS_ALL and TAX_CODE_ID

 

I think we have two options

 

1)     Change the tax_code_id to the active tax code in  AP_INVOICE_LINES_INTERFACE and process to create invoice through Payables Open Import program. By this way, we will have