Oracle Forms

Hi Guys,

I am getting FRM-40508 when i press ok button in my form.

The code in my ok button is :

BEGIN
Do_Key('Commit_Form');

IF Form_Success THEN
Hide_Window('RELOAD_WINDOW');
Go_Block('CREATE_PLANS');
ELSE
RAISE Form_Trigger_Failure;
END IF;
END;

Before going to ok button, when-validate-trigger is fired in my 'CACHE_RELOAD' block.
I've run my form in the debugger and found that there is no error in when-validate-trigger..

All it is doing in when-validate-trigger is :

UPDATE system_parameters
SET sysp_refdata_expires = :cache_reload.dsp_refdata_expires;

But, after it passed when-validate-item trigger, it is faling in the when-button-pressed trigger of OK button.

Strange thing is here it is trying to update the system_parameters table but when i check the display-error in help, it shows error as:

INSERT INTO SYSTEM_PARAMETERS(DSP_REFDATA_EXPIRES) VALUES (:1)

ORA-00904 : "DSP_REFDATA_EXPIRES" invalid identifier.

Now, i am confused that why it is trying to INSERT into system_parameters table rather than update as given in my upper query.

Why, it is trying to insert into dsp_refdata_expires column when i am trying to update the sysp_refdata_Expires column in system_parameters table.

System_parameters table doesn't have any dsp_refdata_expires column.

I request all you form gurus to please help me with this.