Search Results gl_code_combinations




I'll describe the GL_CODE_COMBINATIONS table in Oracle E-Business Suite (EBS) with typical details a consultant would provide:

GL_CODE_COMBINATIONS Table Overview:

Purpose:
- Stores unique chart of accounts combinations
- Represents financial segment values for accounting entries
- Defines valid account combinations in the General Ledger

Key Columns:
1. CODE_COMBINATION_ID (Primary Key)
- Unique identifier for each combination
- Typically a number generated by sequence

2. SEGMENT1 (Company)
- Represents organizational segment
- Usually contains company or legal entity code

3. SEGMENT2 (Cost Center)
- Represents departmental or organizational unit
- Used for tracking expenses by responsibility center

4. SEGMENT3 (Account)
- Natural account segment
- Defines revenue, expense, asset, liability accounts

5. SEGMENT4-SEGMENT6 (Optional Segments)
- Additional flexible segmentation
- Can represent project, product, location, etc.

6. ENABLED_FLAG
- Indicates if combination is active/valid
- 'Y' = Active, 'N' = Inactive

7. SUMMARY_FLAG
- Indicates if combination can be used for reporting
- 'Y' = Summary, 'N' = Detail

Important Attributes:
- Managed through Chart of Accounts configuration
- Controlled by Flexfield structure
- Used in journal entries, subledgers, financial reporting

Performance Tip:
- Index on CODE_COMBINATION_ID recommended
- Frequently accessed during accounting transactions