My Oracle Support Banner

General Ledger FAQ for Flexfields (Doc ID 399798.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle General Ledger - Version 11.5 and later
Information in this document applies to any platform.
This note integrates note 119379.1 which will be used for frequent error messages in GL Flexfields.

Purpose

This FAQ provides the answers for the most common questions about Flexfields in General Ledger.

White Papers also provide a useful insight into the topic. Please refer to <Document 124333.1> Accounting Flexfield Setup and Usage.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Requirements and Limitations defining the Accounting Flexfield
 1. What are the requirements and limitations defining the Accounting Flexfield?
 
 Segments, Values and Value Sets
 1. Can different Ledgers / Sets of Books share the same value set?
 2. Can the Accounting Flexfield Segment name be changed?
 3. How to add a new value to an existing segment?
 4. How to delete a segment value?
 5. How to start using an existing Future-Use accounting flexfield segment?
 6. How to re-enable an account value?
 7. Is it possible to change the size of a Value Set used in the Accounting Flexfield?
 8. Is there a way to load values for a specific segment outside of the form?
 9. What is the Segment Value Inheritance?
 10. What is the difference between Hierarchical and Non-hierarchical Security Type?
 11. Can security be changed from Hierarchical to Non Hierarchichal?
 12. Which tables store segment values and descriptions?
 13. Why can you update the Segment Values form (FNDFFMSV) when the flexfield structure is frozen?
 14. Why is it possible to post to accounts with disabled segment values?
 15. Why is the Field still protected against update, even after unfreezing the structure?
 16. Can the value set of the intercompany segment in the chart of accounts be changed ?
 
 Segment Qualifiers
 1. Can a flexfield qualifier be changed after it has been created?
 2. Does the Accounting Flexfield needs one segment flagged with the Intercompany qualifier?
 3. How to correct a misclassified account?
 4. What is a Reconciliation qualifier and how is it setup?
 5. Why are segment Qualifiers or Rollup Groups for an existing value not updatable?
 
 Hierarchies, Parents and Rollup Groups
 1. Can a parent value be changed to a child value and vice versa?
 2. How to identify overlapping child ranges in a Value Set?
 3. Should Rollup Groups be frozen?
 4. Which table stores the parent value and its child ranges?
 
 Accounting Flexfield Structure
 1. Are there any rules for the Names of the segments?
 2. Can any changes be made to the Accounting Flexfield?
 3. Can segments be added to or removed from an existing accounting flexfield structure?
 4. Can the segments of existing accounting flexfield structure be changed?
 5. Do all segments of the accounting flexfield have to be enabled and displayed?
 6. How to find which accounts are inactive?
 7. Can code combinations be deleted or purged ?
 8. How to set up an Accounting Flexfield structure that has a dependent segment?
 9. What is the recommended numbering for the Accounting Flexfield structure and why?
 10. Why are some of the segment separators displayed as question marks (?) ?
 
 Descriptive Flexfields in GL
 1. How to Add the Account Segment Qualifier Reconciliation Flag
 2. How to Disable Enter Journals:Reconciliation Descriptive Flexfield in Enter Journals?
 3. How to enable the Journals-Captured Information descriptive flexfield?
 4. Why columns Attribute11 through Attribute20 in Descriptive Flexfield Enter Journals: Lines cannot be used?
 
 Still have questions?
 Feedback
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.