<h2 class="km">Applies to: 
</h2>Oracle Payables - Version: 11.5.10 to 12.1.1 
<br/>This problem can occur on any platform. 
<br/>
<h2 class="km"><a name="SYMPTOM"></a>Symptoms 
</h2>
<br/>One of the invoice is stuck with 'PROCESSING' status in ap_invoices_interface. 
<br/>But ,the same invoice number is in the base table i.e. already showing imported. 
<br/>
<br/>6 invoice lines related to the same invoice are still in ap_invoice_lines_interface table. 
<br/>and remaining 7 invoice lines were passed to base table means got imported. 
<br/>
<br/>EXPECTED BEHAVIOR 
<br/>The import should be successful for the invoice and invoice lines with status 'PROCESSED' in 
<br/>in interface table ap_invoices_interface. 
<br/>
<br/>STEPS 
<br/>The issue can be reproduced at will with the following steps: 
<br/>1. Run payables open interface import program 
<br/>
<br/>BUSINESS IMPACT 
<br/>The issue has the following business impact: 
<br/>Due to this issue, users cannot see the complete invoice data in to base tables after importing. 
<br/>
<br/>
<br/>
<h2 class="km"><a name="CAUSE"></a>Cause 
</h2>The cause of the issue is invalid / incorrect data in ap_invoices_interface and 
<br/>ap_invoice_lines_interface. 
<br/>The data should not be struck in the interface tables with 'PROCESSING' status. 
<br/>
<br/>
<br/>From&nbsp; payables user guide and ap trm file it clearly states that, the interface data should be 
<br/>in 'PROCESSED' status when it is imported to base tables. 
<br/>
<br/>But, here the invoice data in interface table showing as , status = 'PROCESSING'. 
<br/>
<br/>
<br/>
<h2 class="km"><a name="FIX"></a>Solution 
</h2>
<p>1. Go to payables responsibility. 
	<br/>2. Invoices ---&gt; Open Interface Invoices ---&gt; Query for the problem invoice. 
</p>
<p>3. Change Status from 'PROCESSING' TO 'PROCESSED'. 
	<br/>4. Save. 
	<br/>5. Click on 'Lines' tab. 
	<br/>6. Delete these remaining invoice lines which were not imported.&nbsp;&nbsp;( By click on invoice line&nbsp; ---&gt; select ' Edit ' from upper menu --&gt; Delete). 
	<br/>7. Save. 
	<br/>8. Open the same invoice in invoice workbench. 
	<br/>9. Query for the invoice (F11 + enter query + Ctrl F11). 
	<br/>10. Go to 'Lines ' tab . 
	<br/>11. Create the invoice lines and distributions for the same. 
	<br/>12. Save. 
	<br/>
	<br/>
	<br/>Another way , is : 
	<br/>1. Cancel the invoice which already imported. 
	<br/>2. Stamp or update the status in the invoice header data to NULL or REJECTED. 
	<br/>3. Try to reimport the same. 
	<br/>4. After, this check whether import is successful or not . 
</p>