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:
Oracle U.S. Federal Financials - Version 12.2.3 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |