Generic Interface Load Causes GL Corrections Form to Error: FRM-40654: Record has been updated. Requery block to see change (Doc ID 2276243.1)

Last updated on JULY 02, 2017

Applies to:

Oracle Public Sector Financials (International) - Version 12.1.1 and later
Information in this document applies to any platform.
IGIGILDR module: Generic Interface: Load External Feeder File
GLXJICOR form - Correct Journal Import Data
IGIGIEXT.sql

Symptoms

When attempting to correct in GL journals loaded via Generic Interface, the following error occurs in GLXJICOR form, Correct Journal Import Data.

Note data loaded into the interface includes on REFERENCE25 column '£' (Sterling Pound) currency character.

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

STEPS TO REPRODUCE
---------------------------------------
1. Load data into Generic interface
2. Gl Responsibility > Journal > Import > Correct
3. Attempt to load data in this form and change it
4. Observe the error

WORKAROUND
------------------------------
Do not change data from interface, but load it as is.
If data needs change, delete from interface and load it again correctly.

Changes

 

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