eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_CP_SERVICES

Object Details

Object Name:	FND_CP_SERVICES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_CP_SERVICES
Subobject Name:
Status:	VALID

The FND_CP_SERVICES table stored information about the service definition

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_CP_SERVICES_U1	NORMAL	UNIQUE	APPS_TS_SEED	SERVICE_ID
FND_CP_SERVICES_U2	NORMAL	UNIQUE	APPS_TS_SEED	SERVICE_HANDLE
FND_CP_SERVICES_U3	NORMAL	UNIQUE	APPS_TS_SEED	SERVICE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SERVICE_ID	NUMBER	(15)	Yes	Unique id for the service, created by using sequence
SERVICE_HANDLE	VARCHAR2	(8)	Yes	Developer key for the service
SERVICE_NAME	VARCHAR2	(240)
CARTRIDGE_HANDLE	VARCHAR2	(8)	Yes	Developer key for cartridge
ALLOW_MULTIPLE_PROC_INSTANCE	VARCHAR2	(1)	Yes	Indicator whether or not the service allows more than one service process tobe active for an Apps instance
ALLOW_MULTIPLE_PROC_NODE	VARCHAR2	(1)	Yes	Indicator whether or not the service allows more thanone service process to be active for on a given node
MIGRATE_ON_FAILURE	VARCHAR2	(1)	Yes	Indicator whether or not service process can be movedto a secondary node when primary mode service fails
SERVER_TYPE	VARCHAR2	(1)	Yes	Indicates the type of applications server upon which the service runs
ALLOW_SUSPEND	VARCHAR2	(1)	Yes	Allow suspend or not
ALLOW_VERIFY	VARCHAR2	(1)	Yes	Indicates if the service will accept a command to verify its internal state
ALLOW_PARAMETER	VARCHAR2	(1)	Yes	Indicator whether the service allows a parameter string to be associated with each work shift
ALLOW_START	VARCHAR2	(1)	Yes	Indicates if the service can be started from the system administration user interface
ALLOW_RESTART	VARCHAR2	(1)	Yes	Indicates if a service process should be restarted by the ICM if that service process exits abnormally
PARAMETER_CHANGE_ACTION	VARCHAR2	(1)	Yes	In dicates the action that should be taken when the parameters for a service instance change when the active work shift changes
DEVELOPER_PARAMETERS	VARCHAR2	(2000)		Service specific cartridge parameter
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
ENV_FILE_NAME	VARCHAR2	(30)		Optional environment file for the service
ALLOW_CREATE	VARCHAR2	(1)		Indicates whether or not users should be allowed to create new service instances for this service
SERVICE_CLASS	VARCHAR2	(1024)		If not null, this points to the display class that should be used for the right pane of the OAM instead of the default class, when the Navigator focus is on the service
SERVICE_INSTANCE_CLASS	VARCHAR2	(1024)		If not null, this points to the display class that should be used for the right pane of the OAM instead of the default class, when the Navigator focus is on an instance of this service
ALLOW_RCG	VARCHAR2	(1)	Yes	Indicate whether or not the service definition user interface should allow a resource consumer group to be chosen for this service
OAM_DISPLAY_ORDER	NUMBER	(15)		Determines the order in which the services are listed in the Services branch of the OAM Navigator tree
ALLOW_EDIT	VARCHAR2	(1)	Yes	ALLOW_EDIT
ENABLED	VARCHAR2	(1)	Yes	Enabled Flag - Enabled Services can have Service Instances created
DEBUG_CHANGE_ACTION	VARCHAR2	(1)	Yes	Type of Action taken when debug level is changed.
CARTRIDGE_APPLICATION_ID	NUMBER	(15)		Application Id of cartridge
DEBUG_TYPE	VARCHAR2	(30)		Lookup type name for diagnostic level
ALLOW_MULTIPLE_PROC_SI	VARCHAR2	(1)		Allow multiple processes per Service Instance
DEFAULT_DEBUG_LEVEL	VARCHAR2	(1)		Default value for diagnostic level

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SERVICE_ID
,      SERVICE_HANDLE
,      SERVICE_NAME
,      CARTRIDGE_HANDLE
,      ALLOW_MULTIPLE_PROC_INSTANCE
,      ALLOW_MULTIPLE_PROC_NODE
,      MIGRATE_ON_FAILURE
,      SERVER_TYPE
,      ALLOW_SUSPEND
,      ALLOW_VERIFY
,      ALLOW_PARAMETER
,      ALLOW_START
,      ALLOW_RESTART
,      PARAMETER_CHANGE_ACTION
,      DEVELOPER_PARAMETERS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ENV_FILE_NAME
,      ALLOW_CREATE
,      SERVICE_CLASS
,      SERVICE_INSTANCE_CLASS
,      ALLOW_RCG
,      OAM_DISPLAY_ORDER
,      ALLOW_EDIT
,      ENABLED
,      DEBUG_CHANGE_ACTION
,      CARTRIDGE_APPLICATION_ID
,      DEBUG_TYPE
,      ALLOW_MULTIPLE_PROC_SI
,      DEFAULT_DEBUG_LEVEL
FROM APPLSYS.FND_CP_SERVICES;

Dependencies

[top of page]

APPLSYS.FND_CP_SERVICES does not reference any database object

APPLSYS.FND_CP_SERVICES is referenced by following:

APPS: FND_CP_SERVICES