Results for “org_acct_periods”

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

Overview

ORG_ACCT_PERIODS is the organization accounting period definition table owned by the INV (Inventory) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the accounting period calendar that governs costing and inventory valuation for each inventory organization. Every open, closed, or future accounting period recognized by an organization is represented as a row, and the table acts as the authoritative source for period status used throughout the Oracle Cost Management and Inventory transaction flows.

In addition to defining period dates, ORG_ACCT_PERIODS controls whether a period is open for transaction processing, tracks the scheduled and actual close dates, and records whether period summary data has been aggregated. Cost processors, period close routines, and inventory transaction managers reference this table to validate that transactions post to a valid, open period.

Under the heuristic Data Vault classification mined from its foreign key structure, ORG_ACCT_PERIODS functions as a hub. It anchors a unique business concept — the accounting period of a specific organization — and is referenced by numerous surrounding tables, which would be modeled as satellites or links in a Data Vault design.

Key Information Stored

The table contains 38 documented columns. The most significant for functional and reporting purposes are:

• ACCT_PERIOD_ID — Surrogate identifier for the accounting period instance; part of the composite primary key ORG_ACCT_PERIODS_PK.
• ORGANIZATION_ID — The inventory organization to which the period belongs; the second component of the primary key and a foreign key to MTL_PARAMETERS.
• PERIOD_SET_NAME — The accounting period set (calendar) that the period is drawn from; references GL_PERIODS.
• PERIOD_NAME — The user-visible name of the period, such as JAN-24.
• PERIOD_YEAR and PERIOD_NUM — The fiscal year and period number, used for sequencing and reporting.
• PERIOD_START_DATE — The effective start date of the accounting period.
• SCHEDULE_CLOSE_DATE — The planned date on which the period is scheduled to close.
• PERIOD_CLOSE_DATE — The actual date the period was closed.
• OPEN_FLAG — Indicates whether the period is currently open for transaction activity.
• SUMMARIZED_FLAG — Indicates whether period summary balances have been generated.
• DESCRIPTION — Free-form description of the period.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / CREATION_DATE / CREATED_BY — Standard WHO audit columns.

The surrogate primary key is ACCT_PERIOD_ID combined with ORGANIZATION_ID. Two unique indexes document business-key candidates: ORG_ACCT_PERIODS_U1 (ORGANIZATION_ID, ACCT_PERIOD_ID) and ORG_ACCT_PERIODS_U2 (ORGANIZATION_ID, PERIOD_YEAR, PERIOD_NUM, PERIOD_NAME). Twenty GLOBAL_ATTRIBUTE columns (GLOBAL_ATTRIBUTE_CATEGORY through GLOBAL_ATTRIBUTE20) provide the standard extensibility flexfield placeholders.

Common Use Cases and Queries

Typical usage revolves around verifying period status before posting transactions and reporting on period close cycles. A common query identifies the current open period for an organization:

• Join ORG_ACCT_PERIODS to MTL_PARAMETERS on ORGANIZATION_ID to resolve the organization context.
• Filter on OPEN_FLAG = 'Y' to isolate periods accepting transactions.
• Join to MTL_MATERIAL_TRANSACTIONS on ACCT_PERIOD_ID and ORGANIZATION_ID to attribute material movements to their accounting period.
• Use ORG_GL_BATCHES to trace cost management batches posted per accounting period.
• Compare SCHEDULE_CLOSE_DATE against PERIOD_CLOSE_DATE to measure close-cycle adherence.
• Aggregate MTL_PERIOD_SUMMARY and WIP_PERIOD_BALANCES by ACCT_PERIOD_ID for period-end cost reporting.

Sample predicate: SELECT acct_period_id, period_name, open_flag FROM org_acct_periods WHERE organization_id = :org AND open_flag = 'Y';

Related Objects

• MTL_PARAMETERS — Parent organization definition; joined on ORGANIZATION_ID.
• GL_PERIODS — General Ledger period source; joined on PERIOD_SET_NAME and PERIOD_NAME.
• MTL_MATERIAL_TRANSACTIONS — Inventory transactions keyed by ACCT_PERIOD_ID and ORGANIZATION_ID.
• MTL_PERIOD_SUMMARY and MTL_PERIOD_CG_SUMMARY — Aggregated period balances per organization.
• ORG_GL_BATCHES — Cost management GL transfer batches tied to the accounting period.
• WIP_PERIOD_BALANCES / WIP_TRANSACTIONS / WIP_MOVE_TRANSACTIONS — Work in Process activity referencing the accounting period.
• EAM_JOB_COMPLETION_TXNS / EAM_OP_COMPLETION_TXNS — Enterprise Asset Management completion transactions.
• CST_MGD_INFL_ADJUSTED_COSTS and related CST tables — Cost adjustment records tied to ACCT_PERIOD_ID.