Search Results gl_je_headers
The GL_JE_HEADERS
table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a fundamental component of the General Ledger (GL) module, serving as the primary repository for journal entry header information. This table stores metadata and control attributes for journal entries, which are critical for financial reporting, compliance, and audit trails. Below is a detailed analysis of its structure, purpose, and key attributes.
Overview of GL_JE_HEADERS
TheGL_JE_HEADERS
table acts as the parent table for journal entries, linking to the GL_JE_LINES
table, which contains the detailed line items of each journal. Each record in GL_JE_HEADERS
represents a unique journal entry batch or a standalone journal, depending on the configuration. The table is integral to the GL subledger accounting process, ensuring data integrity and traceability.
Key Columns and Their Significance
- JE_HEADER_ID: A unique identifier for each journal entry header, serving as the primary key. This ID is referenced in
GL_JE_LINES
to associate lines with their respective headers. - LEDGER_ID: Specifies the ledger to which the journal belongs, aligning with Oracle's multi-org architecture. This ensures journals are posted to the correct financial reporting entity.
- JE_CATEGORY: Categorizes the journal (e.g., "Accrual," "Adjustment," "Revaluation"). This is critical for reporting and filtering journals by type.
- JE_SOURCE: Indicates the source of the journal (e.g., "Payables," "Receivables," "Manual"). This helps trace the origin of entries, especially for automated subledger integrations.
- PERIOD_NAME: The accounting period for which the journal is posted. Ensures entries are recorded in the correct fiscal period.
- NAME: A user-defined name or description for the journal, aiding in identification during audits or inquiries.
- STATUS: Reflects the journal's lifecycle stage (e.g., "Posted," "Unposted," "Approved"). Controls whether the journal is available for posting or modification.
- CURRENCY_CODE: The currency in which the journal is denominated, supporting multi-currency environments.
- ACTUAL_FLAG: Distinguishes between actual ("A"), budget ("B"), or encumbrance ("E") journals, critical for financial reporting.
- CREATION_DATE and CREATED_BY: Audit columns capturing when and by whom the journal was created.
Functional Role in Oracle EBS
TheGL_JE_HEADERS
table plays a pivotal role in:
- Journal Workflow: Journals progress through stages (draft, approved, posted) with status updates recorded here.
- Subledger Integration: Journals from subledgers (e.g., AP, AR) reference this table to ensure data consistency.
- Reporting & Compliance: Financial reports leverage this table to filter journals by period, category, or status.
- Audit Trails: Columns like
CREATION_DATE
andLAST_UPDATE_DATE
support audit requirements.
Technical Considerations
- Indexing: Key columns like
JE_HEADER_ID
,LEDGER_ID
, andPERIOD_NAME
are typically indexed for performance. - Partitioning: In large implementations, the table may be partitioned by
PERIOD_NAME
to optimize query performance. - Foreign Keys: Relationships with
GL_JE_LINES
,GL_LEDGERS
, and other tables enforce referential integrity.
Conclusion
TheGL_JE_HEADERS
table is a cornerstone of Oracle EBS General Ledger, providing the structural foundation for journal entry management. Its design ensures accurate financial data capture, supports multi-org and multi-currency operations, and facilitates robust reporting and compliance. Understanding its schema and relationships is essential for customization, troubleshooting, or performance tuning in Oracle EBS implementations.
-
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 ,
-
APPS.CST_UPD_GIR_MTA_WTA dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FUN_SEQ_BATCH dependencies on GL_JE_HEADERS
12.1.1
-
APPS.CE_AUTO_BANK_MATCH dependencies on GL_JE_HEADERS
12.1.1
-
APPS.IGI_ITR dependencies on GL_JE_HEADERS
12.1.1
-
APPS.IGI_POST dependencies on GL_JE_HEADERS
12.1.1
-
APPS.GL_JOURNAL_IMPORT_TAX_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.JE_GR_STATUTORY dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FV_SF224_TRANSACTIONS dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FV_FACTS_TRX_REGISTER dependencies on GL_JE_HEADERS
12.1.1
-
APPS.GL_JE_HEADERS_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.GL_JOURNAL_IMPORT_SLA_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.GL_DATE_HANDLER_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FV_FACTS1_GL_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.ARP_XLA_UPGRADE dependencies on GL_JE_HEADERS
12.1.1
-
APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.JE_GR_STATUTORY dependencies on GL_JE_HEADERS
12.2.2
-
APPS.FV_FACTS1_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.FUN_SEQ_BATCH dependencies on GL_JE_HEADERS
12.2.2
-
APPS.GL_AUTO_ALLOC_WF_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.ARP_XLA_UPGRADE dependencies on GL_JE_HEADERS
12.2.2
-
APPS.GL_WF_JE_APPROVAL_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.CST_UPD_GIR_MTA_WTA dependencies on GL_JE_HEADERS
12.2.2
-
APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.FV_FACTS_TRX_REGISTER dependencies on GL_JE_HEADERS
12.2.2
-
APPS.FV_FACTS_TBAL_TRX dependencies on GL_JE_HEADERS
12.2.2
-
APPS.JL_ZZ_FA_DRILL_DOWN_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.GL_AUTO_ALLOC_WF_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.GL_GLCRDR_XMLP_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.PA_BILL_REV_XLA_UPGRADE dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FV_FACTS_TBAL_TRX dependencies on GL_JE_HEADERS
12.1.1
-
APPS.AP_UTILITIES_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.ZX_JG_EXTRACT_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FUN_SEQ_BATCH dependencies on GL_JE_HEADERS
12.1.1
-
APPS.JL_ZZ_GL_COPY_JE_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FUN_RECON_RPT_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FV_FACTS_TRANSACTIONS dependencies on GL_JE_HEADERS
12.1.1
-
APPS.FA_MC_UPG3_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.GL_JE_SEGMENT_VALUES_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.JG_CREATE_JOURNALS_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.GL_JE_HEADER_SECURITY dependencies on GL_JE_HEADERS
12.1.1
-
APPS.GL_JE_LINES_RECON_PKG dependencies on GL_JE_HEADERS
12.1.1
-
APPS.JA_CN_AP_VALIDATION_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.JA_JAINBBR_XMLP_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.JG_ZZ_AERL_DT_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.ZX_GL_EXTRACT_PKG dependencies on GL_JE_HEADERS
12.2.2
-
APPS.JAI_CMN_RPT_BBR_PKG dependencies on GL_JE_HEADERS
12.2.2