FLEX FIELD:
============
IT IS NOTHING BUT A FIELD ,A FIELD MADE UP WITH SEGMENT/ATTRIBUTE COLUMNS.
2 TYPES:
=========
1) DFF-DESCRIPTIVE FLEX FIELD.
2) KFF-KEY FLEX FIELD.
1)DFF:
======
IT IS USED TO CAPTURE "EXTRA INFORMATION " FROM END USER WITHOUT CHANGING THE FORM CODE AND TABLE STRUCTURE.
->WHENEVER THE FLEXFIELD IN FORM IT WILL BE LIKE "[]"
->WE HAVE 15 ATTRIBUTE COLUMNS IN EVERY APPS TABLE
->UP TO 15 EXTRA COLUMNS WE CAN ADD THE FLEXFIELD.
->IF WE DID NOT PROVIDE INFORMATION IT WILL TAKE NULL VALUES.
GO TO APPLICATION DEVELOPER RESP
->FLEXFIELD ->DESCRIPTIVE ->REGISTER -FOR NEW DFF
->SEGMENT -TO MODIFY DFF.
->WHENEVER WE HAVE DFF IN FRONT END, BACK END WILL BE ATTRIBUTE COLUMNS.
PO_REQUISITION_HEADERS_ALL ->15 ATTRIBUTE COLUMNS WE HAVE IN HEADER LEVEL.
PO_REQUISITION_LINES_ALL ->15 ATTRIBUTE COLUMNS WE HAVE IN LINES LEVEL.
PO_REQ_DISTRIBUTIONS_ALL ->15 ATTRIBUTE COLUMNS WE HAVE IN DISTRIBUTIONS LEVEL.
GO TO PURCHASING VISION OPERATIONS (USA) RESP
NAVIGATION:
===========
REQUISITIONS ->REQUISITIONS ->PLACE CURSOR ON DFF FIELD IN HEADERS LEVEL
->HELP ->DIAGNOSTICS ->EXAMINE ->APPS
->BLOCK: $DESCRIPTIVE_FLEXFIELD$
->FIELD: PO_REQ_HDR.DESCRIPTIVE_FLEX
->VALUE: Requisition Headers (Purchasing).
COPY VALUE: Requisition Headers
TO SEE THE DFF DETAILS :
========================
GO TO APPLICATION DEVELOPER RESP
->FLEXFIELD ->DESCRIPTIVE ->REGISTER ->F11 ->TITLE: PASTE VALUE ->CTRL+F11.
TO MODIFY THE DFF:
===================
GO TO APPLICATION DEVELOPER RESP
->FLEXFIELD ->DESCRIPTIVE ->SEGMENTS ->F11 ->TITLE: PASTE VALUE ->CTRL+F11 ->UNCHECK "FREEZE FLEXFIELD DEFINITION"
->SEGMENTS ->ENTER THE DETAILS ->OPEN(BUTTON) ->UNCHECK "REQUIRED" CHECK BOX ->SAVE
->CHECK "FREEZE FLEXFIELD DEFINITION" ->OK ->COMPILE(BUTTON) ->OK ->OK
GO TO PURCHASING VISION OPERATIONS(USA)
->REQUISITIONS ->REQUISITIONS ->PLACE CURSOR ON DFF FIELD IN HEADERS LEVEL AND CHECK WHAT YOU DID.
GLOBAL DATA ELEMENTS:
=====================
IF WE WOULD LIKE TO DISPLAY THE FIELD GLOBALLY (WHICH WILL BE DISPLAYED ALWAYS IRRESPECTIVE OF CONTEXT FIELD VALUES).
CONTEXT FIELD:
==============
CONTEXT FIELD WILL BE USED TO DEFINE THE MULTIPLE STRUCTURES IN THE DFF.
WHEN USER PLACE THE CURSOR IN THE DFF IT WILL OPEN THE DFF WITH CONTEXT FIELD.
IT CONTAINS THE CONTEXT FIELD VALUES SELECT THE VALUES . BASED ON THIS VALUES DFF STRUCTURE WILL BE POPULATED.
CONTEXT FIELD VALUE WILL BE STORED IN THE COLUMN CALLED 'ATTRIBUTE_CATEGORY'
1)OPEN THE SEGMENT FORM QUERY RECORDS BASED ON THE DFF TITLE.
2)UNCHECK THE CHECK BOX CALLED 'Freeze Flexfield Definition'
3)ENTER THE CONTEXT FIELD PROMPT , SELECT DISPLAY,REQUIRED CHECK BOX, IF REQUIRED
4)GO TO CONTEXT FIELD VALUES ENTER THE VALUE =>SEGMENTS BUTTON =>ENTER THE FIELDS
5)SAVE, COMPILE
-> GO TO PURCHASING VISION OPERATIONS (USA)
REQUISITIONS ->REQUISITIONS ->PLACE CURSOR ON DFF FIELD IN HEADERS LEVEL
->HELP ->DIAGNOSTICS ->EXAMINE ->APPS ->BLOCK: $DESCRIPTIVE_FLEXFIELD$ ->FIELD: PO_REQ_HDR.DESCRIPTIVE_FLEX
->VALUE: Requisition Headers (Purchasing).
COPY VALUE: Requisition Headers
GO TO APPLICATION DEVELOPER RESP:
==================================
->FLEXFIELD ->DESCRIPTIVE ->SEGMENTS ->F11 ->TITLE: PASTE VALUE ->CTRL+F11 ->UNCHECK "FREEZE FLEXFIELD DEFINITION"
->PLACE THE CURSOR UNDER "CODE"->PRESS CREATE BUTTON.
->CODE:MARRIED->NAME:MARRIED->DESCRIPTION:FOR EMPLOYEES WHO MARRIED.
->AGAIN PRESS CREATE BUTTON.
->CODE:SINGLE->NAME:SINGLE->DESCRIPTION:FOR EMPLOYEES WHO ALL ARE SOLO.
THEN PLACE THE CURSOR ON MARRIED FIELD.->PRESS SEGMENTS(BUTTON)
->1 "SPOUSE NAME" "SPOUSE NAME" "ATTRIBUTE 3" "15 Characters"
->2 "NUMBER OF CHILDREN" "NUMBER OF CHILDREN" "ATTRIBUTE 4" "10/Number"
->PRESS OPEN(BUTTON) ->UNCHECK "REQUIRED" CHECK BOX.
->CTRL+S.
THEN PLACE THE CURSOR ON SINGLE FIELD.->PRESS SEGMENTS(BUTTON)
->1 "Father Name" "Father Name" "ATTRIBUTE 1" "50 Characters"
->2 "Mother Name" "Mother Name" "ATTRIBUTE 2" "50 Characters"
->PRESS OPEN(BUTTON) ->UNCHECK "REQUIRED" CHECK BOX.
->CTRL+S
->CHECK "FREEZE FLEX FIELD DEFINITION" CHECK BOX.
->COMPILE
->CTRL+S.
-> GO TO PURCHASING VISION OPERATIONS (USA).
CREATE A REQUISITION BY GIVING THE DFF DETAILS AND APPROVE IT.
THEN CHECK THE TABLE "HOW" AND "WHERE" THE DETAILS OF DFF IS STORING IN DATABASE.
SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT 1='14322'
SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT 1='14323'
KEY FLEXFIELD :
===============
KFF WILL BE USED TO CAPTURE THE KEY(IMPORTANT) INFORMATION FROM "END USER" IN CODE LANGUAGE.
FOR EVERY CODE THERE WILL BE SPECIFIC MEANING IN THE APPLICATION.
FOR EX: WE CAN FIND SOME OF THE FIELDS LIKE FOLLOWS
CODE COMBINATION 01-001-1540-1234-0000
01-OPERATIONS
001-HRMS
1540-FURNITURE
1234-SALES ACCOUNT
0000-NO PRODUCT
DESCRIPTION : OPERATIONS-HRMS-FURNITURE-SALES ACCOUNT-NO PRODUCT
LIKE THIS WE CAN FIND THE MEANING IN THE APPLICATION FOR EVERY CODE.
WE WILL USE THE SEGMENT COLUMNS TO CAPTURE THE KFF DATA.
WE CAN FIND THE SEGMENT COLUMNS IN MOST OF THE TABLES LIKE SEGMENT 1 , SEGMENT 2, SEGMENT 3 ,......... .SEGMENT30.
ADVANTAGES OF KFF DATA:
========================
1.INFORMATION WII BE SECURED.
2.WE CAN DEFINE CROSS VALIDATION RULES SO THAT USER CAN NOT ENTER INVALID COMBINATIONS.
3.IT WILL IMPROVE THE PERFORMANCE BY GENERATING CCID(CODE COMBINATION ID).
4.WE CAN GENERATE THE REPORT AT ANY SEGMENT LEVEL.
Diff Between DFF and KFF:
====================
DFF KFF
-------------------------------------------------- -----------------------------------------------------------
1)DFF Will be used to capture the Extra 1)KFF will be used to Capture the Key Information. Information
2)ATTRIBUTE Columns will be used 2)SEGMENT columns will be used
3)We can have max DFF in the Application 3)We have 30 KFF already defined by Oracle
there is no Limit we can customize existing KFF. We are not
suppose to define the new KFF. We will not
get support from Oracle.
4)In DFF we will use Context Field to
define Multiple Structures. 4)In KFF we will define Structure Column to define the Multiple Structures.
NOTE:
=====
DFF MEANS ATTRIBUTE COLUMNS.
KFF MEANS SEGMENT COLUMNS.
WE HAVE TO REMEMBER SOME KEY FLEXFIELD NAMES AND WHICH MODULE AND WHAT IS THE TABLE.
============
IT IS NOTHING BUT A FIELD ,A FIELD MADE UP WITH SEGMENT/ATTRIBUTE COLUMNS.
2 TYPES:
=========
1) DFF-DESCRIPTIVE FLEX FIELD.
2) KFF-KEY FLEX FIELD.
1)DFF:
======
IT IS USED TO CAPTURE "EXTRA INFORMATION " FROM END USER WITHOUT CHANGING THE FORM CODE AND TABLE STRUCTURE.
->WHENEVER THE FLEXFIELD IN FORM IT WILL BE LIKE "[]"
->WE HAVE 15 ATTRIBUTE COLUMNS IN EVERY APPS TABLE
->UP TO 15 EXTRA COLUMNS WE CAN ADD THE FLEXFIELD.
->IF WE DID NOT PROVIDE INFORMATION IT WILL TAKE NULL VALUES.
GO TO APPLICATION DEVELOPER RESP
->FLEXFIELD ->DESCRIPTIVE ->REGISTER -FOR NEW DFF
->SEGMENT -TO MODIFY DFF.
->WHENEVER WE HAVE DFF IN FRONT END, BACK END WILL BE ATTRIBUTE COLUMNS.
PO_REQUISITION_HEADERS_ALL ->15 ATTRIBUTE COLUMNS WE HAVE IN HEADER LEVEL.
PO_REQUISITION_LINES_ALL ->15 ATTRIBUTE COLUMNS WE HAVE IN LINES LEVEL.
PO_REQ_DISTRIBUTIONS_ALL ->15 ATTRIBUTE COLUMNS WE HAVE IN DISTRIBUTIONS LEVEL.
GO TO PURCHASING VISION OPERATIONS (USA) RESP
NAVIGATION:
===========
REQUISITIONS ->REQUISITIONS ->PLACE CURSOR ON DFF FIELD IN HEADERS LEVEL
->HELP ->DIAGNOSTICS ->EXAMINE ->APPS
->BLOCK: $DESCRIPTIVE_FLEXFIELD$
->FIELD: PO_REQ_HDR.DESCRIPTIVE_FLEX
->VALUE: Requisition Headers (Purchasing).
COPY VALUE: Requisition Headers
TO SEE THE DFF DETAILS :
========================
GO TO APPLICATION DEVELOPER RESP
->FLEXFIELD ->DESCRIPTIVE ->REGISTER ->F11 ->TITLE: PASTE VALUE ->CTRL+F11.
TO MODIFY THE DFF:
===================
GO TO APPLICATION DEVELOPER RESP
->FLEXFIELD ->DESCRIPTIVE ->SEGMENTS ->F11 ->TITLE: PASTE VALUE ->CTRL+F11 ->UNCHECK "FREEZE FLEXFIELD DEFINITION"
->SEGMENTS ->ENTER THE DETAILS ->OPEN(BUTTON) ->UNCHECK "REQUIRED" CHECK BOX ->SAVE
->CHECK "FREEZE FLEXFIELD DEFINITION" ->OK ->COMPILE(BUTTON) ->OK ->OK
GO TO PURCHASING VISION OPERATIONS(USA)
->REQUISITIONS ->REQUISITIONS ->PLACE CURSOR ON DFF FIELD IN HEADERS LEVEL AND CHECK WHAT YOU DID.
GLOBAL DATA ELEMENTS:
=====================
IF WE WOULD LIKE TO DISPLAY THE FIELD GLOBALLY (WHICH WILL BE DISPLAYED ALWAYS IRRESPECTIVE OF CONTEXT FIELD VALUES).
CONTEXT FIELD:
==============
CONTEXT FIELD WILL BE USED TO DEFINE THE MULTIPLE STRUCTURES IN THE DFF.
WHEN USER PLACE THE CURSOR IN THE DFF IT WILL OPEN THE DFF WITH CONTEXT FIELD.
IT CONTAINS THE CONTEXT FIELD VALUES SELECT THE VALUES . BASED ON THIS VALUES DFF STRUCTURE WILL BE POPULATED.
CONTEXT FIELD VALUE WILL BE STORED IN THE COLUMN CALLED 'ATTRIBUTE_CATEGORY'
1)OPEN THE SEGMENT FORM QUERY RECORDS BASED ON THE DFF TITLE.
2)UNCHECK THE CHECK BOX CALLED 'Freeze Flexfield Definition'
3)ENTER THE CONTEXT FIELD PROMPT , SELECT DISPLAY,REQUIRED CHECK BOX, IF REQUIRED
4)GO TO CONTEXT FIELD VALUES ENTER THE VALUE =>SEGMENTS BUTTON =>ENTER THE FIELDS
5)SAVE, COMPILE
-> GO TO PURCHASING VISION OPERATIONS (USA)
REQUISITIONS ->REQUISITIONS ->PLACE CURSOR ON DFF FIELD IN HEADERS LEVEL
->HELP ->DIAGNOSTICS ->EXAMINE ->APPS ->BLOCK: $DESCRIPTIVE_FLEXFIELD$ ->FIELD: PO_REQ_HDR.DESCRIPTIVE_FLEX
->VALUE: Requisition Headers (Purchasing).
COPY VALUE: Requisition Headers
GO TO APPLICATION DEVELOPER RESP:
==================================
->FLEXFIELD ->DESCRIPTIVE ->SEGMENTS ->F11 ->TITLE: PASTE VALUE ->CTRL+F11 ->UNCHECK "FREEZE FLEXFIELD DEFINITION"
->PLACE THE CURSOR UNDER "CODE"->PRESS CREATE BUTTON.
->CODE:MARRIED->NAME:MARRIED->DESCRIPTION:FOR EMPLOYEES WHO MARRIED.
->AGAIN PRESS CREATE BUTTON.
->CODE:SINGLE->NAME:SINGLE->DESCRIPTION:FOR EMPLOYEES WHO ALL ARE SOLO.
THEN PLACE THE CURSOR ON MARRIED FIELD.->PRESS SEGMENTS(BUTTON)
->1 "SPOUSE NAME" "SPOUSE NAME" "ATTRIBUTE 3" "15 Characters"
->2 "NUMBER OF CHILDREN" "NUMBER OF CHILDREN" "ATTRIBUTE 4" "10/Number"
->PRESS OPEN(BUTTON) ->UNCHECK "REQUIRED" CHECK BOX.
->CTRL+S.
THEN PLACE THE CURSOR ON SINGLE FIELD.->PRESS SEGMENTS(BUTTON)
->1 "Father Name" "Father Name" "ATTRIBUTE 1" "50 Characters"
->2 "Mother Name" "Mother Name" "ATTRIBUTE 2" "50 Characters"
->PRESS OPEN(BUTTON) ->UNCHECK "REQUIRED" CHECK BOX.
->CTRL+S
->CHECK "FREEZE FLEX FIELD DEFINITION" CHECK BOX.
->COMPILE
->CTRL+S.
-> GO TO PURCHASING VISION OPERATIONS (USA).
CREATE A REQUISITION BY GIVING THE DFF DETAILS AND APPROVE IT.
THEN CHECK THE TABLE "HOW" AND "WHERE" THE DETAILS OF DFF IS STORING IN DATABASE.
SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT 1='14322'
SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT 1='14323'
KEY FLEXFIELD :
===============
KFF WILL BE USED TO CAPTURE THE KEY(IMPORTANT) INFORMATION FROM "END USER" IN CODE LANGUAGE.
FOR EVERY CODE THERE WILL BE SPECIFIC MEANING IN THE APPLICATION.
FOR EX: WE CAN FIND SOME OF THE FIELDS LIKE FOLLOWS
CODE COMBINATION 01-001-1540-1234-0000
01-OPERATIONS
001-HRMS
1540-FURNITURE
1234-SALES ACCOUNT
0000-NO PRODUCT
DESCRIPTION : OPERATIONS-HRMS-FURNITURE-SALES ACCOUNT-NO PRODUCT
LIKE THIS WE CAN FIND THE MEANING IN THE APPLICATION FOR EVERY CODE.
WE WILL USE THE SEGMENT COLUMNS TO CAPTURE THE KFF DATA.
WE CAN FIND THE SEGMENT COLUMNS IN MOST OF THE TABLES LIKE SEGMENT 1 , SEGMENT 2, SEGMENT 3 ,......... .SEGMENT30.
ADVANTAGES OF KFF DATA:
========================
1.INFORMATION WII BE SECURED.
2.WE CAN DEFINE CROSS VALIDATION RULES SO THAT USER CAN NOT ENTER INVALID COMBINATIONS.
3.IT WILL IMPROVE THE PERFORMANCE BY GENERATING CCID(CODE COMBINATION ID).
4.WE CAN GENERATE THE REPORT AT ANY SEGMENT LEVEL.
Diff Between DFF and KFF:
====================
DFF KFF
-------------------------------------------------- -----------------------------------------------------------
1)DFF Will be used to capture the Extra 1)KFF will be used to Capture the Key Information. Information
2)ATTRIBUTE Columns will be used 2)SEGMENT columns will be used
3)We can have max DFF in the Application 3)We have 30 KFF already defined by Oracle
there is no Limit we can customize existing KFF. We are not
suppose to define the new KFF. We will not
get support from Oracle.
4)In DFF we will use Context Field to
define Multiple Structures. 4)In KFF we will define Structure Column to define the Multiple Structures.
NOTE:
=====
DFF MEANS ATTRIBUTE COLUMNS.
KFF MEANS SEGMENT COLUMNS.
WE HAVE TO REMEMBER SOME KEY FLEXFIELD NAMES AND WHICH MODULE AND WHAT IS THE TABLE.
No comments:
Post a Comment