My Oracle Support Banner

R12: AP: Invoice Line Discarded Successfully But the Related Distributions Are Not Reversed Causing DIST VARIANCE Hold (Doc ID 2184616.1)

Last updated on JUNE 21, 2023

Applies to:

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

Symptoms

Invoice Line Discarded Successfully But the Related Distributions Are Not Reversed Causing DIST VARIANCE Hold

When user discards AP invoice lines, the associated distributions are not reversed.

Manually reversing distributions, below error appears:

APP-SQLAP-10103- You cannot reverse this distribution.


Steps to Reproduce:

  1. Login in to Oracle Applications using Payables responsibility.
  2. Open the Invoice Workbench
    (N) Invoices > Entry > Invoices
  3. Query invoice
  4. Select/Click on the [Actions] button
  5. When user discards AP invoice lines, the associated distributions are not reversed.
  6. The line amount is changed to 0 but the distribution total is still not 0. This is causing DIST VARIANCE Hold on invoice
  7. On manually reversing distributions, the error appears.

 

 

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


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