Top 19 Oracle Flexfield Interview Questions
Q1. What Is The Purpose Of A Flexfield Qualifier? Why Is It Needed When You Can Have A Unique Name For A Segment?
Flexfield qualifiers are essentially used to identify the character of the section on the flexfield stage. Qualifiers like Balancing,Cost Center, InterEntity,Natural Account and so on..Indicates the kind of section.
For Ex--> Normally company section is certified as Balancing, that allows you to intimate that the debits have to stability the credits for a selected account for a exact employer. I.E for a specific GL code combos.
Hence having unique names to the segments/flexfield has no reference to this because the reason of the above is absolutely distinctive.
Q2. Can We Use Other Columns (beside Attributes) As Segments For Dff?
Yes we may additionally.If we check in a few other columns then we might also use them as flexfields.But this is not recommended with the aid of Oracle.
Q3. What Is The Difference Between Flexfield Qualifier And Segment Qualifier?
Flexfiled qualifier identifies segement in a flexfield and section qualifier identifies value in a phase.
There are 4 varieties of flexfiled qualifier 1) Balancing segment qualifier 2) value middle three) herbal account and four) intercompnay.
Segemtn qualifier :-
permit budgeting
permit posting
account type
contral account and
reconciliation flag
Q4. What Is Concurrent Prg?
Concurrent Program is nothing but an instance of execution document together with parameters and incompatable.
Q5. How Do I Enable A Database Column To Use It In A Dff Segment?
Open Flexfield => Descriptive=>Register and query required DFF. Click on "Columns" button allow/disable required columns there.
Q6. Is It Possible To Enable/disable Only Few Fields Of Any Dff?
Yes, it is feasible to permit or disable few fileds in DFF by way of usning Check Box
Q7. What Is The Maximum Number Of Segments That Can Be Defined For Kff?
Once can bring together a KFF without any segments described within. There is no lower restriction.However there is restrict at the maximum wide variety of segments for use and this is 30 as rightly stated via my pal.
Q8. What Is The Significance Of Cross Validate Segments In The Key Flexfield Structure Screen?
Cross validation prevents the customers from getting into the invalid flexfield combinations. This is applicable to all of the duties.
Q9. How Do I Enter The Default Value Of Key Flexfield Or Dff Segment?
While defining segments or attribute of KFF or DFF in segement(accounting flexfield) window in validation container pick out regular in default kind and input default value.
Q10. How Many Flexfields Are There In Total Modules?
There are Two kinds of flexfielld they may be
Descriptve flexfield(which is non-obligatory)
keyflexfield
IN keyflex thereare 33 key flexfilds which might be utilized in varios modules of oracle software package deal.
Q11. Are The Value Sets Mandatory For Dff Segments?
Valuesets for the segments in DFF's aren't mandatory.
If require you could trade as mandatory. In this Dff shape on test container as unable/ disable you could using as require
Q12. What Is The Significance Of Reference Field In A Dff?
Using reference discipline within the DFF, you may toggle the DFF on the basis of reference area cost.
Q13. Which Procedure Should Be Used To Make The Dff Read Only At Run Time?
FND_DESCR_FLEX.UPDATE_DEFINITION()
Q14. Do We Need To Register Standard Dff's?
Stndars DFF's are given by using Oracle.We need no longer sign up.We can register CustomDFF's
Q15. What Is The Difference Between Key Flexfield And Descriptive Flexfield?
Key Flexfield is used to explain particular identifiers with a view to have a better that means than the usage of variety IDs. E.G a part variety, a price centre and so on.
Desc Flex is used to just seize extra records.
Key Flexfields have qualifiers while Desc Flexfields do now not.
Desc Flexfields can have context touchy segments even as Key flexfields can't.
Q16. Give The Complete Process Cycle For Oe / Ar?
Order EnteredOrder BookedDispatch EligibleDispatchedPick Release EligiblePick ReleasedShip ConfirmInvoicedPosted in GL
Q17. Can We Disable/allow A Whole Dff Not Few Attributes?
Yes this can be finished with Custom.Pll It has a system name Event.In this procedure you could capture events like when-new-form-example,when-new-item-instance and so forth So capture tht event on that you need to disable your DFF and use name_in('machine.Current_form/item') to recognise the name of your DFF after which using shape built-in set_item_property disable that field. Same way we will do permit the DFF
Q18. What Is The Significance Of Structure Id In Key Flexfields?
A Key-Flexfield can be associated with unmarried or multiple systems. This is particular when developing a new flexfield.
This can be definitely understood when defining a new key flex area. Note that All the fields assume description and Structure column are elective.
If you need to enable a multi-based flex-subject you want to assciate the corresponding returned-give up column
Q19. What Is The Use Of Group Flex Field And Where Exactly We Use?
Group Flexfield is Used in Oracle Payroll. This Group Flexfield catches the information to which the employee belongs. Eg : Regular then the worker belongs to Regular payroll Group.
Based on our requirements we categorize the employees in to corporations for easy identification reason

