:: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Financial


 Oracle Apps Technical interview questions  Oracle Apps Technical Interview Questions (488)
 Oracle Apps Financial interview questions  Oracle Apps Financial Interview Questions (603)
 Oracle Apps Manufacturing interview questions  Oracle Apps Manufacturing Interview Questions (51)
 Oracle Apps HRMS interview questions  Oracle Apps HRMS Interview Questions (77)
 Oracle Apps CRM interview questions  Oracle Apps CRM Interview Questions (9)
 Oracle Apps SCM interview questions  Oracle Apps SCM Interview Questions (105)
 Oracle Install Base interview questions  Oracle Install Base Interview Questions (62)
 Oracle Service Contracts interview questions  Oracle Service Contracts Interview Questions (101)
 Oracle Apps AllOther interview questions  Oracle Apps AllOther Interview Questions (11)
What are the types of key Flexfield forms?
 Question Submitted By :: Oracle-Apps-Financial
I also faced this Question!!     Answer Posted By  
# 1
Key flexfields appear on three different types of
application form:
1. Combinations form
2. Foreign key form
3. Range form
These form types correspond to the types of tables that
contain key flexfield data.

"Combinations form"
A combinations form is a form whose only purpose is to
maintain key flexfield combinations. The base table of the
form is the actual combinations table. This table is the
entity table for the object (a part, or an item, an
accounting code, and so on). The table contains a unique ID
column (also called the code combination ID column) as the
primary key, as well as individual segment columns, a
structure ID column, and other flexfields-related columns.
The combinations form contains hidden fields for each
segment column in the table, as well as displayed fields for
the concatenated segment values (the combination) and any
other fields (and columns) that the entity
requires, such as a concatenated description field. A
combinations form is sometimes also called a maintenance form.

"Foreign key form"
A foreign key form is a form whose underlying base table
contains only one or two columns that contain key flexfield
information, and those columns are foreign key columns to
the combinations table (usually a foreign key to the CCID
column of the combinations table and sometimes a structure
ID column as well). The purpose of a foreign key form often
has very little to do with the key flexfield itself, and
that the key flexfield appears on the form is essentially
incidental. For example, if you have a key flexfield that
represents a part number, you would use the combinations
form to define new parts and maintain existing part numbers.
You would then have many foreign key forms that you use to
manipulate your parts. You might have a form where you take
orders for parts, another form where you receive parts, and
yet another form where you ship parts. The fact that your
part number happens to be a key flexfield is not important
to your taking orders for your parts, for example.

"Range form"
A range form displays a range flexfield, which is a special
pop-up window that contains two complete sets of key
flexfield segments. A range flexfield supports low and high
values for each key segment rather than just single values.
Ordinarily, a key flexfield range appears on your form as
two adjacent flexfields, where the leftmost flexfield
contains the low values for a range, and the rightmost
flexfield contains the high values. A user would specify a
range of low and high values in this pop-up window. For
example, you might choose a range of part numbers for which
you want to run a report.

The range form uses a special table as its base table. This
table contains one or more (usually two) columns for each
segment column that appears in the combinations table.
However, these columns do not necessarily contain actual
segment values, and a row in the table does not necessarily
contain actual valid combinations. Usually this table
contains two columns for each segment, called SEGMENTn_LOW
and SEGMENTn_HIGH (where n is the segment column number),
that store the range of values for each segment.

Note:- For more information refere to "Flexfields Guide
Pages 2 - 5"
Is This Answer Correct ?    9 Yes 1 No
Arun Raj
# 2
there are two type of key flexfield form

dff descriptive flexfield
kff key flexfield
Is This Answer Correct ?    8 Yes 11 No

Other Oracle Apps Financial Interview Questions
  Question Asked @ Answers
What are the types of key Flexfield forms? Oracle 2
Re: How to see the structure of organization?ie which LE connected to which ledger and which OU connected to which LE?   2
How can we create FSG in another currency other than the currency which is associated with ledger? Cap-Gemini 1
what is meant by functional specifications involved in po and ap? Cognizent 1
Hi, I am presently working in one of the reputed BPO in Oracle Finance(end user) but i am interested to work in Oracle consultant or Oracle support. Can any one provide the materials.   3
What is the difference between Recurring Journals and Recurring Invoices? What is the need for the Recurring Journals in GL when Recurring invoices exist in AP? BirlaSoft 2
What is meant by with-holding tax invoice?   3
Can you please tell me what is there any differece betwen Payables Open Interface Import" Program and the "Payables Invoice Import" program?   2
what is the revenue recognization program in ar &what is the difference between aging report and revenue recognization report. Cognizent 1
Whether is it allowed for entering negative amount in Journal lines?   3
what is MD050 & wat specifications are included in it Meru-Cabs 5
Can any one tell set ups required for for Bills Receivables and also Automatic Receipts.   2
For more Oracle Apps Financial Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright 2013  All Rights Reserved.   ::