RefreshRecord does not work for a calculated field with Count(MVL) in V8 (Doc ID 1682228.1)

Last updated on MAY 25, 2023

Applies to:

Symptoms

The following configuration works fine on 7.8.2.x, but it does not work on 8.0.x and 8.1.x.

(1) In a detail view with parent form applet and child list applet, the parent form applet has a field which shows how many child records related to the parent record.

(2) To to it, the parent BC has a calculated field which uses Count("MVL name") function.

(3) To refresh the field right after adding a child record, RecordRefresh method is called in WebApplet_InvokeMethod with WriteRecord method in the child applet.

In 7.8, after adding a child record and saving it, the RefreshRecord method is called and the calculated field gets refreshed everytime. But in 8.0 and 8.1, the calculated field gets refreshed only the first time and does not get refreshed after RefreshRecord is invoked from the 2nd time. I confirmed that RefreshRecord method works fine for normal fields or calculated fields which do not use Count(MVL) function.

Cause

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