OAF Registration

  Structure Column While defining the KFF we will find structure column field if it is null value then KFF has got only one structure, if there is a structure column that will find multiple structure, open the segments form query the records based on KFF title, we will find structure details For Accounting KFF structure column is CHART_OF_ACCOUNTS_ID And we will get all the structure details from this table - GL_CHARTS_OF_ACCOUNTS. All the accounting KFF transaction will be stored in the data based table called GL_CODE_COMBINATIONS   Developing the Reports on KFF - Process   1) Call the user ext from before report trigger  SRW.USER_EXIT ( 'FND SRWINIT');   2) Call another User Exit from After Report Trigger     SRW.USER_EXIT ('FND SRWEXIT');      3) Define the following parameters      1) P_CONC_REQUEST_ID 2) P_FLEXDATA   3) P_STRUCT_NUM segment1||'\n'||segment2||'\n'||segment3||'\n'||.......||'\n'||segment30                               4) Call another User exit from before report trigger   SRW.USER_EXIT ('FND FLEXSQL                                     CODE         = "GL#"      NUM     = ":P_STRUCT_NUM"    APPL_SHORT_NAME                    = "SQLGL"    OUTPUT    = "P_FLEXDATA"    MODE     = "SELECT"    DISPLAY                 = "ALL");         5) Define the Query like follows    SELECT    &P_FLEXDATA    FROM    KFF Table    WHERE KFF Structure Column = :P_STRUCT_NUM;    6) Define Formula Column and CALL another User Exit from formula column  SRW.USER_EXIT ('FND FLEXIDVAL  CODE       = "GL#"   NUM     = ":P_STRUCT_NUM"  APPL_SHORT_NAME = "SQLGL"  DATA    = "Column Name where the data is available"  VALUE  = "to get KFF Values we will give formula column Name"  MODE     = "SELECT"  DISPLAY      = "ALL");   CLASS - 31   Flex Fields Reports development   P_FLEXDATA: It is one of the lexical parameter having the default value it is a contribution of all the segment columns, we will use this lexical parameter in the select statement to retrieve the data from database   P_STRUCT_NUM:  This is a bind variable will be used to capture KFF structure number   FND FLEX SQL:  It is one of the User Exit we will define in the before report trigger to retrieve KFF segments data   FND FLEXIDVAL:  This is another user exit will called from formula column to display the KFF data in the output   1) Call the user ext from before report trigger  SRW.USER_EXIT ( 'FND SRWINIT');   2) Call another User Exit from After Report Trigger     SRW.USER_EXIT ('FND SRWEXIT');      3) Define the following parameters      1) P_CONC_REQUEST_ID 2) P_FLEXDATA 3) P_STRUCT_NUM 4) Before Report Trigger function BeforeReport return boolean is L_NAME VARCHAR2(100); begin   SRW.USER_EXIT( 'FND SRWINIT');   l_name :=fnd_profile.value('GL_SET_OF_BKS_NAME');   select chart_of_accounts_id   into   :P_STRUCT_NUM   FROM   gl_sets_of_books   where  name = l_name;   SRW.REFERENCE(:P_STRUCT_NUM);   SRW.USER_EXIT('FND FLEXSQL  CODE    = "GL#"  NUM    = ":P_STRUCT_NUM"    APPL_SHORT_NAME = "SQLGL"  OUTPUT   = ":P_FLEXDATA"  MODE    = "SELECT"    DISPLAY     =  "ALL" ');      return (TRUE); end;   5) Go to data model select query   SELECT &P_FLEXDATA C_FLEXDATA, GCC.LAST_UPDATE_DATE FROM  GL_CODE_COMBINATIONS GCC WHERE  CHART_OF_ACCOUNTS_ID = :P_STRUCT_NUM;   6) Take the Formula column and place it in query and edit the PL/SQL editor   function CF_DATAFormula return Char is begin  SRW.REFERENCE(:P_STRUCT_NUM);  SRW.REFERENCE(:C_FLEXDATA);   SRW.USER_EXIT('FND FLEXIDVAL   CODE    = "GL#"  NUM    = ":P_STRUCT_NUM"     APPL_SHORT_NAME = "SQLGL"     DATA    = ":C_FLEXDATA"     VALUE   = ":CF_DATA"     MODE    = "SELECT"     DISPLAY   = "ALL"     IDISPLAY   = "ALL"'); RETURN(:CF_DATA);           end;   function CF_DESCFormula return Char is begin    SRW.REFERENCE(:P_STRUCT_NUM);  SRW.REFERENCE(:C_FLEXDATA);   SRW.USER_EXIT('FND FLEXIDVAL     CODE    = "GL#"     NUM    = ":P_STRUCT_NUM"     APPL_SHORT_NAME = "SQLGL"     DATA    = ":C_FLEXDATA"     DESCRIPTION  = ":CF_DESC"     MODE    = "SELECT"     DISPLAY   = "ALL"     IDISPLAY   = "ALL"'); RETURN(:CF_DESC);           end;    7) Go to layout model design the report and register with Oracle Applications and submit from the user SRS form   SRW.REFERENCE(  ) :  It we are using bind variable in source column the user exit we will refer to get the latest values for variable and source column   Changing the structure number dynamically: KFF structure number is nothing but chat of accounts ID, if we know the user set of books name we can find out chart of Accounts ID. Set of books name is one of the user profile by using FND profile API we can get from report triggers Go to before report trigger declare the local variable write the following API L_name varchar2 (100) L_name:=fnd_profile.value(‘GL_SET_OFBKS_NAME'); Write the following select statement to get the structure number based on the set of books name     Select   Chart_of_account_id   INTO  :P-STRUCT_NUM   From  GL_SET_OF_BOOKS   Where   name=L_name;   CLASS - 32   Develop the report on PO Module and display the charge account in PO Distributions Form      Line Level        Dist Level ReqNO Type Cdate Lineno  Item ItemDesc DistNo      ChargeA/C   FAQ in Flex Fields What is FLEX FIELD? What is KFF In you experience what are the KFF you have come across? Have u created any KFF? NO Have u created any DF? Yes What is FND FLEX SQL and FND IDVAL? What is SRW REFERENCE? What are parameters we suppose to pass for FND FLEXIDVAL? How to change structure number dynamically? What are the KFF are there in Inventory module? Is there any KFF in PO? NO Where the KFF data will be stored? Segments Where the DFF data will be stored? Attributes What in Attribute_Category?   CLASS - 33