GL_PERIOD_STATUSES
GL_PERIOD_STATUSES contains the statuses of your accounting periods. Each row includes the accounting period name and status. Many applications maintain their calendars in this table, so each row also includes the relevant application identifier. CLOSING_STATUS is either 'O' for Open, 'F' for Future Enterable, 'C' for Closed, 'P' for Permanently Closed, or 'N' for Never Opened. Note that you cannot successfully open a period in your Oracle General Ledger application by changing a period's status to 'O' if it has never been opened before. You must use the Open and Close Periods form or programs to properly open a period.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_PERIOD_STATUSES_PK |
APPLICATION_ID, LEDGER_ID, PERIOD_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| APPLICATION_ID | NUMBER | 18 | Yes | Identifier associated with the application. | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Unique identifier of the ledger. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Fiscal period a company uses to report financial results, such as a calendar month or fiscal period. A portion of time in which the accounting calendar may be divided. Accounting periods make up an accounting calendar. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CLOSING_STATUS | VARCHAR2 | 1 | Yes | Indicates whether a period is open or closed. | ||
| START_DATE | DATE | Yes | Date when the accounting period begins. | |||
| END_DATE | DATE | Yes | Date when the accounting period ends. | |||
| YEAR_START_DATE | DATE | Yes | Date when the year containing this accounting period starts. | |||
| QUARTER_NUM | NUMBER | 18 | Yes | Quarter that an accounting period rolls up to. | ||
| QUARTER_START_DATE | DATE | Yes | Date on which the quarter containing this accounting period starts. | |||
| PERIOD_TYPE | VARCHAR2 | 15 | Yes | Accounting period type. Example are Weekly, Monthly, Quarterly. | ||
| PERIOD_YEAR | NUMBER | 18 | Yes | Denotes the accounting calendar year represented by a numerical value such as, 2009. | ||
| EFFECTIVE_PERIOD_NUM | NUMBER | 18 | Yes | Denormalized period number (PERIOD_YEAR*10000 + PERIOD_NUM). | ||
| PERIOD_NUM | NUMBER | 18 | Yes | Unique period number within accounting calendar year. | ||
| ADJUSTMENT_PERIOD_FLAG | VARCHAR2 | 1 | Yes | Calendar adjustment period flag. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ELIMINATION_CONFIRMED_FLAG | VARCHAR2 | 1 | Elimination confirmed flag of the period status. | |||
| CHRONOLOGICAL_SEQ_STATUS_CODE | VARCHAR2 | 1 | Status of chronological sequence maintenance. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Open and Close Periods (GL_PERIOD_STATUSES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Open and Close Periods (GL_PERIOD_STATUSES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Open and Close Periods (GL_PERIOD_STATUSES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Open and Close Periods (GL_PERIOD_STATUSES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Open and Close Periods (GL_PERIOD_STATUSES) | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Open and Close Periods (GL_PERIOD_STATUSES) | ||
| LEDGER_ID | NUMBER | 18 | Yes | Unique identifier of the ledger. | ||
| MIGRATION_STATUS_CODE | VARCHAR2 | 30 | Whether or not these period statuses are migrated from E-Business Suite. | |||
| TRACK_BC_YTD_FLAG | VARCHAR2 | 1 | Track budgetary debit or credit accounts as balance sheet accounts. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| OPEN_CLOSE_REQUESTED_STATUS | VARCHAR2 | 30 | The requested change to the closing status of a period submitted through a web service call. Possible values include: REQ_OPEN, SUCCESS_OPEN, REQ_CLOSE, SUCCESS_CLOSE. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_PERIOD_STATUSES | gl_ledgers | LEDGER_ID |
| GL_PERIOD_STATUSES | gl_period_types | PERIOD_TYPE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_PERIOD_STATUSES_N1 | Non Unique | Default | CLOSING_STATUS |
| GL_PERIOD_STATUSES_U1 | Unique | Default | APPLICATION_ID, LEDGER_ID, PERIOD_NAME |
| GL_PERIOD_STATUSES_U2 | Unique | Default | APPLICATION_ID, SET_OF_BOOKS_ID, EFFECTIVE_PERIOD_NUM, CLOSING_STATUS |
| GL_PERIOD_STATUSES_U3 | Unique | Default | APPLICATION_ID, SET_OF_BOOKS_ID, PERIOD_NAME |
| GL_PERIOD_STATUSES_U4 | Unique | Default | APPLICATION_ID, LEDGER_ID, EFFECTIVE_PERIOD_NUM, CLOSING_STATUS |
| GL_PERIOD_STATUSES_U5 | Unique | Default | APPLICATION_ID, PERIOD_YEAR, PERIOD_NUM, LEDGER_ID |