Search Results get_fun_prd_status

Overview

The APPS.FUN_PERIOD_STATUS_PKG package is a component of the Oracle E-Business Suite Financials (FUN) module, providing the core logic for managing accounting period status across the transaction-processing framework. In EBS 12.1.1 and 12.2.2, this package governs the lifecycle of period status records held in FUN_PERIOD_STATUSES — the table that determines whether a given accounting period is Open, Closed, or in a pending state for a specific subsystem such as Payables, Receivables, Assets, or Purchasing. By centralizing period open/close logic and transactional sweep processing, the package acts as the operational engine behind period-end close procedures and cross-module period synchronization.

The ETRM metadata classifies this object as an "OTHER" API — meaning it is not part of Oracle's formally supported public API set, but it is heavily referenced internally by standard EBS code (including FUN_TRX_PVT and other packages). Its status is VALID in the APPS schema.

Key Procedures and Functions

The documented package exposes six procedures/functions. Parameter signatures are not disclosed in the ETRM documentation; only their names and inferred purposes are described here.

• CLOSE_PERIOD — Executes the period-close operation for a given period and application context, updating the corresponding period status row to a closed state and typically triggering downstream processing that prevents further transaction entry.
• GET_PERIOD_STATUS — Retrieves the current status of a period (or the status applicable to a given transaction date), returning the value used throughout FUN to gate transaction entry.
• SWEEP_PARTIAL_BATCHES — Processes incomplete or partially posted transaction batches associated with the period, moving or completing them so that the period can be closed cleanly.
• SWEEP_TRANSACTIONS — Sweeps open transactions into the appropriate accounting period, helping reconcile transactions that may have been entered near a period boundary.
• SYNC_CALENDARS — Reconciles or synchronizes calendar and period definitions across subsystems, ensuring consistent period structures before status changes are applied.
• GET_FUN_PRD_STATUS — A helper function that returns the FUN-specific period status code, likely used internally by GET_PERIOD_STATUS to distinguish FUN-level status from the broader shared status model.

Tables Accessed

The package reads and writes a broad set of FUN transactional and reference tables. Core status control resides in FUN_PERIOD_STATUSES, supported by FUN_SYSTEM_OPTIONS for system-level configuration.

• FUN_TRX_HEADERS, FUN_TRX_HEADERS_S, FUN_TRX_LINES, FUN_TRX_BATCHES, FUN_TRX_BATCHES_S, FUN_DIST_LINES, FUN_DIST_LINES_S — the transaction and distribution data swept and validated during sweep/close operations.
• AP_INVOICES_INTERFACE — referencing inbound Payables invoice data during cross-module period activity.
• FND_ATTACHED_DOCUMENTS, FND_ATTACHED_DOCUMENTS_S, FND_DOCUMENTS, FND_DOCUMENTS_TL, FND_LANGUAGES — the attachments and multilingual document tables used in close packets and audit documentation.

All access is performed through APPS synonyms, ensuring the package operates under the standard EBS schema-privilege model.

Usage Notes

FUN_PERIOD_STATUS_PKG is primarily invoked internally by standard EBS forms and concurrent programs during period-end close, transaction sweeps, and calendar maintenance. Its documented external referencer (FUN_TRX_PVT) suggests the package is also called through the FUN transaction processing layer when validating transaction dates and period statuses.

Because ETRM classifies this as an "OTHER" API rather than a supported public API, custom code should not depend on its signatures or behavior, especially across 12.1.1 and 12.2.2 where internal implementation may vary. Customizations that must manipulate period status should use the documented supported interfaces or, where unavoidable, invoke the package with the understanding that Oracle does not guarantee backward compatibility.