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

Last updated on MARCH 08, 2017

Applies to:

Oracle U.S. Federal Financials - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

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

Example:
PO_Number:PT10307238-IB-FV

AP_INVOICE_LINES_INTERFACE has
PO NUMBER: PT10307238-IB
PO_LINE_NUMBER: 2
PO_SHIPMENT_NUM: 1
PO_DISTRIBUTION_NUM: 1

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



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms