[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CM_ACPR_CTL |
|---|---|
| Object Type: | TABLE |
| Owner: | GMF |
| FND Design Data: |  GMF.CM_ACPR_CTL
|
| Subobject Name: | |
| Status: | VALID |
The Actual Cost Process Control Table will allow the OPM user to communicate with the Actual Cost Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort. See Actual Cost Process for further details.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CM_ACPR_CTL_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ACPROC_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACPROC_ID | NUMBER | (10) | Yes | Actual Cost process reference number |
| CALENDAR_CODE | VARCHAR2 | (4) | Cost Calendar | |
| PERIOD_CODE | VARCHAR2 | (4) | Cost Period | |
| COST_MTHD_CODE | VARCHAR2 | (4) | Actual Costing Method. Defaulted to the costing method of the Cost Calendar entered but can be changed to any actual costing method. | |
| RUNNING_IND | NUMBER | (5) | Yes | Process running indicator 0 = no, 1 = yes |
| SCHEDULED_ON | VARCHAR2 | (32) | Yes | Date and time the process was scheduled to run. This field may contain the value of SY$NOW designated to mean start process immediately |
| STARTED_BY | NUMBER | (15) | Yes | Who started the process (SY$OP_CODE) |
| STARTED_ON | DATE | When the process started (SY$SYS_DATE) | ||
| ENDED_ON | DATE | Date and time when process ended or was aborted SY$SYS_DATE | ||
| ITEMS_PROCESSED | NUMBER | (10) | Total items processed so far. | |
| RECEIPTS_PROCESSED | NUMBER | (10) | Total receipts processed so far | |
| BATCHES_PROCESSED | NUMBER | (10) | Total batches processed so far. | |
| ERRORS_FOUND | NUMBER | (10) | Total number of errors found. Includes duplicates. | |
| ERRORS_POSTED | NUMBER | (10) | Total number of errors posted. Does not include duplicates. | |
| ERRORS_LIMIT | NUMBER | (10) | Yes | Limit of errors to tolerate, value is taken from CM$AC_ERRORS_LIMIT |
| ACPROC_STAGE | NUMBER | (5) | Indicates the stage of process and if the process abnormally ends, provides indicator 1, 2, 3 etc as determined by developer , and be used as diagnostic | |
| ABORT_IND | NUMBER | (5) | Yes | Used to abort the process 0=no, 1=yes, abort process. 2=aborted |
| ABORT_BY | NUMBER | (15) | Who aborted the process | |
| ABORT_REASON | VARCHAR2 | (70) | Reason for aborting the process | |
| DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| 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 | |
| REQUEST_ID | NUMBER | (15) | Concurrent requst who column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent requst who column | |
| PROGRAM_ID | NUMBER | (15) | Concurrent requst who column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent requst who column | ||
| DEFAULT_LANGUAGE | VARCHAR2 | (4) | User Default Language | |
| COST_TYPE_ID | NUMBER | cost type identifier | ||
| INTORDERS_PROCESSED | NUMBER | (15) | Internal orders processed flag | |
| INVOICES_PROCESSED | NUMBER | (15) | invoices processed flag | |
| LEGAL_ENTITY_ID | NUMBER | (15) | legal entity identifier | |
| MISCRCPT_PROCESSED | NUMBER | (15) | Misc Receipt processed flag | |
| PERIOD_ID | NUMBER | (15) | period identifier | |
| OPERATING_UNIT_ID | NUMBER | OPERATING_UNIT_ID |
Cut, paste (and edit) the following text to query this object:
SELECT ACPROC_ID
, CALENDAR_CODE
, PERIOD_CODE
, COST_MTHD_CODE
, RUNNING_IND
, SCHEDULED_ON
, STARTED_BY
, STARTED_ON
, ENDED_ON
, ITEMS_PROCESSED
, RECEIPTS_PROCESSED
, BATCHES_PROCESSED
, ERRORS_FOUND
, ERRORS_POSTED
, ERRORS_LIMIT
, ACPROC_STAGE
, ABORT_IND
, ABORT_BY
, ABORT_REASON
, DELETE_MARK
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, IN_USE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DEFAULT_LANGUAGE
, COST_TYPE_ID
, INTORDERS_PROCESSED
, INVOICES_PROCESSED
, LEGAL_ENTITY_ID
, MISCRCPT_PROCESSED
, PERIOD_ID
, OPERATING_UNIT_ID
FROM GMF.CM_ACPR_CTL;
GMF.CM_ACPR_CTL does not reference any database object
GMF.CM_ACPR_CTL is referenced by following:
GMF
CM_ACPR_CTL#
|
|
|
|