INV_INTERFACE_PROC_CONTROLS

INV_INTERFACE_PROC_CONTROLS is seeded with the list of background transaction processes Oracle Manufacturing supports. These background processes can have user- determined process intervals and for some you may decide the number of transaction rows each worker processes at a time. The PROCESS_STATUS column tells if the corresponding background process is active.

Details

• Schema: FUSION

• Object owner: INV

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
INV_INTERFACE_PROC_CONTROLS_PK	PROCESS_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PROCESS_CODE	NUMBER			Yes	Code name for the background process
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.
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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROCESS_STATUS	NUMBER			Yes	Process status which specifies if the background process is active or inactive
PROCESS_INTERVAL	NUMBER			Yes	Process interval at which the background process polls the interface table
MANAGER_PRIORITY	NUMBER			Yes	Concurrent process priority for the manager of the background process (not currently used)
WORKER_PRIORITY	NUMBER			Yes	Concurrent process priority for the workers launched by the background process (not currently used)
WORKER_ROWS	NUMBER			Yes	Maximum number of rows assigned to a worker
PROCESSING_TIMEOUT	NUMBER				Interval of time after which errored out rows will be processed again by the background process. This is used only by WIP managers.
PROCESS_NAME	VARCHAR2	10		Yes	This is name of the background process.
PROCESS_APP_SHORT_NAME	VARCHAR2	3			Application short name of the background process
PROGRAM_NAME	VARCHAR2	30			This is the name of the program.
PROGRAM_APP_NAME	VARCHAR2	50			This is the name of the program application.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
INV_INTERFACE_PROC_CONTROLS_U1	Unique	Default	PROCESS_CODE