Search Results gl_je_headers
Here's a comprehensive description of the GL_JE_HEADERS table in Oracle E-Business Suite's General Ledger module:
Table Name: GL_JE_HEADERS
Purpose: Stores header-level information for journal entries in the General Ledger
Key Columns:
1. JE_HEADER_ID (Primary Key)
- Unique identifier for each journal entry
- Automatically generated sequence number
- Used to link with GL_JE_LINES table
2. LEDGER_ID
- Identifies the specific ledger associated with the journal entry
- Links to GL_LEDGERS table
3. STATUS
- Indicates current processing status of journal entry
- Common values: 'U' (Unposted), 'P' (Posted), 'R' (Reversed)
4. PERIOD_NAME
- Accounting period when journal entry is recorded
- Links to GL_PERIODS table
5. CREATED_BY
- User ID of journal entry creator
- Links to FND_USER table
6. CREATION_DATE
- Timestamp when journal entry was created
7. CURRENCY_CODE
- Transaction currency of journal entry
- Typically links to FND_CURRENCIES table
8. ACTUAL_FLAG
- Indicates whether entry is actual/budgetary
- 'A' for actual transactions
9. SOURCE_CATEGORY
- Identifies journal entry's origin (manual, imported, etc.)
10. REFERENCE_DATE
- Date of original transaction or reference document
Typical Use Cases:
- Recording financial transactions
- Supporting accounting entries
- Tracking journal entry lifecycle
- Enabling financial reporting and analysis
Key Relationships:
- GL_JE_LINES (Detail lines)
- GL_LEDGERS (Ledger information)
- GL_PERIODS (Accounting periods)
-
Table: GL_JE_HEADERS
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_HEADERS, object_name:GL_JE_HEADERS, status:VALID, product: GL - General Ledger , description: Journal entry headers , implementation_dba_data: GL.GL_JE_HEADERS ,
-
Table: GL_JE_HEADERS
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_HEADERS, object_name:GL_JE_HEADERS, status:VALID, product: GL - General Ledger , description: Journal entry headers , implementation_dba_data: GL.GL_JE_HEADERS ,
-
Table: GL_ARCHIVE_HEADERS
12.2.2
product: GL - General Ledger , description: Archive journal headers , implementation_dba_data: Not implemented in this database ,
-
Table: GL_IMPORT_REFERENCES
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_IMPORT_REFERENCES, object_name:GL_IMPORT_REFERENCES, status:VALID, product: GL - General Ledger , description: Cross-references between subledgers and Oracle General Ledger's journal entries , implementation_dba_data: GL.GL_IMPORT_REFERENCES ,
-
Table: GL_IMPORT_REFERENCES
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_IMPORT_REFERENCES, object_name:GL_IMPORT_REFERENCES, status:VALID, product: GL - General Ledger , description: Cross-references between subledgers and Oracle General Ledger's journal entries , implementation_dba_data: GL.GL_IMPORT_REFERENCES ,
-
Table: GL_ARCHIVE_HEADERS
12.1.1
product: GL - General Ledger , description: Archive journal headers , implementation_dba_data: Not implemented in this database ,
-
View: GLFV_ENCUMB_JOURNAL_ENTRIES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_ENCUMB_JOURNAL_ENTRIES, object_name:GLFV_ENCUMB_JOURNAL_ENTRIES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLFV_ENCUMB_JOURNAL_ENTRIES ,
-
View: GLFV_ENCUMB_JOURNAL_ENTRIES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GLFV_ACTUAL_JOURNAL_ENTRIES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GLFV_ACTUAL_JOURNAL_ENTRIES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_ACTUAL_JOURNAL_ENTRIES, object_name:GLFV_ACTUAL_JOURNAL_ENTRIES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLFV_ACTUAL_JOURNAL_ENTRIES ,
-
View: GLFV_JOURNAL_ENTRIES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_JOURNAL_ENTRIES, object_name:GLFV_JOURNAL_ENTRIES, status:VALID, product: GL - General Ledger , description: General Ledger journal entries are groups of related journal lines that record debit and credit amounts to General Ledger accounts. , implementation_dba_data: APPS.GLFV_JOURNAL_ENTRIES ,
-
View: GLFV_JOURNAL_ENTRIES
12.2.2
product: GL - General Ledger , description: General Ledger journal entries are groups of related journal lines that record debit and credit amounts to General Ledger accounts. , implementation_dba_data: Not implemented in this database ,
-
View: GLFV_BUDGET_JOURNAL_ENTRIES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_BUDGET_JOURNAL_ENTRIES, object_name:GLFV_BUDGET_JOURNAL_ENTRIES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLFV_BUDGET_JOURNAL_ENTRIES ,
-
View: GLFV_BUDGET_JOURNAL_ENTRIES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
Table: GL_JE_LINES_RECON
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_LINES_RECON, object_name:GL_JE_LINES_RECON, status:VALID, product: GL - General Ledger , implementation_dba_data: GL.GL_JE_LINES_RECON ,
-
Table: GL_UPGRADE_STATUS
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_UPGRADE_STATUS, object_name:GL_UPGRADE_STATUS, status:VALID, product: GL - General Ledger , implementation_dba_data: GL.GL_UPGRADE_STATUS ,
-
Table: GL_JE_SEGVALS_UPGRADE
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_SEGVALS_UPGRADE, object_name:GL_JE_SEGVALS_UPGRADE, status:VALID, product: GL - General Ledger , implementation_dba_data: GL.GL_JE_SEGVALS_UPGRADE ,
-
Table: GL_UPGRADE_STATUS
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_UPGRADE_STATUS, object_name:GL_UPGRADE_STATUS, status:VALID, product: GL - General Ledger , implementation_dba_data: GL.GL_UPGRADE_STATUS ,
-
Table: GL_JE_SEGVALS_UPGRADE
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_SEGVALS_UPGRADE, object_name:GL_JE_SEGVALS_UPGRADE, status:VALID, product: GL - General Ledger , implementation_dba_data: GL.GL_JE_SEGVALS_UPGRADE ,
-
Table: GL_JE_LINES_RECON
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_LINES_RECON, object_name:GL_JE_LINES_RECON, status:VALID, product: GL - General Ledger , implementation_dba_data: GL.GL_JE_LINES_RECON ,
-
Table: GL_JE_SEGMENT_VALUES
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_SEGMENT_VALUES, object_name:GL_JE_SEGMENT_VALUES, status:VALID, product: GL - General Ledger , description: Journal entry balancing and management segment values. , implementation_dba_data: GL.GL_JE_SEGMENT_VALUES ,
-
Table: GL_JE_SEGMENT_VALUES
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_SEGMENT_VALUES, object_name:GL_JE_SEGMENT_VALUES, status:VALID, product: GL - General Ledger , description: Journal entry balancing and management segment values. , implementation_dba_data: GL.GL_JE_SEGMENT_VALUES ,
-
Table: GL_JOURNAL_REPORTS_ITF
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JOURNAL_REPORTS_ITF, object_name:GL_JOURNAL_REPORTS_ITF, status:VALID, product: GL - General Ledger , description: Interface table for RXi Oracle General Ledger journal reports. , implementation_dba_data: GL.GL_JOURNAL_REPORTS_ITF ,
-
Table: GL_AUTO_ALLOC_REV_BATCHES
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_AUTO_ALLOC_REV_BATCHES, object_name:GL_AUTO_ALLOC_REV_BATCHES, status:VALID, product: GL - General Ledger , description: Reverse journal batches generated by AutoAllocation rollback process , implementation_dba_data: GL.GL_AUTO_ALLOC_REV_BATCHES ,
-
Table: GL_AUTO_ALLOC_REV_BATCHES
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_AUTO_ALLOC_REV_BATCHES, object_name:GL_AUTO_ALLOC_REV_BATCHES, status:VALID, product: GL - General Ledger , description: Reverse journal batches generated by AutoAllocation rollback process , implementation_dba_data: GL.GL_AUTO_ALLOC_REV_BATCHES ,
-
Table: GL_INTERFACE_HISTORY
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_INTERFACE_HISTORY, object_name:GL_INTERFACE_HISTORY, status:VALID, product: GL - General Ledger , description: Imported journal entry batches , implementation_dba_data: GL.GL_INTERFACE_HISTORY ,
-
Table: GL_INTERFACE_HISTORY
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_INTERFACE_HISTORY, object_name:GL_INTERFACE_HISTORY, status:VALID, product: GL - General Ledger , description: Imported journal entry batches , implementation_dba_data: GL.GL_INTERFACE_HISTORY ,
-
Table: GL_JOURNAL_REPORTS_ITF
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JOURNAL_REPORTS_ITF, object_name:GL_JOURNAL_REPORTS_ITF, status:VALID, product: GL - General Ledger , description: Interface table for RXi Oracle General Ledger journal reports. , implementation_dba_data: GL.GL_JOURNAL_REPORTS_ITF ,
-
Table: GL_RECURRING_HEADERS
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_RECURRING_HEADERS, object_name:GL_RECURRING_HEADERS, status:VALID, product: GL - General Ledger , description: Recurring journal entry and budget formula headers , implementation_dba_data: GL.GL_RECURRING_HEADERS ,
-
View: GL_JE_HEADERS_LOV_V
12.1.1
product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: Not implemented in this database ,
-
Table: GL_INTERFACE
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_INTERFACE, object_name:GL_INTERFACE, status:VALID, product: GL - General Ledger , description: Import journal entry batches , implementation_dba_data: GL.GL_INTERFACE ,
-
Table: GL_INTERFACE
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_INTERFACE, object_name:GL_INTERFACE, status:VALID, product: GL - General Ledger , description: Import journal entry batches , implementation_dba_data: GL.GL_INTERFACE ,
-
View: GL_JE_HEADERS_LOV_V
12.2.2
product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: Not implemented in this database ,
-
Table: GL_BC_PACKETS
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_BC_PACKETS, object_name:GL_BC_PACKETS, status:VALID, product: GL - General Ledger , description: Budgetary control queue table , implementation_dba_data: GL.GL_BC_PACKETS ,
-
Table: GL_BC_PACKETS
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_BC_PACKETS, object_name:GL_BC_PACKETS, status:VALID, product: GL - General Ledger , description: Budgetary control queue table , implementation_dba_data: GL.GL_BC_PACKETS ,
-
Table: GL_RECURRING_HEADERS
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_RECURRING_HEADERS, object_name:GL_RECURRING_HEADERS, status:VALID, product: GL - General Ledger , description: Recurring journal entry and budget formula headers , implementation_dba_data: GL.GL_RECURRING_HEADERS ,
-
Table: GL_BC_PACKETS_HISTS
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_BC_PACKETS_HISTS, object_name:GL_BC_PACKETS_HISTS, status:VALID, product: GL - General Ledger , description: GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control packets that are deleted from table GL_BC_PACKETS. , implementation_dba_data: GL.GL_BC_PACKETS_HISTS ,
-
View: GLBV_JOURNAL_LINES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLBV_JOURNAL_LINES, object_name:GLBV_JOURNAL_LINES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLBV_JOURNAL_LINES ,
-
Table: GL_BC_PACKETS_HISTS
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_BC_PACKETS_HISTS, object_name:GL_BC_PACKETS_HISTS, status:VALID, product: GL - General Ledger , description: GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control packets that are deleted from table GL_BC_PACKETS. , implementation_dba_data: GL.GL_BC_PACKETS_HISTS ,
-
View: GLBV_JOURNAL_LINES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
Table: GL_ENCUMBRANCE_TYPES
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_ENCUMBRANCE_TYPES, object_name:GL_ENCUMBRANCE_TYPES, status:VALID, product: GL - General Ledger , description: Encumbrance type definitions , implementation_dba_data: GL.GL_ENCUMBRANCE_TYPES ,
-
Table: GL_ENCUMBRANCE_TYPES
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_ENCUMBRANCE_TYPES, object_name:GL_ENCUMBRANCE_TYPES, status:VALID, product: GL - General Ledger , description: Encumbrance type definitions , implementation_dba_data: GL.GL_ENCUMBRANCE_TYPES ,
-
View: GL_PERIOD_STATUSES_REV_BUD_V
12.1.1
product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: Not implemented in this database ,
-
View: GL_PERIOD_STATUSES_REV_BUD_V
12.2.2
product: GL - General Ledger , description: 10SC ONLY , implementation_dba_data: Not implemented in this database ,
-
View: GLFV_JOURNAL_LINES
12.2.2
product: GL - General Ledger , description: General Ledger journal lines record debit or credit amounts to General Ledger accounts, or use formulas to calculate journal amounts for General Ledger accounts. , implementation_dba_data: Not implemented in this database ,
-
View: GLFV_JOURNAL_LINES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLFV_JOURNAL_LINES, object_name:GLFV_JOURNAL_LINES, status:VALID, product: GL - General Ledger , description: General Ledger journal lines record debit or credit amounts to General Ledger accounts, or use formulas to calculate journal amounts for General Ledger accounts. , implementation_dba_data: APPS.GLFV_JOURNAL_LINES ,
-
View: GLBV_JOURNAL_BATCHES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLBV_JOURNAL_BATCHES, object_name:GLBV_JOURNAL_BATCHES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLBV_JOURNAL_BATCHES ,
-
View: GLBV_JOURNAL_BATCHES
12.2.2
product: GL - General Ledger , implementation_dba_data: Not implemented in this database ,
-
View: GLBV_ENCUMB_JOURNAL_BATCHES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLBV_ENCUMB_JOURNAL_BATCHES, object_name:GLBV_ENCUMB_JOURNAL_BATCHES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLBV_ENCUMB_JOURNAL_BATCHES ,
-
View: GLBV_ENCUMB_JOURNAL_ENTRIES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GLBV_ENCUMB_JOURNAL_ENTRIES, object_name:GLBV_ENCUMB_JOURNAL_ENTRIES, status:VALID, product: GL - General Ledger , implementation_dba_data: APPS.GLBV_ENCUMB_JOURNAL_ENTRIES ,