CS Tables (224)

CS - Service — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
CSY_RESOLUTION_QLTY 20 This table Service Request Resolution quality summary for agents and groups
CSY_RESPONSE_RESOLUTIONS 31 This table contains summary of service request data by agents and groups. The service request summary contained in this table is: Backlog po
CS_BILLING_TYPE_CATEGORIES 13 This table defines the mapping of Billing types to Billing Categories
CS_BUSINESS_PROCESSES 35 Business Processes used in Service Billing
CS_BUS_PROCESS_TXNS 26 Transaction types associated with a business process
CS_CF_FLOWS_B 26 This table stores the flow instances of a particular flow type.
CS_CF_FLOWS_TL 10 This table is the translation table for CS_CF_FLOWS_B.
CS_CF_FLOW_PAGES_B 26 This table stores the activation status of pages within a particular flow type instances.
CS_CF_FLOW_PAGES_TL 11 This is the translation table for CS_CF_FLOW_PAGES_B.
CS_CF_FLOW_TYPE_PAGES 12 This table lists the pages available for each flow type.
CS_CF_SOURCE_CXT_TARGETS 49 This table stores the target code/id that stores the configuration for a particular source code and context.
CS_CF_SOURCE_CXT_TYPES 13 Stores the possible contexts that can be associated with each source.
CS_CHG_SUB_RESTRICTIONS 32 Charges Auto Submission Restrictions
CS_CONTACTS 36 Party and employee information related to an entity.
CS_COST_DETAILS 39
CS_COST_STAGING 5
CS_COUNTER_DER_FILTERS 34 Filter conditions for Group operations
CS_COUNTER_GRP_LOG 28 Counter group log of counter updates within a group
CS_CP_AUDIT 104 Audit information about products in the installed base
CS_CP_LANGUAGES 28 The languages appliacable to a product (to be used when Installed Base is used to store software products)
CS_CP_PARAMETERS 33 Used to extend CS_CUSTOMER_PRODUCTS_ALL table.
CS_CP_PARTIES_AUDIT 39 Stores audit history for the CS_CONTACTS table which holds the information of parties associated with an entity.
CS_CP_REVISIONS 62 Revision information about products in the installed base
CS_CSZ_SEARCHES 14 This table stores information about the HTML Service saved search.
CS_CSZ_SRCH_CRITERIA 13 This table stores information about the criteria in Saved Search.
CS_CSZ_SRCH_CRIT_GROUPS 10 This table stores information about the criteria group, which is a grouping of one or more search criteria.
CS_CSZ_SRCH_CRIT_VALUES 12 This table stores information about the criteria values used in search criteria.
CS_CSZ_SRCH_RESULT_COLS 11 This table stores information about the Saved Search result columns.
CS_CSZ_SRCH_SORTS 12 This table stores sorting information for a search in CS_CSZ_SEARCHES table.
CS_CTR_AUDIT 12 Audit information for Counters
CS_CTR_AUDIT_LINES 14 Audit line information for Counters
CS_CTR_ESTIMATED_READINGS 32 Table to hold estimated readings
CS_CTR_ESTIMATION_METHODS 34 Table for Estimation Methods
CS_CTR_FORMULA_BVARS 29 This table is not used
CS_CTR_UPLOAD_INSTANCES 12 Interface table to store the item instances for mass upload
CS_ESTIMATE_DETAILS 229 Transaction table that stores details of Charge lines in Service
CS_FORUM_ATTRS_B 25 Forum attributes (base table).
CS_FORUM_ATTRS_TL 11 Forum attributes (translation table).
CS_FORUM_CATEGORIES_B 26 Forum categories (base table).
CS_FORUM_CATEGORIES_TL 11 Forum categories (translation table).
CS_FORUM_CAT_ATTRS 26 Forum category attributes.
CS_FORUM_CAT_CATS 24 Forum category categories
CS_FORUM_CAT_LINKS 25 Forum category links.
CS_FORUM_CAT_MSGS 24 Forum category messages.
CS_FORUM_MESSAGES_B 30 Forum messages (base table).
CS_FORUM_MESSAGES_TL 12 Forum messages (translation table).
CS_FORUM_MSG_ATTRS 26 Forum message attributes
CS_FORUM_MSG_MSGS 24 Forum message messages
CS_FORUM_USER_CATS 25 Stores the association info between user and categories
CS_FORUM_USER_MSGS 25 Stores messages id that has been read by any particular users
CS_HZ_SR_CONTACT_PNTS_AUDIT 27 To maintain audit history for service request party role information.
CS_HZ_SR_CONTACT_POINTS 21 This table stores contact points for a service requests.
CS_INCIDENTS_ALL_B 293 This table stores non-translated information about service requests.
CS_INCIDENTS_ALL_TL 15 This table stores translated information about service requests.
CS_INCIDENTS_AUDIT_B 466 This table stores non-translated audit information for service requests.
CS_INCIDENTS_AUDIT_TL 11 This table stores translated audit information for service requests.
CS_INCIDENTS_EXT_AUDIT 262 This is an audit table and will track all changes made to the service request extensible attributes.
CS_INCIDENTS_EXT_B 134 Table to store Service Request Extensible Attribute records.
CS_INCIDENTS_EXT_TL 21
CS_INCIDENTS_PURGE_AUDIT_B 17 This table contains audit information generated by the Service Request Data Purge concurrent program.
CS_INCIDENTS_PURGE_AUDIT_TL 10 This table contains the translatable attributes of a service request that was purged.
CS_INCIDENTS_PURGE_STAGING 5 This table is used as a staging table that would store all the SRs that need to be purged for a set of parameters.
CS_INCIDENT_CYCLE_STEPS 34 This table stores information about related statuses.
CS_INCIDENT_LINKS 44 Service Request can be linked to another Service Request or to any other object defined in JTF Objects. This link information is stored in t
CS_INCIDENT_LINKS_EXT 25 From Release 11.5.9, this table WILL NOT BE USED. All links, irrespective of whether they are SR to SR links or SR to an external object
CS_INCIDENT_SEVERITIES_B 36 This table contains non-translated information about Service Request severities.
CS_INCIDENT_SEVERITIES_TL 11 This table contains translated information about Service Request severities.
CS_INCIDENT_STATUSES_B 55 This table contains non-translated information about Service Request statuses.
CS_INCIDENT_STATUSES_TL 12 This table contains translated information about Service Request statuses.
CS_INCIDENT_TYPES_B 48 This table contains non-translated information about Service Request type codes.
CS_INCIDENT_TYPES_TL 12 This table contains translated information about Service Request type codes.
CS_INCIDENT_URGENCIES_B 32 This table contains non-translated information about Service Request urgencies.
CS_INCIDENT_URGENCIES_TL 11 This table contains translated information about Service Request urgencies.
CS_INST_DTL_INTERFACE 36 The interface table for installation details.
CS_KB_ATTRS_B 25 Knowledge base attributes (base table). Not used since before 11.5.8
CS_KB_ATTRS_TL 11 Knowledge base attributes (translation table). Not used since before 11.5.8
CS_KB_ATTR_VALS_B 28 Knowledge base attribute values (base table). Not used since before 11.5.8
CS_KB_ATTR_VALS_TL 11 Knowledge base attribute values (translation table). Not used since before 11.5.8
CS_KB_AUTOLINKS_B 41 Knowledge Base Autolinks (Base Table)
CS_KB_AUTOLINKS_TL 14 Knowledge Base AutoLinks (Translation Table)
CS_KB_AUTOLINK_USAGES 12 Knowlegde Base AutoLink Usages
CS_KB_CACHE 12 Knowledge base cache table. Not used since before 11.5.8
CS_KB_CATEGORY_GROUPS_B 25 Knowledge Base Category Groups (Base Table)
CS_KB_CATEGORY_GROUPS_TL 11 Knowledge Base Category Groups (Translation Table)
CS_KB_CAT_GROUP_DENORM 9 Knowledge Base Category Group Denormalized Information
CS_KB_CAT_GROUP_FLOWS 23 Knowledge Base Category Group Flows (Linking Table)
CS_KB_CAT_GROUP_MEMBERS 23 Knowledge Base Category Group Members (Linking Table)
CS_KB_CONTEXTS 29 This table stores the context information used in Knowledge Management for the Repository Setup. The definition of a context is defined in t
CS_KB_CTXT_REPO_MAPS_B 29 This table stores the Relationship between a Tab and a Repository. This relationship is translated to a UI tab in the KM Search Module. The
CS_KB_CTXT_REPO_MAPS_TL 10 This table stores the translateable information for the CS_KB_CTXT_REPO_MAPS_B table.
CS_KB_ELEMENTS_B 35 Knowledge base elements (base table).
CS_KB_ELEMENTS_TL 12 Knowledge base elements (translation table).
CS_KB_ELEMENT_LINKS 27 Knowledge base element links. This table implements the one to many relationship between an element and external entities.
CS_KB_ELEMENT_TYPES_B 27 Knowledge base element types (base table).
CS_KB_ELEMENT_TYPES_TL 12 Knowledge base element types (translation table).
CS_KB_ELE_ATTR_VALS 25 Knowledge base element attribute values. This table implements the many to many relationship between elements and attribute values. Not use
CS_KB_ELE_CHG_HISTS 25 Knowledge base element change histories. Not used since before 11.5.8
CS_KB_ELE_ELES 30 Knowledge base element elements. This table implements the many to many relationship among the elements.
CS_KB_ELE_TYPE_ATTRS 26 Knowledge base element attribute types. This table implements the many to many relationship between element types and attribute types. Not
CS_KB_ELE_TYPE_LINKS 29 Knowledge base element type links. This table implements the one to many relationship between a element types and external entities.
CS_KB_HISTORIES_B 26 Knowledge base histories (Base table).
CS_KB_HISTORIES_TL 11 Knowledge base histories (translation table).
CS_KB_LIB_LINKS_TL 13 Not a generic feature. For OSS only.
CS_KB_LIB_PROPERTIES_B 11 Not a generic feature. For OSS only.
CS_KB_LIB_PROPERTIES_TL 10 Not a generic feature. For OSS only.
CS_KB_LIB_SECTIONS 10 Not a generic feature. For OSS only.
CS_KB_REPORT_DATA 12 Knowledge Base Report Data Summarization table. Not used since before 11.5.8
CS_KB_REPOSITORIES 30 This table stores the repository data. A repository is used to perform a search in the search module of Knowledge Management. A repository i
CS_KB_REPO_PROPERTIES 26 This table stoes the Properties of a Repository (CS_KB_REPOSITORIES). A Repository Property contains additional information about the Reposi
CS_KB_SECTIONS_B 8 Not a generic feature. For OSS only.
CS_KB_SECTIONS_TL 10 Not a generic feature. For OSS only.
CS_KB_SECTION_DETAILS 9 Not a generic feature. For OSS only.
CS_KB_SESSIONS 9 Knowledge Base Sessions table
CS_KB_SESSION_ATTRS 12 Knowledge Base Session Attributes table
CS_KB_SETS_B 45 Knowledge base sets (base table).
CS_KB_SETS_TL 17 Knowledge base sets (translation table).
CS_KB_SET_ATTR_VALS 25 Knowledge base set attribute values. This table implements the many to many relationship between sets and attribute values. Not used sinc
CS_KB_SET_CATEGORIES 23 Knowledge Base Solution Categories (Linking Table)
CS_KB_SET_CHG_HISTS 25 Knowledge base set change histories. This table implements the many to many relationship between sets and histories. Not used since befor
CS_KB_SET_ELES 26 Knowledge base set elements. This table implements the many to many relationship between sets and elements.
CS_KB_SET_ELE_TYPES 27 Knowledge base set element types. This table implements the many to many relationship between set types and element types.
CS_KB_SET_LINKS 28 Knowledge base set links. This table implements the one to many relationship between a set and external entities.
CS_KB_SET_PLATFORMS 9 Knowledge base set-platform linking table
CS_KB_SET_PRODUCTS 9 Knowledge base set-product linking table
CS_KB_SET_RECS 26 Knowledge base set recommendations. This table maintains a list of recommended sets or solutions.
CS_KB_SET_SETS 24 Knowledge base set sets. This table implements the many to many relationship between sets and sets. Not used since before 11.5.8
CS_KB_SET_TYPES_B 27 Knowledge base set types (base table).
CS_KB_SET_TYPES_TL 12 Knowledge base set types (translation table).
CS_KB_SET_TYPE_ATTRS 26 Knowledge base set type attributes. This table implements the many to many relationship between set types and attribute types. Not used s
CS_KB_SET_TYPE_LINKS 28 Knowledge base set type links. This table implements the one to many relationship between a set types and external entities. Not used sin
CS_KB_SET_USED_HISTS 26 Knowledge base set used histories.
CS_KB_SET_USED_SUMS 29 Knowledge base set used summaries. This table keep track of the used count over a period of time defined in the CS_KB_USED_SUM_DEFS_VL.
CS_KB_SOLN_CATEGORIES_B 10 This table stores non-translated data defining a category for solutions. This is a self referencing, one to many, tree structure of categori
CS_KB_SOLN_CATEGORIES_TL 12 This table stores translated data defining a category for solutions. Parent base table is CS_KB_SOLN_CATEGORIES_B.
CS_KB_USED_SUM_DEFS_B 27 Knowledge base used summary definitions(base table).
CS_KB_USED_SUM_DEFS_TL 12 knowledge base Used summary definitions (translation table).
CS_KB_VISIBILITIES_B 26 Knowledge Base Visibility Levels (Base Table)
CS_KB_VISIBILITIES_TL 11 Knowledge Base Visibilities (Translation Table)
CS_KB_WF_FLOWS_B 9 Solution flows base table
CS_KB_WF_FLOWS_TL 11 Solution flows translation table
CS_KB_WF_FLOW_DETAILS 14 Solution flow details table
CS_LINE_INST_DETAILS 47 Installation details of a product captured at the time of order or quote entry.
CS_MESSAGES 25 This table stores information about the messages sent from service requests and other documents.
CS_MULTI_ORG_RULES 9 This table defines the Multi Org Rules in CS and the Order in which the rules are to be used.
CS_OBJECT_RESP_MAPPINGS 11 Store any type of objects to responsibility association. Each object type is identified by an unique object type.
CS_OKS_UPGRADE_PW 5 This table is only used by service contracts upgrade process. This table is used for parallel worker distribution during upgrade.
CS_PARTY_ROLES_B 28 This is the base table for storing all the party role definitions.
CS_PARTY_ROLES_TL 11 This is a MLS table and stores party roles definition.
CS_PARTY_ROLE_GROUPS_B 28 This is the base table for storing all the party role group definition.
CS_PARTY_ROLE_GROUPS_TL 11 This is a MLS table and stores party role group definition.
CS_PARTY_ROLE_GROUP_MAPS 13 This table stores mappings between Party Role Groups and Party Roles.
CS_QM_FILTERS 18 FILTERS are pre-seeded and stores the information of a filter definition, such as the filter name. The combination of FILTER_CODE and FILER_
CS_QM_FOLDER_FILTERS 12 This table stores the instances of individual filters that belong to folders. The combination of USER_FOLDER_ID and FUNCTION_FILER_ID is uni
CS_QM_FUNCTION_FILTERS 15 It stores the relationship between functions and filters. The table has a foreign key to both the table CS_QM_FILTERS and FND_FORM_FUNCTIONS
CS_QM_USER_FOLDERS 12 This table stores folders that belong to users. It has a foreign key pointing to FND_USER.
CS_REPAIRS_ALL 68
CS_SERVICE_AVAILABILITY 36
CS_SERVICE_RESPONSIBILITY 11 This table stores SR Type access information when service security is turned on.
CS_SR_ACTION_CODES_B 16 Base table for all action definitions.
CS_SR_ACTION_CODES_TL 11 Translation table for all action definitions.
CS_SR_ACTION_DETAILS 21 Table contains action details associated to all event rules.
CS_SR_ACTION_TRIGGERS 16 This table contains event-condition details for all event rules.
CS_SR_ALLOWED_STATUSES 11 Stores information about the allowable statutes for a status rule.
CS_SR_AQ_TEMP 2 Internal table for High Avaialablity.
CS_SR_CONTACTS_EXT_AUDIT 266 This is an audit table and will track all changes made to the party role contacts extensible attributes.
CS_SR_CONTACTS_EXT_B 137 Table to store Party Role Extensible Attribute records.
CS_SR_CONTACTS_EXT_TL 24
CS_SR_DUP_CHECK_TMP 1
CS_SR_EVENT_ACTIONS 13 Tale defines valid event-action associations.
CS_SR_EVENT_CODES_B 16 Base table for all event definitions.
CS_SR_EVENT_CODES_TL 11 Translation table for all event defnitions.
CS_SR_LINK_TYPES_B 30 This table is used to store all the valid relationship Types between service request and service request and between service request and oth
CS_SR_LINK_TYPES_TL 12 This table has all the translation attributes for the base link type table, CS_SR_LINK_TYPES_B.It store the name and description of each lin
CS_SR_LINK_VALID_OBJ 16 Stores link types and the objects (in JTF Objects) that can be linked with the type. Links are restricted in use to only a selected number o
CS_SR_LOAD_BALANCE_WT 37 This table is used to store the weights for load balancing.
CS_SR_LOG_DATA_TEMP 10 Temporary table to store Log data for the JSP report to read directly.
CS_SR_PREFERRED_LANG 26 This table holds all the preferred languages.
CS_SR_PROB_CODE_MAPPING 30 This table has the mappings of all the problem codes to SR types and Inventory items.
CS_SR_PROB_CODE_MAPPING_DETAIL 33 This is the problem code mapping detail table. This table will contain the problem code -> search criteria association details.
CS_SR_RES_CODE_MAPPING 30 This table will contain the resolution code search criteria details. The resolution code -> search criteria association details will be stor
CS_SR_RES_CODE_MAPPING_DETAIL 34 This is the detail table. This table will contain the resolution code -> search criteria association details.
CS_SR_SAVED_ADV_CRITERIA 14 This table is used to store the advanced search columns and values in the service request saved searches module.
CS_SR_SAVED_BSC_CRITERIA 11 This table is used to store the basic search columns and values in the service request saved searches module.
CS_SR_SAVED_SEARCHES_B 26 This table stores all the saved searches for service request.
CS_SR_SAVED_SEARCHES_TL 10 This table is used to store the translated column for the service request saved searches.
CS_SR_STATUS_GROUPS_B 13 Stores non-translated Information about the status rules.
CS_SR_STATUS_GROUPS_TL 10 Stores translated Information about the status rules.
CS_SR_STATUS_TRANSITIONS 16 Stores information about the status transitions within allowable statuses associated with a status rule.
CS_SR_TSK_TMPL_GP_MAP 16 This table will store the mapping between template group and request type, product and product category.
CS_SR_TSK_TMPL_SEQ_RULES 12 The sequence in which a template group has to be searched would be defined in this table.
CS_SR_TYPE_CATEGORIES_B 27 This table stores the service request type category information.
CS_SR_TYPE_CATEGORIES_TL 11 This table stores translated information about service request type category.
CS_SR_TYPE_CAT_MAPPINGS 11 This table stores the mapping information, between the service request type and type category.
CS_SR_TYPE_ITEMCAT_MAPS 13 This table will store the mapping information, between the service request type and item category.
CS_SR_TYPE_MAPPING 33 This table maps service request types to responsibilities.
CS_SR_UWQ_NODES_B 22 Holds the non-translated definitions for UWQ Non-Media nodes.
CS_SR_UWQ_NODES_TL 11 Holds the translated definitions for UWQ Non-Media nodes.
CS_SYSTEM_AUDIT 64 Audit information for system attributes
CS_SYSTEM_OPTIONS 28 This table stores Service Security Setup information
CS_SYSTEM_PARAMETERS_ALL 58 Parameters for Oracle Service
CS_SYSTEM_PARTY_LINKS 12
CS_SYSTEM_SR_LINKS 12
CS_TIME_ZONES 30
CS_TM_LABOR_SCHEDULES 40 T&M Labor Schedules for Service Billing
CS_TP_CHOICES_B 29 Template Driven SR Choices (base table).
CS_TP_CHOICES_TL 10 Template Driven SR Choices (translation table).
CS_TP_FREETEXTS 25 Template Driven SR Answer type freetext table, stores the freetext size.
CS_TP_LOOKUPS 27 Lookup table for answer types.
CS_TP_QUESTIONS_B 30 Template Driven SR Questions (base table).
CS_TP_QUESTIONS_TL 12 Template Driven SR Questions (translation table).
CS_TP_TEMPLATES_B 28 Template Base Table
CS_TP_TEMPLATES_TL 11 CS Template Driven SR Template TL table
CS_TP_TEMPLATE_ATTRIBUTE 28 This table stores the urgency, severity ... attributes for a template
CS_TP_TEMPLATE_LINKS 28 Template Driven SR and external objects linking table. This table implements the one to many relationship between a template and external
CS_TP_TEMPLATE_QUESTIONS 25 template and question linking table.
CS_TRANSACTION_TYPES_B 47 Seeded and user-defined Transactions Types that determine processing rules for Charges
CS_TRANSACTION_TYPES_TL 12 Table to contain the translated attributes for the CS_TRANSACTION_TYPES_B table.
CS_TXN_BILLING_OETXN_ALL 11 This table maps transaction billing types from CS_TXN_BILLING_TYPES to Order Management transaction types by operating unit.
CS_TXN_BILLING_TYPES 35 This table maps one or more billing types to a specific transaction type.
CS_UPG_EMPLOYEES 4 Used for Employee to Resource Migration
CS_UPG_ERRORS 7 Upgrade error tracking table.
CS_UPG_SLABS 8 A control table that is used for data migration.
CS_WEB_CONFERENCES 14 Table to store web conference details for an SR.
SUGGESTIONSLIST 2