Results for “gl_cutoff”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.JE_GR_STATUTORY is a statutorily oriented General Ledger utility package body belonging to the Oracle E-Business Suite General Ledger module. Its name reflects its origin as the "GR" statutory component of the JE (Journal Entry) family, traditionally associated with localized statutory reporting and journal sequencing requirements, particularly for Greek and other regulatory environments where journal documents require controlled numbering and cutoff enforcement. The package operates against posted General Ledger journal batches and headers, applying document sequencing rules tied to journal categories and ledger (set of books) definitions. The header comment references a Sun-era RCS version string (jegrstab.pls), confirming its lineage as a long-standing internal GL component shipped under the APPS schema.

The primary business function is to determine, for a given posting run and journal category/application combination, whether a journal should receive a statutory document sequence number, and to apply the appropriate cutoff rule so that journals falling past a defined period boundary are excluded from the current numbering run. This safeguards legal sequencing integrity across period-end boundaries.

Key Procedures and Functions

  • GL_SEQUENCE — Applies the statutory document sequence to eligible journal headers. It drives iteration over the posting-run cursor (c_headers), which selects actual, unposted-to-final-status batches joined to their headers, then derives the sequence context from the ledger and journal category. Parameter lists are not documented; only its sequencing role is described here.
  • GL_CUTOFF — Retrieves and enforces the cutoff rule for a given set-of-books (ledger), category, and application combination. It resolves the applicable cutoff definition so that journals beyond the cutoff are handled consistently.
  • CHECK_CUTOFF — Validates whether a journal batch/header falls within or beyond the applicable cutoff, returning the determination used by the sequencing logic.

Tables Accessed

  • GL_JE_BATCHES — Source of posting run and batch status; the cursor filters on actual_flag = 'A', posting_run_id, and status = 'I'.
  • GL_JE_HEADERS — Supplies journal category, ledger, and default effective date for each batch.
  • FND_DOC_SEQUENCE_CATEGORIES and FND_APPLICATION — Resolve the document sequence category and application (application short name 'SQLGL') linked to each journal category.
  • JE_GR_CUTOFF_RULES — Stores the statutory cutoff definitions consumed by GL_CUTOFF and CHECK_CUTOFF.

Usage Notes

JE_GR_STATUTORY is invoked internally during General Ledger journal posting and statutory sequencing flows rather than through a user-facing form. The user search term "case management statement form 1500" does not correspond to this object; JE_GR_STATUTORY is unrelated to case management or claims forms and concerns GL statutory journal sequencing. Because the object is classified as API "OTHER" and is referenced by one other package, it is intended primarily for internal GL processing. Customizations that call it should preserve the expected posting-run context and cutoff rule configuration in JE_GR_CUTOFF_RULES to avoid numbering gaps or duplicates. It is available across both 12.1.1 and 12.2.2, retaining the APPS ownership and synonym-based table access described above.