My Oracle Support Banner

R12: AP: Change Account of PO Matched Distribution Cause Error FRM-40654:Record has been updated.Requery block to see change (Doc ID 2202143.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Goal

When try to change account of PO matched invoice distribution,

Error

FRM-40654:Record has been updated.Requery block to see change is there

Not all PO matched dist account can be changed and as customer do not match below conditions, the account should be able to be changed

Invoice Distribution Field :  
---------------------------
Account

Cannot adjust field if:
-------------------------
Distribution is purchase order matched and
a) the Allow Matching Account Override Payables option is disabled,
b) the invoice is Final Matched,
c) the Accrue On Receipt flag is enabled or set to Done,
d) encumbrance is enabled.

Encumbrance is enabled and distribution
a) is part of a reversal pair, or
b) is encumbered (validated). Projects is installed, distribution is project-related, and the PA: Allow Override of PA Distributions in AP/PO profile option is disabled.
Distribution is an automatically created withholding tax distribution.


Updatable if Accounted?
-------------------------------
NO

Solution

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
Goal
Solution


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