CMR_PROCESS_RUN

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_N2	Non Unique	Default	P_SOLD_TO_BUSINESS_UNIT_ID, PROCESS_NAME
CMR_PROCESS_RUN_DTLS_PK	Unique	FUSION_TS_TX_DATA	PROCESS_RUN_ID