Search Results entered_period_name

Overview

OKL_PERIOD_TYPES_UV is a documented Oracle E-Business Suite view owned by the APPS schema within the OKL – Lease and Finance Management product family. It is classified as a VIEW with VALID status in the ETRM 12.2.2 repository. The view consolidates accounting calendar definitions from the General Ledger period model into a single denormalized result set that Lease and Finance Management modules can consume without directly joining GL calendar entities. Because lease contracts, payment schedules, and accounting events in OKL must be aligned to open or future GL periods, this view acts as a bridge between the GL period infrastructure and OKL reporting, validation, and integration logic. The presence of the ENTERED_PERIOD_NAME column, which is the term most often searched against this object, reflects the requirement to reconcile a period entered by a user with its normalized calendar counterpart.

Underlying Base Objects

The view is defined over three documented base objects: GL_PERIODS (referenced as a synonym), GL_PERIOD_TYPES (referenced as a synonym), and the package OKL_ACCOUNTING_UTIL. The core query joins GL_PERIODS aliased as PER to GL_PERIOD_TYPES aliased as PT on the PERIOD_TYPE column. From GL_PERIODS the view draws period-level attributes such as period name, set name, dates, fiscal year, period number, quarter, the entered period name, adjustment flag, descriptive flexfield columns, and standard Who columns. From GL_PERIOD_TYPES it draws period-type descriptors including USER_PERIOD_TYPE and NUMBER_PER_FISCAL_YEAR. The package OKL_ACCOUNTING_UTIL is invoked through GET_LOOKUP_MEANING('YEAR_TYPE_IN_NAME', PT.YEAR_TYPE_IN_NAME, 101, 101) to translate the stored year-type code into a displayable lookup meaning exposed as the YEAR_TYPE column.

Key Columns

The primary exposed columns include:

• ROW_ID — the GL_PERIODS ROWID, provided as a unique identifier for the underlying period row.
• PERIOD_NAME — the normalized accounting period name from GL_PERIODS.
• ENTERED_PERIOD_NAME — the period name as entered by the user, which is the column most frequently targeted in searches and reconciliation queries.
• PERIOD_SET_NAME — the accounting calendar (period set) to which the period belongs.
• START_DATE / END_DATE — the effective date boundaries of the period.
• PERIOD_TYPE / USER_PERIOD_TYPE — the internal and user-facing period type descriptors from GL_PERIODS and GL_PERIOD_TYPES respectively.
• PERIOD_YEAR, PERIOD_NUM, QUARTER_NUM — fiscal year, period sequence number, and quarter.
• ADJUSTMENT_PERIOD_FLAG — indicates whether the period is an adjustment period.
• NUMBER_PER_FISCAL_YEAR — the count of periods per fiscal year for the period type.
• YEAR_TYPE — the decoded lookup meaning for the year-type-in-name attribute.
• Flexfield and audit columns (CONTEXT, ATTRIBUTE1 through ATTRIBUTE8, CREATION_DATE, CREATED_BY, and the last-update columns) inherited from GL_PERIODS.

Common Use Cases and Queries

Typical scenarios include validating that a lease accounting period is open, resolving an entered period name to its canonical period, and driving period-based reporting for lease schedules. A representative query locating a period by its entered name is:

SELECT PERIOD_NAME, ENTERED_PERIOD_NAME, PERIOD_SET_NAME, START_DATE, END_DATE, PERIOD_TYPE, PERIOD_YEAR, QUARTER_NUM, ADJUSTMENT_PERIOD_FLAG FROM APPS.OKL_PERIOD_TYPES_UV WHERE ENTERED_PERIOD_NAME = :entered_period_name;

Reporting queries commonly filter on PERIOD_SET_NAME and a date range to produce calendar listings, or group by PERIOD_YEAR and QUARTER_NUM for lease portfolio aging. Because the view exposes ROW_ID and the complete audit footprint, it also supports integration routines that must round-trip period identifiers and change-tracking information between OKL and external systems.