-
What is the difference between flexfield qualifier and segment qualifier?
Read Best Answer
Editorial / Best Answer
Answered by: mady
- Oct 10th, 2005
flexfield qualifier identifies a particular segment of a key flexfield. You can think of a flexfield qualifier as an ?identification tag? for asegment.
Ex. balancing segment, natural accounting segment, cost center and inter company segment qualifiers
A segment qualifier identifies a particular type of value in a single segment of a key flexfield. In the Oracle Applications, only the Accounting Flexfield uses segment qualifiers. You can think of a segment qualifier as an ?identification tag? for a value.
Allow Budgeting, Allow Posting, and Account Type fields are segment qualifiers for the Accounting Flexfieldbhanu teja
- Jun 9th, 2017
Qualifiers and the properties which are used to determine the behaviour of segments and their values
kasim babu
- May 22nd, 2015
Flex field qualifiers will identify the nature of the segment segment qualifiers will identify the nature of the account
-
How many attribute columns can we have for single dff?
Read Best Answer
Editorial / Best Answer
rpadma- Member Since Jul-2010 | Jul 29th, 2010
The number of attribute columns available for a DFF depends on how many attribute columns the underlying table has. Some have around 15 others have upto 30.
SHASHANK
- Aug 29th, 2016
There are 15 Attribute columns and one attribute category column for DFF.
rpadma
- Jul 29th, 2010
The number of attribute columns available for a DFF depends on how many attribute columns the underlying table has. Some have around 15 others have upto 30.
-
How many flexfields are there in total modules
Read Best Answer
Editorial / Best Answer
Answered by: Chithra
- Sep 23rd, 2007
Owner
Key Flexfield Name
Flexfield Code
Oracle Assets
Asset Key Flexfield
KEY#
Oracle Assets
Category Flexfield
CAT#
Oracle Assets
Location Flexfield
LOC#
Oracle General Ledger
Accounting Flexfield
GL#
Oracle Human Resources
Grade Flexfield
GRD
Oracle Human Resources
Job Flexfield
JOB
Oracle Human Resources
Personal Analysis Flexfield
PEA
Oracle Human Resources
Position Flexfield
POS
Oracle Human Resources
Soft Coded KeyFlexfield
SCL
Oracle Inventory
Account Aliases
MDSP
Oracle Inventory
Item Catalogs
MICG
Oracle Inventory
Item Categories
MCAT
Oracle Inventory
SalesOrders
RLOC
Oracle Inventory
Stock Locators
MTLL
Oracle Inventory
System Items
MSTK
Oracle Payroll
Bank Details KeyFlexField
BANK
Oracle Payroll
Cost Allocation Flexfield
COST
Oracle Payroll
People Group Flexfield
GRP
Oracle Receivables
Sales Tax Location Flexfield
MKTS
Oracle Receivables
Territory Flexfield
CT#
Oracle Service
Oracle Service Item Flexfield
SERV
Oracle Training Administration
Training Resources
RES
satya
- Aug 3rd, 2016
There are 39 KFF in All modules
Chithra
- Sep 23rd, 2007
OwnerKey Flexfield NameFlexfield CodeOracle AssetsAsset Key FlexfieldKEY#Oracle AssetsCategory FlexfieldCAT#Oracle AssetsLocation FlexfieldLOC#Oracle General LedgerAccounting FlexfieldGL#Oracle Human ...
-
What is the difference between key flexfield and Descriptive flexfield?
Read Best Answer
Editorial / Best Answer
agouthaman- Member Since Feb-2010 | Feb 18th, 2010
KFF - Keyflexfields are used throughout the Applications to uniquely identify informations such as GL accounts, INV items, FIxed Assets and other entities that every business needs to keep track of.
DFF- Descriptive flexfields enable you to capture additional pieces of information from transaction entered into Oracle EBS.
DFF and KFF share common features. They are multisegment fields. Application validates individual segments based ons makes valueset rules and ensures that the segments makes sense using CVR (cross-validation rules).babu_siva
- Jun 4th, 2010
Key Flex Field: Here we simply enter the business data or transactions to get the results or output (with some limitation). Though coding & programming is not required, you do not have expans...
agouthaman
- Feb 18th, 2010
KFF - Keyflexfields are used throughout the Applications to uniquely identify informations such as GL accounts, INV items, FIxed Assets and other entities that every business needs to keep track of. D...
-
What are context sensitive segments in descriptive flexfields?
Read Best Answer
Editorial / Best Answer
agouthaman- Member Since Feb-2010 | Feb 18th, 2010
Context Sensitive Segments are conditional DFFs. Only when a condition is met a particular field 'appears' and we are able to capture details. So for that first DFF is made context sesitive and then second one if made reference.
agouthaman
- Feb 18th, 2010
Context Sensitive Segments are conditional DFFs. Only when a condition is met a particular field 'appears' and we are able to capture details. So for that first DFF is made context sesitive and then second one if made reference.
PAVAN
- Jul 26th, 2007
CONTEXT SENSITIVE SEGMENTS are displayed based on the context value. for eg, in a application where we enter the employee information, certain?segments should be displayed with respect to designation and some should not. This is where CONTEXT SENSITIVE SEGMENTS come into picture.
-
What are range flexfields? How can we create them in our form
Read Best Answer
Editorial / Best Answer
agouthaman- Member Since Feb-2010 | Feb 18th, 2010
The Accounting Flexfield Ranges block of the 'Define Budget Organization form' contains a range flexfield called Accounting Flexfield. This is based on Accounting KFF only.
agouthaman
- Feb 18th, 2010
The Accounting Flexfield Ranges block of the 'Define Budget Organization form' contains a range flexfield called Accounting Flexfield. This is based on Accounting KFF only.
-
Context field and Reference field in DFF
What is the difference between context field and reference field in DFF? in which cases we will use context field and reference field.
Read Best Answer
Editorial / Best Answer
sarunraj- Member Since Jan-2007 | Feb 10th, 2010
DFF has two types of segments
1. Global Segments
2. Context Sensitive Segments
Context Sensitive Segments depends on value of another field.
REFERENCE Field - If the context sensitive information is derived from a field in the form, then that field is called as a Reference Field.
CONTEXT Field - If the context sensitive information is derived from a field / segment in the DFF pop up windown, then that field is called as a Context Field.
Hope this helps.
Thanks,
Arunsarunraj
- Feb 10th, 2010
DFF has two types of segments1. Global Segments2. Context Sensitive SegmentsContext Sensitive Segments depends on value of another field. REFERENCE Field - If the context sensitive information is deri...
-
What is the significance of cross validate segments in the Key flexfield structure screen (figure 6)?
Read Best Answer
Editorial / Best Answer
samareshp- Member Since Apr-2009 | Apr 9th, 2009
Cross validation (also known as cross segment validation) controls the combinations of values you can create when you enter values for key flexfields. A cross validation rule defines whether a value of a particular segment can be combined with specific values of other segments.
Cross validation is different from segment validation, which controls the values you can enter for a particular segment.
When a user finishes entering segment values in a flexfield popup window, the flexfield checks whether the values make up a valid combination before updating the database. If the user entered an invalid combination, a diagnostic error message appears, and the cursor returns to the first segment assumed to contain an invalid value.
satishmkumar
- May 20th, 2009
Cross Validation Rules are used to restrict the combination of the segments of a particular structure.
samareshp
- Apr 9th, 2009
Cross validation (also known as cross segment validation) controls the combinations of values you can create when you enter values for key flexfields. A cross validation rule defines whether a value o...
-
How do I define global segment qualifier?
Read Best Answer
Editorial / Best Answer
satishmkumar- Member Since May-2009 | May 14th, 2009
Global segment qualifier is a hidden qualifier. By default this flexfield qualifier is assigned to all the segments of the structure by the system.
1. Allow Budgeting: YES/NO
If we enable 'Allow Budgeting' ---- YES on any segment value, it means we can allow budget values on that segment value.
2. Allow Posting: YES/NO
If we enable 'Allow Posting' ------YES on any segment, we can post journals created on that segment value.satishmkumar
- May 14th, 2009
Global segment qualifier is a hidden qualifier. By default this flexfield qualifier is assigned to all the segments of the structure by the system.1. Allow Budgeting: YES/NOIf we enable &#...
-
Descriptive Flex Field
What is descriptive flex field? what is accounting attributes accounts in key flexfield
Read Best Answer
Editorial / Best Answer
satishmkumar- Member Since May-2009 | May 14th, 2009
Descriptive Flexfields are used to capture additional or extra business information of the organization.
satishmkumar
- May 14th, 2009
Descriptive Flexfields are used to capture additional or extra business information of the organization.
-
Flexfield Qualifiers and Segment Qualifiers
Expalain the differenece between flexfield qualifier and segment qualifiers in the flexfield concept in the Oracle Applications.
Read Best Answer
Editorial / Best Answer
satishmkumar- Member Since May-2009 | May 14th, 2009
Qualifiers are of two(2) types. (1) Flexfield Qualifiers (2) Segment Qualifiers
(1) Flexfield Qualifiers: Flexifield Qualfiers are used to assign a property to the segment colums, which are used to determine the behaviour of CHART OF ACCOUNTS(COA).
(2) Segment Qualifiers: Segment Qualifiers are based on flexfield qualifiers. It is used to assign a property to the value of a segment.satishmkumar
- May 14th, 2009
Qualifiers are of two(2) types. (1) Flexfield Qualifiers (2) Segment Qualifiers(1) Flexfield Qualifiers: Flexifield Qualfiers are used to assign a property to the segment colums, which are used ...
Jaikiran
- Mar 14th, 2009
Qualifiers are used to set a specific property to the segment columns or segment values.Flexfield qualifiers are used to set a specific property to the segment columns like balancing segment, natural ...
-
What is the difference between EITs and DFFs?
How do we know when to use a DFF and when to use an EIT?Any inputs are appreciated. Thanks!
Read Best Answer
Editorial / Best Answer
kirangsv- Member Since Jan-2008 | May 30th, 2008
EIT is HRMS functionality and are used for DFF
DFF is used in GL, AP,AR....modules to add extra columns to a particulare fieldkirangsv
- May 30th, 2008
EIT is HRMS functionality and are used for DFFDFF is used in GL, AP,AR....modules to add extra columns to a particulare field
-
Is it possible to do any calculation on DFF or KFF or these are informative fields, and How do you search for specific DFF or KFF?
Read Best Answer
Editorial / Best Answer
rams.regalla- Member Since Jun-2007 | Jun 20th, 2007
Hi,
Its possible to do calculations on KFF or DFF columns.
But calculations on KFF or DFF columns are not effective in WHEN-NEW-ITEM-INSTANCE' or 'WHEN-VALIDATE-ITEM' triggers.
Calculations coding should be done in 'PRE-INSERT' or 'WHEN-VALIDATE-RECORD' triggers.
eg: In PRE-INSERT trigger
:M_RECEIPTS.ATTRIBUTE3=:M_RECEIPTS.ATTRIBUTE1+:M_RECEIPTS.ATTRIBUTE2
hope it helpsrams.regalla
- Jun 20th, 2007
Hi,Its possible to do calculations on KFF or DFF columns.But calculations on KFF or DFF columns are not effective in WHEN-NEW-ITEM-INSTANCE' or 'WHEN-VALIDATE-ITEM' triggers.Calculati...
-
How do we make the segments in a particular flexfield mandatory?
Read Best Answer
Editorial / Best Answer
Answered by: obs
- Nov 24th, 2006
Before making the segments first set the value set form there r mandatory fields is name of segment and security option and format type ie number or Char and size of length and validation colum(independent) ok
rams.regalla
- Jun 20th, 2007
When we create segments,in segments window, we can find "value set" button,click on this button to see the value set window,where we can see required check box.check it to required or uncheck it to optional.
obs
- Nov 24th, 2006
Before making the segments first set the value set form there r mandatory fields is name of segment and security option and format type ie number or Char and size of length and validation colum(independent) ok
-
What is the significance of reference field in a DFF?
Read Best Answer
Editorial / Best Answer
rams.regalla- Member Since Jun-2007 | Jun 19th, 2007
Based on the value selected in a particular field,if you want to pop-up DFF segments, then reference field will be used.
eg:you have a field called Item. if you choose Computer as an Item, then in DFF segments you want to show Computer Brand name, Size.
If you choose TV as an item , then in DFF you may want to show TV name,TV Color,TV Inches etc
in reference field, we enter :Item as Reference, then in context values,we enter the Item Values and then respective Segment names.rams.regalla
- Jun 19th, 2007
Based on the value selected in a particular field,if you want to pop-up DFF segments, then reference field will be used.eg:you have a field called Item. if you choose Computer as an Item, th...
sankarreddy
- Nov 15th, 2006
srw.reference(:p_struct_num) this is bind varibale referecessrw.reference(;P_flexdata) this is source column data references
-
How many Key Flex fields are there in financial modules and what are they module wise?
Read Best Answer
Editorial / Best Answer
Answered by: Saritha
- May 22nd, 2007
GL : Accounting KFF
FA: Asset KFF, Category and Location KFFs
PO : Item KFF
AR: Location and Territory KFF
Regards,
SarithaSaritha
- May 22nd, 2007
GL : Accounting KFFFA: Asset KFF, Category and Location KFFsPO : Item KFFAR: Location and Territory KFFRegards,Saritha
Read Best Answer
Ans