Search Results gl_sequence




Overview
Explore in AI Chat

Overview

The APPS.JE_GR_STATUTORY package is an Oracle E-Business Suite PL/SQL package that supports statutory journal entry processing for Greek localization requirements. Its primary business function is to enforce document sequencing and cut-off controls on General Ledger journal entries, ensuring that records comply with Greek statutory bookkeeping and reporting obligations. The package operates within the General Ledger (GL) schema, which is the central repository for all accounting transactions in EBS. By coordinating sequence assignment and cut-off date validation, it helps guarantee that statutory journals are numbered and dated according to legal requirements, which is critical for audit trails and regulatory filings. The package is classified as an OTHER API in the ETRM metadata, indicating it is not a public, externally supported API but rather an internal utility invoked by higher-level GL processes. It is marked VALID in the APPS schema, confirming its compiled state and availability for runtime execution. In EBS 12.1.1 and 12.2.2, such localization packages form part of the regional statutory compliance layer that sits alongside standard GL functionality.

Key Procedures and Functions

  • GL_SEQUENCE — Assigns or manages document sequence values for statutory journal entries, ensuring each transaction receives a legally compliant, sequential number in line with Greek statutory documentation rules.
  • GL_CUTOFF — Applies cut-off logic to journal entries, determining the appropriate accounting period or date boundary for transactions to satisfy statutory period-closing requirements.
  • CHECK_CUTOFF — Validates whether a given transaction or journal falls within permitted cut-off limits, returning a status used by calling programs to accept or reject entries.

These three documented procedures work together to enforce sequence integrity and date-based controls. The metadata does not expose parameter lists, and none should be assumed.

Tables Accessed

  • FND_APPLICATION — Used to resolve application identifiers, confirming the correct application context for statutory processing.
  • FND_DOC_SEQUENCE_CATEGORIES — Provides document sequence category definitions that govern how sequences are assigned to journals.
  • GL_JE_BATCHES — The journal batch table; read or updated when processing batch-level sequence and cut-off logic.
  • GL_JE_HEADERS — The journal header table; central to validating individual journals against cut-off and sequencing rules.
  • JE_GR_CUTOFF_RULES — A Greek localization table holding cut-off rule definitions, consulted by the cut-off procedures to determine applicable rules.

Usage Notes

The package is typically invoked indirectly by General Ledger journal posting and validation processes rather than by end users directly. The ETRM dependency data shows it is referenced by JG_GLPPOS_PKG, a posting-related package, confirming its role within the GL journal posting flow. It also references itself and standard SYS objects. Administrators and developers should treat JE_GR_STATUTORY as an internal, localization-specific component: it may be called through concurrent programs, forms, or custom extensions that post Greek statutory journals, but it is not documented as a public API. Customizations calling it directly should account for its OTHER classification, meaning Oracle does not guarantee its signature across patches or upgrades.