My Oracle Support Banner

GMSAWEAW: After Upgrade to 12.2, the Awards Management Form Cannot be Opened in Forms Builder though Opens Successfully in the Application (Doc ID 2828491.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Grants Accounting - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When trying to open GMSAWEAW in Forms Designer, it crashes with the following error:  

Oracle forms designer has stopped working


This is the ONLY form that gives this behavior.

Manual compilation of this form gives:

Compiling WHEN-VALIDATE-ITEM trigger on LAST_NAME item in GMS_LOC_CONTACTS
data block...
   No compilation errors.

FRM-30438: Warning: WHEN-VALIDATE-ITEM trigger ignored for subordinate mirror
item GMS_AWARDS_V.QK_AWARD_IDC_SCH_NAME_MIRR.
Trigger text is:
IF :SYSTEM.TRIGGER_ITEM = 'GMS_AWARDS_V.QK_AWARD_IDC_SCH_NAME_MIRR' THEN
gms_awards_v2.qk_award_idc_sch_name_mirr('WHEN-VALIDATE-ITEM');
ELSE
award.idc_schedule_date('WHEN-VALIDATE-ITEM');
END IF ;

M... item is GMS_AWARDS_V.IDC_SCHEDULE_NAME.
Trigger text is:
IF :SYSTEM.TRIGGER_ITEM = 'GMS_AWARDS_V.QK_AWARD_IDC_SCH_NAME_MIRR' THEN
gms_awards_v2.qk_award_idc_sch_name_mirr('WHEN-VALIDATE-ITEM');
ELSE
award.idc_schedule_date('WHEN-VALIDATE-ITEM');
END IF ;


The above compilation error was found to not be related but is mentioned for diagnostic purpose.

There are no errors when opening the form in the application and this became an issue after upgrading to 12.2.

Steps to Reproduce:

Open the form GMSAWEAW in Forms Designer and the error is received

Changes

 Upgraded to 12.2

Cause

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
Symptoms
Changes
Cause
Solution
References


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