Oracle-Developer.com Forums

[vj.jain]

This is interesting behavior of the Payables Open Interface Import. Line Number is required in AP_INVOICE_LINES_INTERFACE but after they are imported, the ordering of the invoice line distributions does not match the Line Number you provide. Here's further information:

Symptoms

Importing invoice with more than 10 lines. The result of invoice distribution after import does not match the ordering based on line number (in AP_INVOICE_LINES_INTERFACE).

The SQL
select * from AP_INVOICE_LINE_INTERFACE table where invoice_id = 25863;
shows the lines in the below order

LINE_NUMBER AMOUNT
1 78
10 78
11 78
12 1330.2
13 684.86

while in the Distributions screen, users see

LINE_NUMBER AMOUNT
1 78
2 78
3 78
4 1330.2
5 684.86

The payable open interface import process actually takes the natural order on the table. Even if the order of records inserting to the table ap_invoice_lines_interface is in certain order, the order of appearance for a specific invoice may not appear in that order,

As per Bug 987899, The invoice gateway is not designed to import the line numbers from the AP_INVOICE_LINES_INTERFACE table. The distribution_line_number will be generated by the import program.

Cause
Standard Functionality



The reason in more detail is:

Bug 3384659
INVOICE IMPORT LINE NUMBER AND DISTRIBUTION LINE NUMBER SHOULD BE THE SAME

"....The line number in the interface tables is not meant to mirror the
resulting
distributions in the ap_invoice_distribions table. Further, one line in the
interface table can result in one or more distributions, and so this ER makes
no sense to implement."

From above BUG documents it is clear that this is intended functionality and not a BUG.
The system is functioning as expected.

In other words, Invoice Line to Invoice Distribution is not 1-1 so how can the line number you provide be the ordering of the distributions. It makes sense. However, I'm not sure why this is a required field in the interface table.