Oracle General Ledger – Functional Interview Questions
Oracle General Ledger – Functional Interview Questions
Hello Friends, As a series to get improve on Financials , here some more General Ledger Questions, I consider these as functional and advance questions.
Can a flexfield qualifier be changed after it has been created?
No. Once a segment 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 set of books.
Does the Accounting Flexfield needs one segment flagged with the Intercompany qualifier?
The intercompany segment is an optional Intercompany feature for the Intercompany Segment Balancing.
It is not required in order to do intercompany balancing.
It is just another way to do the intercompany balancing, instead of using different natural accounts to track intercompany balances, you can use the intercompany segment in the Chart of Accounts to record the same detail.
It is more just a matter of preference of how you want to track the intercompany transactions.
Can different Sets of Books share the same Value Set?
If there is a set of books that uses a particular value set and a new book is created, it can use the existing value set.
When the Account Flexfield Structure is created, simply choose the existing value set from the List of Values.
However,if you use an existing value set, the new structure will also inherit the existing values in the value set. It does not create an empty value set to be populated.
Can the Accounting Flexfield Segment name be changed?
Nothing about a flexfield structure should be changed since this could seriously impact your existing data and cause inconsistencies
The LOV (list of values) prompt and window prompt that appear on the segment form can be changed so the users can see the segment with a different name.
1. Navigate to Setup: Financial: Flexfield: key: segments
2. Query all
3. Unfreeze your flexfield
4. Open the segment summary screen
5. Choose the segment you wish to change
6. Change the LOV and window Prompts and insert the new name.
7. Save your work
8. Freeze the Flexfield which should launch a concurrent request.
9. Check the log and make sure the compile worked OK.
How to 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.
How to delete a segment value?
There is no supported way to delete a segment value. Segment values can only be disabled not deleted.
How to enable an existing Future-Use accounting flexfield segment?
Do the following, on the Key Flexfield Segments form:
- Unfreeze the accounting flexfield
- Change the Window Prompt name to a valid name (do NOT change the segment name)
- Update the Default Type and Default Value (if necessary)
- Freeze the accounting flexfield and recompile
How to re-enable an account value?
In order to re-enable an account value or remove an end date, do the following:
- Unfreeze the accounting flexfield structure
- Re-enable the account value or remove the end date of the segment value.
- Re-freeze the accounting flexfield structure and recompile.
- Log out of the applications and log back in.
Is there a way to load values for a specific segment outside of the form?
iSetup is the Oracle product that provides supported APIs to load values into Oracle Applications flexfields.
To load code combinations ADI may be used. Uploading zero amount journals will create new code combinations.
In this case Dynamic Insertion should be enabled and all account segment values need to exist before the new account code combinations will be dynamically created.
What is the difference between Hierarchical and Non-hierarchical Security Type?
- Hierarchical Security: This feature combines Flex Value Security and Flex Value Hierarchy.
The end result is ?a flex value is secured if one of it?s parents is secured?, i.e. if a parent value is excluded then all the children are also excluded.
With non-hierarchical security, the child values do not inherit the parent security.
Which tables store segment values and descriptions?
- FND_FLEX_VALUES_TL
- FND_FLEX_VALUES.
Thanks – Shivmohan Purohit
