Oracle eBS經驗分享

Description : I would like to design a form to define material transfer type. I need a column reference gl account.

Below is my summary for using KFF.

• <Item>
• Distribution_account datatype is number. (Not show in Canvas)
• Account datatype is char. (Show in Canvas)

Item Account Attribute Setting

<Create a program unit>

PROCEDURE dff_define
IS
BEGIN
   fnd_key_flex.define
      (BLOCK                => 'MAIN'
     , FIELD                => 'ACCOUNT'
     , code                 => 'GL#'
     , appl_short_name      => 'SQLGL'
     , num                  => ':parameter.CHART_OF_ACCOUNTS_ID'
     , ID                   => 'DISTRIBUTION_ACCOUNT'
     , vrule                => '\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED
     \\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=INV;NAME=INV_VRULE_POSTING\\nN'
     , required             => 'N'
     , VALIDATE             => 'FULL'
     , usedbflds            => 'N'
      );
END;

<call procedure at Form Level – When-new-form-instance>

==Output==