Clicking "Discard Line 1" Displays Error FRM-40654 Record Has Been Updated"

(Doc ID 2171507.1)

Last updated on AUGUST 19, 2016

Applies to:

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

Symptoms

1. DESCRIPTION OF THE LOSS OF FUNCTIONALITY
------------------------------------------------------
When using the Discard Line 1 button in the Invoice Workbench, users are receiving the error:  'FRM-40654: Record has been updated. Re query block to see change.'

Issue is reproduced for every new Invoice when User tries to discard the first line, even when the leading/trailing spaces script was executed for all the AP tables.


2. BUSINESS IMPACT
----------------------
Medium impact


3. STEPS OR EVENTS THAT LEAD TO THE ISSUE OCCURRING
----------------------------------------------------------------
The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility

2. Navigate to Invoices : Inquiry > Invoices

3. Query the invoice where the line has to be discarded.

4. Select the Invoice line to be discarded and click on 'Discard'

5. Error message is displayed.


4. ENVIRONMENT IN WHICH ISSUE IS OBSERVED
---------------------------------------------------
Product: Oracle Payable
Release:  12.1.3
Database:  No information provided because the issue is not database or platform specific.
Platform:  Microsoft Windows x64 (64-bit)
Instances Affected: All instances
System Names:  This information is not relevant for the resolution of the issue.
Affecting Certain Users? The issue is consistently observed with all the users.


5. EXPECTED OR ACCEPTABLE RESULT
-----------------------------------------
User should be able to discard the line without errors.


6. WHAT IS WORKING
-----------------------
This information is not required for further clarification.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms