My Oracle Support Banner

R12: AP/EC: Not Able to Discard an EDI Gateway Imported Invoice with Invoice Line Number 0. Discard Raises Error APP-SQLAP-97696: Invoice Line Numbers Must Be 1 Or Greater. (Doc ID 3022526.1)

Last updated on MAY 15, 2024

Applies to:

Oracle Payables - Version 12.2.2 and later
Oracle EDI Gateway - Version 12.2.2 and later
Information in this document applies to any platform.


Unable to discard invoice line.

Invoice imported through EDI with line number 0.

When user tries to discard, the following message pops up:

The invoice line you wish to discard has charges that were manually allocated by applying a user-defined amount or percent rule. These manually created rules will be deleted if you discard the line.

Do you want to continue?

The invoice line number is actually zero (0)


Steps to reproduce:

  1. Log into Oracle Applications using a Payables responsibility.
  2. Run the "IN: Invoice (810/INVOIC)" (ECEINI) process to import a new invoices flat file.
  3. Invoices Imported successfully.
  4. Open the Invoice Workbench
    (N) Invoice > Entry Invoice
  5. Query one invoice recently imported and notice the invoice has an Invoice Line with number zero (0).
  6. Try to discard the Invoice Line Number 0
    The errors described above raise.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.