R12: AP: Federal If PO Has Multiple Distributions, APXIIMPT Rejects Invoice With MULTIPLE_DISTRIBUTIONS rejection code (Doc ID 2002529.1)

Last updated on MARCH 23, 2023

Applies to:

Symptoms

If PO has multiple distributions, APXIIMPT rejects with invoice with MULTIPLE_DISTRIBUTIONS

Example:
PO_Number: <PO NUMBER>

AP_INVOICE_LINES_INTERFACE has
PO NUMBER: <PO NUMBER>
PO_LINE_NUMBER: x
PO_SHIPMENT_NUM: y
PO_DISTRIBUTION_NUM: y

There is only one distribution for that shipment.

The Payables Open Interface Import is calling AP_INVOICES_UTILITY_PKG.CHECK_GDF_VALID which calls FV_GTAS_UTILITY_PKG.AP_CHECK_GDF_VALID
which calls FV_GTAS_UTILITY_PVT.VALIDATE_AP_INV_INTERFACE


The FV_GTAS_UTILITY_PVT.VALIDATE_AP_INV_INTERFACE has the problem.
This code is going only by ID... not number in the interface table.

If po_distribution_id is not populated, it attempts to get TAS/BETC using po_header_id
There could be more than one line,shipment , distribution on the PO .. and hence it fails with MULTIPLE_DISTRIBUTIONS rejection.

Please log a bug with Federal Team.

I will provide the following information

a) AP_INVOICES_INTERFACE data
b) AP_INVOICE_LINES_INTERFACE data
c) AP_INTERFACE_REJECTIONS
d) Import output showing Rejections.


Rejection Code: MULTIPLE_DISTRIBUTIONS
Rejections Reason: Shipment has multiple dists, no override BETC values allowed

Changes

Cause

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