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 FND_FLEX_VALUES.
12) Do all segments of your accounting flexfield have to be enabled and displayed? Yes. This is true for all applications versions. All segments must be enabled and displayed. From the Oracle Applications Flexfields Guide: 'If you are defining the Accounting Flexfield, you MUST display ALL segments. Hiding segments will adversely affect your application features, such as Mass Allocations'. The only supported solution therefore, is to have all segments displayed from the start. 13) Can a flexfield qualifier be changed after it has been created? No. Once a flexfield qualifier has been designated for a specific segment and has been saved, it will permanently have the attributes with that qualifier. For example, you accidentally designate the cost center segment as the natural account segment. Even though you do not compile this, the system saves the changes. And once it has been saved, it will have all the attributes designated for the natural account qualifier, even after it has been changed back, resaved with the correct qualifier and compiled. This is the inherent functionality of the software. Unfortunately, there is no real easy solution for this issue. The only option is to create a new chart of accounts and attach a new ledger. You can do this only if you haven't created the ledger yet. 14) Can you change the size of a value set used in the accounting flexfield after it has been created? No. Once the value set is created, you should not change the size of a value set used in an accounting flexfield. We recommend that you set Right-justify Zero-fill Numbers to Yes for value sets you use with the Accounting Flexfield. You should never change to a value set with a larger (or smaller) maximum size if your value set is Right-justify Zero-fill, since 001 is not the same as 0000001, and all of your existing values would become invalid. 16) Can a parent value be changed to a child value and vice versa? An account should never be changed from a child to a parent...
Please join StudyMode to read the full document