fnd_key_flex.define account flexfield in custom form R12
I create a custom form, this form call KFF accounting flexfield.
fnd_key_flex.define(
BLOCK=>'HEADER',
FIELD=>'ADJUST_ACCOUNT1',
APPL_SHORT_NAME=>'SQLGL',
CODE=>'GL#',
NUM=>l_id_flex_num,
ID=>'ADJUST_ACCOUNT_ID1',
DESCRIPTION=>'',
TITLE=>'XXXXXl',
VALIDATE=>'FULL',
QBE_IN=>'Y',
DERIVE_ALWAYS=>'Y',
updateable => '',
VRULE=>'\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN',
where_clause => 'summary_flag != ''Y''',
QUERY_SECURITY =>'Y');
I used WHEN-NEW-FORM INSTANCE for call the KFF: xx_custom_pkg.xx_kff_proc('WHEN-NEW-FORM-INSTANCE'); It's work fine when I inserting data in the form, but when I execute post-query the KFF is not available, the field is gray, I need the field in yellow for entry combination account.