Search Results gl_transaction_dates




Overview
Explore in AI Chat

Overview

The GL_TRANSACTION_DATES table is a core configuration table within the Oracle E-Business Suite General Ledger module. It defines the specific operational calendar used for financial transaction processing by storing the classification of each calendar date as either a business or non-business day. This table is essential for enforcing accounting period statuses, enabling or disabling journal entry posting, and calculating due dates for transactions like payables and receivables based on a defined working calendar. Its integrity is critical for accurate period-end closing and compliant financial reporting.

Key Information Stored

The table's structure is designed to map dates to a specific transaction calendar. The primary key, GL_TRANSACTION_DATES_PK, enforces uniqueness on the combination of TRANSACTION_CALENDAR_ID and TRANSACTION_DATE. The TRANSACTION_CALENDAR_ID is a foreign key that links each date record to its parent calendar defined in the GL_TRANSACTION_CALENDAR table. The TRANSACTION_DATE column holds the actual calendar date. While the provided ETRM excerpt does not list all columns, a standard implementation includes a flag or descriptive column (often named something like DAY_TYPE or DESCRIPTION) to explicitly designate the date as a business day, holiday, weekend, or other non-business classification.

Common Use Cases and Queries

This table is primarily queried by the application's internal logic to validate transaction dates. Common operational and reporting scenarios include validating if a given date is a valid business day for posting, generating reports of holidays for a specific calendar, and calculating due dates. A typical validation query would be:

  • SELECT COUNT(*) FROM gl_transaction_dates WHERE transaction_calendar_id = :cal_id AND transaction_date = :proposed_date AND day_type = 'BUSINESS';

Another common pattern is to list all non-business days for a calendar year to aid in period planning:

  • SELECT transaction_date, description FROM gl_transaction_dates WHERE transaction_calendar_id = :cal_id AND day_type != 'BUSINESS' AND transaction_date BETWEEN :start_date AND :end_date ORDER BY 1;

Related Objects

The GL_TRANSACTION_DATES table has a direct and fundamental relationship with the GL_TRANSACTION_CALENDAR table, as defined by its foreign key. The transaction calendar itself is assigned to a Ledger or Set of Books, influencing all transaction processing for that financial entity. This table is also intrinsically linked to the GL_PERIOD_STATUSES table, as the opening and closing of periods are governed by the business days defined in the associated transaction calendar. Various APIs and concurrent processes within the General Ledger, Payables, and Receivables modules will reference this table to enforce date-based business rules.