CMR_PROCESS_RUN_DTLS
This table stores each process run details in Receipt Accounting module along with parameter values.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
CMR_PROCESS_RUN_DTLS_PK |
PROCESS_RUN_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PROCESS_RUN_ID | NUMBER | 18 | Yes | Process run identifier of each receipt accounting process group identifier and a surrogate key column. | |
PROCESS_NAME | VARCHAR2 | 250 | Yes | process name - 1. Receipt Accounting Distribution Process, 2. Uninvoice Receipt Accrual Process, 3. Match Receipt Accrual Process 4. Auto Accrual Process | |
P_SOLD_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Post R9 - Parameter to run all background processes in CMR - bill to business unit identifier Pre R9 - Parameter to all background processes in CMR - sold to business unit identifier. | |
P_GL_PERIOD_ID | NUMBER | 18 | Parameter to process Uninvoiced Receipt Accrual Process -GL period id FK to GL_PERIOD_STATUSES. | ||
P_FROM_DATE | TIMESTAMP | Parameter to process accrual reconciliation of purchase orders given form date - Match Receipt Accrual Process will pick events from SLA with accounted date more than or equal to from date. | |||
P_TO_DATE | TIMESTAMP | Parameter to process Match Receipt Accrual Process - process will pick events from SLA with accounted date less than or equal to to_date. | |||
ACCRUAL_CUTOFF_FLAG | VARCHAR2 | 1 | Stores the accrual cutoff is enabled or not. Y means it is enabled. N means not enabled. NULL means not enabled. | ||
ACCRUAL_OFFSET_DAYS | NUMBER | Stores accrual offset integer days and indicates the posting of a backed dated receipts or invoice variance lines to current or prior periods. | |||
ACCRUAL_CUTOFF_DATE | DATE | Accrual cut off date and derived based on accrual cut off days and current/prior GL period start, end dates. | |||
PROC_RUN_PERIOD_START_DATE | DATE | Process run date's current GL period start date. | |||
PROC_RUN_PERIOD_END_DATE | DATE | Process run date's period end date. | |||
PROC_RUN_PRIOR_PERIOD_START_DT | DATE | Process run date prior period end start date. | |||
PROC_RUN_PRIOR_PERIOD_END_DT | DATE | Process run date's prior period end date. | |||
TOTAL_PROCESSED_REC_CNT | NUMBER | 18 | Number of records processed for this request. | ||
ERROR_REC_CNT | NUMBER | 18 | Number of records errored for this request. For a transaction if we are not able to create distributions or not able to create the SLA event, it is marked as error record. Number of errors for each error code type stored in CMR_PROCESS_ERRORS table. | ||
PERIOD_END_ACCRUAL_ADJ_DATE | DATE | Period end accrual cut off and accounting date. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
PARENT_REQUEST_ID | NUMBER | 18 | Request identifier of the parent job. | ||
COMMIT_LIMIT | NUMBER | 18 | Identifies the Commit Limit used for the Receipt Accounting Processing. It is the unit of work to perform before committing the work to the database. | ||
ACCRUAL_RUN_MODE | VARCHAR2 | 5 | Mode in which Uninvoiced process to be run. | ||
INCLUDE_PO_STATUS | VARCHAR2 | 5 | Status of purchase orders to be considered while generating accrual amounts. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
cmr_accr_reconc_headers | cmr_process_run_dtls | PROCESS_RUN_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CMR_PROCESS_RUN_DTLS_N1 | Non Unique | Default | REQUEST_ID |
CMR_PROCESS_RUN_DTLS_PK | Unique | FUSION_TS_TX_DATA | PROCESS_RUN_ID |