# AutoInvoice import fails with invalid line/header exceptions > Source: https://netray.co/erp-help/ebs-autoinvoice-import-invalid-line-exceptions-fix > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer AutoInvoice rejects lines when the interface data references an invalid or inactive customer, transaction type, GL date outside an open period, currency, or accounting flexfield combination. The AutoInvoice Execution Report and RA_INTERFACE_ERRORS_ALL tell you exactly which interface line and which field failed validation, so start there rather than guessing at the source system feed. ## Kind error ## System oracle-ebs ## Erp Oracle E-Business Suite (Receivables) ## Module Receivables / AutoInvoice ## Query AutoInvoice import failed invalid line exceptions in RA_INTERFACE_ERRORS_ALL ## Alternate Queries - AutoInvoice validation errors fix - EBS AutoInvoice invalid line exceptions - AutoInvoice Execution Report showing rejected lines ## Applies To Oracle E-Business Suite R12.1 and R12.2 Receivables AutoInvoice (also relevant to 11i) ## Steps ### Diagnose and resolve AutoInvoice exceptions **Items:** Open the AutoInvoice Execution Report from the concurrent request output - it lists every rejected line grouped by exception type in plain English, not just an error code. Query RA_INTERFACE_ERRORS_ALL joined to RA_INTERFACE_LINES_ALL on interface_line_id to see the exact invalid value alongside the source line data that was fed into the interface. For 'Invalid Line - GL Date' errors, confirm the GL date on the interface record falls inside an Open Receivables period; close-period timing between source systems and Receivables is the most common cause. For 'Invalid Line - Bill To Customer' or 'Ship To Customer' errors, confirm the customer/site is Active and not end-dated as of the transaction date in Customers > Standard. For 'Invalid Line - Currency Code' or amount mismatches, confirm the currency is enabled for the operating unit and that line amounts reconcile to quantity times unit selling price within rounding tolerance. For transaction type or batch source errors, confirm the Transaction Type and Batch Source referenced by the interface record are active and correctly tied to the Receivables Transaction Source setup. Correct the source data (either directly in the interface tables for a one-off fix, or in the feeding system for a recurring issue), then resubmit AutoInvoice for just the failed batch source and request ID range. ## Sections ### Where AutoInvoice validation actually happens **Body:** AutoInvoice is a two-stage process: the Interface program (RAXTRX) validates every row in RA_INTERFACE_LINES_ALL against Receivables setup (customers, GL periods, transaction types, flexfields, tax) before it will create AR_INVOICES or the equivalent transaction rows, and anything that fails validation is written to RA_INTERFACE_ERRORS_ALL with a specific rejection reason rather than silently dropped. Because the validation is comprehensive, most 'AutoInvoice failed' tickets are actually setup or master-data problems in the feeding system - an inactive customer site, a GL date that slipped past period close, or a tax code that was end-dated - rather than a bug in AutoInvoice itself. **Code:** SELECT rie.interface_line_id, rie.invalid_value, rie.message_text, ril.customer_trx_id, ril.gl_date, ril.line_type FROM ra_interface_errors_all rie, ra_interface_lines_all ril WHERE rie.interface_line_id = ril.interface_line_id AND ril.request_id = &request_id; ### Header versus line exceptions **Body:** AutoInvoice distinguishes header-level failures (customer, bill-to site, transaction type, currency) from line-level failures (item, revenue account, tax, freight), and a single header exception cascades to reject every line under it, which is why one bad customer record can make an entire batch of otherwise valid invoices disappear from the output. Always check the header exceptions first before chasing individual line errors - fixing the customer or transaction type issue at the header often clears most of the batch in one pass. ### Rerunning without duplicating good lines **Body:** AutoInvoice supports resubmitting just the rejected interface lines by request ID, so there is no need to reprocess the whole batch source once the underlying data is fixed - use the same Batch Source and GL Date range parameters, and Receivables will skip lines already successfully imported. For recurring feeds from an external order or billing system, add the same validations AutoInvoice performs (active customer, open period, valid transaction type) at the source before the data ever reaches the interface tables, which cuts the exception volume dramatically over time. ## Pitfalls - Fixing the interface table row directly without also fixing the source system, so the same exception recurs on the next feed. - Not checking header-level exceptions first, wasting time on line-level errors that will disappear once the header issue is fixed. - Resubmitting the entire batch source instead of just the failed request ID range, which risks reprocessing already-imported lines. - Ignoring that the GL date validation is against the Receivables (not General Ledger) open period status specifically. - Assuming a rejected line is a bug rather than checking Customers, Transaction Types, and Tax setup for an end-dated or inactive record first. ## Ai Angle ERPray can be pointed at RA_INTERFACE_ERRORS_ALL for a given request ID and translate the raw exception rows into a plain-language summary grouped by root cause - inactive customer, closed period, bad tax code - so AR staff fix the actual setup problem once instead of triaging dozens of individually confusing line-level messages. ## Faq ### Why did AutoInvoice reject lines that worked fine yesterday? **Answer:** Most commonly a period closed between when the source data was extracted and when AutoInvoice ran, or a customer/site was end-dated or made inactive in the interim. Check the GL date and customer status first. ### Can I fix and resubmit only the failed lines? **Answer:** Yes. Correct the RA_INTERFACE_LINES_ALL data for the rejected rows (or fix upstream and re-feed), then resubmit AutoInvoice for the same batch source and request ID/date range - already-imported lines are not reprocessed. ### What is the difference between a header and a line exception? **Answer:** Header exceptions relate to the transaction as a whole (customer, transaction type, currency) and reject every line beneath them; line exceptions relate to individual line data (item, account, tax) and only reject that line. ### Where do I see a human-readable summary instead of raw error table rows? **Answer:** The AutoInvoice Execution Report, generated as output of the AutoInvoice Import concurrent request, groups exceptions by type and gives plain-language descriptions - check that before querying RA_INTERFACE_ERRORS_ALL directly. ## Search terms AutoInvoice import failed, RA_INTERFACE_ERRORS_ALL query, AutoInvoice invalid line exceptions, AutoInvoice Execution Report, AR AutoInvoice GL date error, AutoInvoice invalid bill to customer, EBS Receivables interface errors, AutoInvoice rejected lines fix --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json