Gl Interview Questions
GL INTERVIEW QUESTIONS
3) What is the difference between KFF & DFF?
KFF - Keyflexfields are used throughout the Applications to uniquely identify organization’s financial information 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.
4) How can we identify whether DFF is allowed for a specific form or not?
The DFF is available to a form where the symbol “[ ]” is displayed
5) How do you disable a segment value and code combinations so journals will not be created with these accounts?
You must disable the segment, and disable every code combination that uses that segment. You can disable a range of code combinations using the “Program - Inherit Segment Value Attributes”
6) How do you update segment qualifiers or rollup groups for an existing value?
You need to unfreeze all flexfields that use the value set. Then you should be able to update the values.
7) How do you add a new value to an existing segment?
On the Segment Values form, insert a new row with your new value. Make sure the segment qualifiers are set correctly (Allow Posting and Budgeting).
If this is the natural account segment, specify the Account Type also.
8) How do I know which accounts are inactive?
Run the standard report: Chart of Accounts - Inactive Accounts Listing.
9) Can you add or delete segments to an existing accounting flexfield structure?
No. This will cause data inconsistencies and data corruption. Development and Support do not support changes to the accounting flexfield. Changing your flexfield definition once you have used it to acquire data can cause serious inconsistencies with existing data.
10) Which table stores the parent value and its' child ranges?
FND_FLEX_VALUE_NORM_HIERARCHY
11) What tables store segment values and descriptions?
FND_FLEX_VALUES_TL and
3) What is the difference between KFF & DFF?
KFF - Keyflexfields are used throughout the Applications to uniquely identify organization’s financial information 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.
4) How can we identify whether DFF is allowed for a specific form or not?
The DFF is available to a form where the symbol “[ ]” is displayed
5) How do you disable a segment value and code combinations so journals will not be created with these accounts?
You must disable the segment, and disable every code combination that uses that segment. You can disable a range of code combinations using the “Program - Inherit Segment Value Attributes”
6) How do you update segment qualifiers or rollup groups for an existing value?
You need to unfreeze all flexfields that use the value set. Then you should be able to update the values.
7) How do you add a new value to an existing segment?
On the Segment Values form, insert a new row with your new value. Make sure the segment qualifiers are set correctly (Allow Posting and Budgeting).
If this is the natural account segment, specify the Account Type also.
8) How do I know which accounts are inactive?
Run the standard report: Chart of Accounts - Inactive Accounts Listing.
9) Can you add or delete segments to an existing accounting flexfield structure?
No. This will cause data inconsistencies and data corruption. Development and Support do not support changes to the accounting flexfield. Changing your flexfield definition once you have used it to acquire data can cause serious inconsistencies with existing data.
10) Which table stores the parent value and its' child ranges?
FND_FLEX_VALUE_NORM_HIERARCHY
11) What tables store segment values and descriptions?
FND_FLEX_VALUES_TL and