Unable To Cancel Payables Invoices due to DIST ACCT INVALID Hold (Doc ID 2566902.1)

Last updated on DECEMBER 02, 2022

Applies to:

Symptoms

On : 11.13.19.04.0 version, Manage Invoices-Audit Invoices

Some invoice(s) are unable to be cancelled after they were previously validated resulting in the following error when the user tries to validate the invoice afterwards.
ERROR

Invoice cannot be validated because it has an accounting hold and is pending cancellation. (AP-810595)

STEPS

The issue can be reproduced at will with the following steps:

1. Open one of the problem invoices
2. Open Actions
3. Validate

The issue persists even after attempting to once again cancel the invoice.

Changes

 There are three general scenario's where this issue can occur:

1. An invoice is created and validated. Then, an account combination which is related to at least one distribution line is given an end date which is before the accounting date. After this there is an attempt to cancel the invoice generating the reversal lines with the same accounting date as the distribution line and causing the error.
2. An invoice is created and validated. Either before or after this, an account combination which is related to at least one distribution line is given an end date within a particular accounting period. After this accounting period has closed, the invoice is cancelled, generating the reversal lines with an accounting date within the current period causing the error.
3. An invoice is created and validated. Then, an account combination which is related to at least one distribution is disabled by the Enabled checkbox. After this, there is an attempt to cancel the invoice generating the reversal line with an invalid account and causing the error

Cause

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