[Home] [Help] [Dependency Information]
Object Name: | CM_CUPD_CTL |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.CM_CUPD_CTL |
Subobject Name: | |
Status: | VALID |
Cost Update Process Control Table - allows the OPM user to communicate with the Cost Update Process as it is running in the background and review parameters of the process. Using this table, the user can review past runs and force the process to abort. One can also review run parameters like the total number of costs posted to the GL area, errors if any that were found, the process start and end date/times, and the user(s) who submitted/aborted the process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CM_CUPD_CTL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CUPROC_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUPROC_ID | NUMBER | (10) | Yes | Cost Update process reference number (also a surrogate to the rows in the control table) |
CALENDAR_CODE | VARCHAR2 | (4) | Cost Calendar for which the Cost Update process was initiated | |
CO_CODE | VARCHAR2 | (4) | Company the Cost Calendar is defined for | |
PERIOD_CODE | VARCHAR2 | (4) | Cost Period for which the Cost Update process was initiated | |
PERIOD_STATUS | NUMBER | (6) | Yes | Status of the Costing Period: 0 - Open, 1 - Frozen. Cost Update cannot be run for Closed Costing Periods (status = 2) |
COST_MTHD_CODE | VARCHAR2 | (4) | Cost Method for which the Cost Update process was initiated | |
FINAL_UPDATE | NUMBER | (1) | Yes | Set when the costs are to be frozen in CDA and GL area at the end of Cost Update process. 0 = Preliminary Cost Update run; 1 = Final Update, freeze the costs. |
RUNNING_IND | NUMBER | (5) | Yes | Indicates if the process is running or not. 0 - Not yet started; 1 - Running; 2 - Completed. Process can be aborted when running_ind is 0 or 1. |
SCHEDULED_ON | VARCHAR2 | (32) | Yes | Date and time when the process is scheduled for |
STARTED_BY | NUMBER | (15) | Yes | User who initiates the process |
STARTED_ON | DATE | Date and time when process actually starts | ||
ENDED_ON | DATE | Date and time when process ends | ||
ERRORS_FOUND | NUMBER | (10) | Errors found during the process. Includes duplicates. | |
ERRORS_POSTED | NUMBER | (10) | Number of errors posted to the error message table (CM_CUPD_MSG). Does not include duplicates. | |
ROWS_POSTED | NUMBER | (10) | Number of Cost Rows posted to GL Cost table (GL_ITEM_CST). | |
ABORT_IND | NUMBER | (5) | Yes | Indicates whether the process should be aborted. Used by the Cost Update process to make a decision while running the process. 0 - Continue processing; 1 - Abort the Process; 2 - Process already aborted - used by the application to indicate an aborted process. |
ABORT_BY | NUMBER | (15) | User who aborts the process | |
ABORT_REASON | VARCHAR2 | (70) | Reason for aborting a running/scheduled process | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
IN_USE | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Yes | Standard delete mark |
REQUEST_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
DEFAULT_LANGUAGE | VARCHAR2 | (4) | User Default Language | |
COST_TYPE_ID | NUMBER | (15) | cost type identifier | |
LEGAL_ENTITY_ID | NUMBER | (15) | legal entity identifier | |
PERIOD_ID | NUMBER | (15) | period identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CUPROC_ID
, CALENDAR_CODE
, CO_CODE
, PERIOD_CODE
, PERIOD_STATUS
, COST_MTHD_CODE
, FINAL_UPDATE
, RUNNING_IND
, SCHEDULED_ON
, STARTED_BY
, STARTED_ON
, ENDED_ON
, ERRORS_FOUND
, ERRORS_POSTED
, ROWS_POSTED
, ABORT_IND
, ABORT_BY
, ABORT_REASON
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, IN_USE
, DELETE_MARK
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DEFAULT_LANGUAGE
, COST_TYPE_ID
, LEGAL_ENTITY_ID
, PERIOD_ID
FROM GMF.CM_CUPD_CTL;
GMF.CM_CUPD_CTL does not reference any database object
GMF.CM_CUPD_CTL is referenced by following:
|
|
|