EBS Customizations (MOSC)

MOSC Banner

fnd_key_flex.define account flexfield in custom form R12

edited Mar 23, 2020 8:17AM in EBS Customizations (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center