R12 AP: Unable to Validate or CanceL Invoice Due To Distribution Variance (Doc ID 2980763.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Unable to validate an invoice as it is placed on hold "Distribution Variance" due to a missing distribution line.

Relevant Data

AP_INVOICE_LINES_ALL

Line Number Item Line Type Source Distribution_Match Discard Line Cancelled

1 MISCELLANEOUS IMPORTED D N N

2 ITEM IMPORTED D N N

3 TAX ETAX D N N

4 TAX ETAX Y N N

*No Cancelled lines

*No Discarded lines

AP_INVOICE_DISTRIBUTIONS_ALL

INVOICE_LINE_NUMBER LINE_TYPE_LOOKUP_CODE MATCH_STATUS_FLAG POSTED_FLAG

2 ITEM T N

3 REC_TAX A N

3 NONREC_TAX T N

*Not all lines validated

*Not a line posted

*Missing a Distribution Line

A Distribution is missing and this is generating the distribution variance.

	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

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