Search Results table - ce.ce_statement_headers

The CS_PARTY_ROLES_B table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical entity within the Customer Service (CS) module, serving as the foundation for managing party roles in service-related transactions. This table stores essential role-based information for parties involved in service contracts, service requests, and other customer service operations. As part of Oracle's Trading Community Architecture (TCA), it integrates with the HZ_PARTIES and HZ_RELATIONSHIPS tables to maintain a comprehensive view of customer and partner interactions.

Table Structure and Key Columns

The CS_PARTY_ROLES_B table contains the following key columns:

PARTY_ROLE_ID: Primary key identifier for the party role record.
PARTY_ID: Foreign key referencing HZ_PARTIES, linking to the party (customer, vendor, or employee).
ROLE_TYPE: Defines the functional role (e.g., "BILL_TO," "SHIP_TO," "END_USER").
OBJECT_VERSION_NUMBER: Used for optimistic locking in OAF and ADF applications.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle audit columns.
START_DATE_ACTIVE and END_DATE_ACTIVE: Control role validity periods.

Functional Role in Oracle EBS

This table enables:

Service Contract Management: Associates parties with specific contract roles (e.g., contract administrator).
Service Request Processing: Identifies responsible parties for service fulfillment.
Billing and Shipping: Maintains role-based addresses through integration with HZ_PARTY_SITES.

Integration Points

CS_PARTY_ROLES_B integrates with:

TCA (HZ_*) tables for party master data
CS_SERVICE_REQUESTS for incident management
OKC_K_HEADERS_B for contract terms

Technical Considerations

For implementations:

Indexes exist on PARTY_ID and ROLE_TYPE for performance
Concurrent programs may reference this table during contract mass updates
Custom extensions should maintain TCA data integrity rules

Version-Specific Notes

Between 12.1.1 and 12.2.2:

Column structure remains consistent
12.2.2 may show improved query performance due to underlying database optimizations
No deprecated columns in 12.2.2

This table exemplifies Oracle's approach to role-based service management, providing a flexible framework for complex customer service scenarios while maintaining tight integration with the broader EBS architecture.

Table: CS_PARTY_ROLES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_PARTY_ROLES_B, object_name:CS_PARTY_ROLES_B, status:VALID, product: CS - Service , description: This is the base table for storing all the party role definitions. , implementation_dba_data: CS.CS_PARTY_ROLES_B ,
Table: CS_KB_ELEMENT_LINKS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_ELEMENT_LINKS, object_name:CS_KB_ELEMENT_LINKS, status:VALID, product: CS - Service , description: Knowledge base element links. This table implements the one to many relationship between an element and external entities. , implementation_dba_data: CS.CS_KB_ELEMENT_LINKS ,
Table: CS_SR_TYPE_CATEGORIES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_TYPE_CATEGORIES_B, object_name:CS_SR_TYPE_CATEGORIES_B, status:VALID, product: CS - Service , description: This table stores the service request type category information. , implementation_dba_data: CS.CS_SR_TYPE_CATEGORIES_B ,
Table: CS_KB_ATTRS_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_ATTRS_B, object_name:CS_KB_ATTRS_B, status:VALID, product: CS - Service , description: Knowledge base attributes (base table). Not used since before 11.5.8 , implementation_dba_data: CS.CS_KB_ATTRS_B ,
Table: CS_KB_WF_FLOWS_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_WF_FLOWS_B, object_name:CS_KB_WF_FLOWS_B, status:VALID, product: CS - Service , description: Solution flows base table , implementation_dba_data: CS.CS_KB_WF_FLOWS_B ,
Table: CSY_RESPONSE_RESOLUTIONS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CSY_RESPONSE_RESOLUTIONS, object_name:CSY_RESPONSE_RESOLUTIONS, status:VALID, product: CS - Service , description: This table contains summary of service request data by agents and groups. The service request summary contained in this table is: Backlog position for agent and group,. Number of Service Request Responded, Number of Service Request Resolved , implementation_dba_data: CS.CSY_RESPONSE_RESOLUTIONS ,
Table: CS_WEB_CONFERENCES 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_WEB_CONFERENCES, object_name:CS_WEB_CONFERENCES, status:VALID, product: CS - Service , description: Table to store web conference details for an SR. , implementation_dba_data: CS.CS_WEB_CONFERENCES ,
Table: CS_UPG_ERRORS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_UPG_ERRORS, object_name:CS_UPG_ERRORS, status:VALID, product: CS - Service , description: Upgrade error tracking table. , implementation_dba_data: CS.CS_UPG_ERRORS ,
Table: CS_COUNTER_VALUES 12.1.1
product: CS - Service , description: Historical readings of the counter. , implementation_dba_data: Not implemented in this database ,
Table: CS_CSZ_SRCH_CRITERIA 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_CSZ_SRCH_CRITERIA, object_name:CS_CSZ_SRCH_CRITERIA, status:VALID, product: CS - Service , description: This table stores information about the criteria in Saved Search. , implementation_dba_data: CS.CS_CSZ_SRCH_CRITERIA ,
Table: CS_KB_SECTION_DETAILS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_SECTION_DETAILS, object_name:CS_KB_SECTION_DETAILS, status:VALID, product: CS - Service , description: Not a generic feature. For OSS only. , implementation_dba_data: CS.CS_KB_SECTION_DETAILS ,
Table: CS_CTR_ESTIMATED_READINGS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_CTR_ESTIMATED_READINGS, object_name:CS_CTR_ESTIMATED_READINGS, status:VALID, product: CS - Service , description: Table to hold estimated readings , implementation_dba_data: CS.CS_CTR_ESTIMATED_READINGS ,
Table: CS_SR_LINK_VALID_OBJ 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_LINK_VALID_OBJ, object_name:CS_SR_LINK_VALID_OBJ, status:VALID, product: CS - Service , description: 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 of objects. For eg. a SR **cannot** be a 'Duplicate Of' a Defect, it can only be a 'Duplicate Of' ano , implementation_dba_data: CS.CS_SR_LINK_VALID_OBJ ,
Table: CS_PROD_CAT_SMRY 12.1.1
product: CS - Service , description: Table to store summarized category data. , implementation_dba_data: Not implemented in this database ,
Table: CS_INCIDENT_STATUSES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_STATUSES_TL, object_name:CS_INCIDENT_STATUSES_TL, status:VALID, product: CS - Service , description: This table contains translated information about Service Request statuses. , implementation_dba_data: CS.CS_INCIDENT_STATUSES_TL ,
Table: CS_INCIDENTS_PURGE_AUDIT_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_PURGE_AUDIT_TL, object_name:CS_INCIDENTS_PURGE_AUDIT_TL, status:VALID, product: CS - Service , description: This table contains the translatable attributes of a service request that was purged. , implementation_dba_data: CS.CS_INCIDENTS_PURGE_AUDIT_TL ,
Table: CS_SR_PROB_CODE_MAPPING 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_PROB_CODE_MAPPING, object_name:CS_SR_PROB_CODE_MAPPING, status:VALID, product: CS - Service , description: This table has the mappings of all the problem codes to SR types and Inventory items. , implementation_dba_data: CS.CS_SR_PROB_CODE_MAPPING ,
Table: CS_TEMPLATES_TL 12.1.1
product: CS - Service , description: This table holds the template metadata. , implementation_dba_data: Not implemented in this database ,
Table: CS_TP_QUESTIONS_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_TP_QUESTIONS_B, object_name:CS_TP_QUESTIONS_B, status:VALID, product: CS - Service , description: Template Driven SR Questions (base table). , implementation_dba_data: CS.CS_TP_QUESTIONS_B ,
Table: CS_CTR_UPLOAD_INSTANCES 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_CTR_UPLOAD_INSTANCES, object_name:CS_CTR_UPLOAD_INSTANCES, status:VALID, product: CS - Service , description: Interface table to store the item instances for mass upload , implementation_dba_data: CS.CS_CTR_UPLOAD_INSTANCES ,
Table: CS_INCIDENT_URGENCIES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_URGENCIES_TL, object_name:CS_INCIDENT_URGENCIES_TL, status:VALID, product: CS - Service , description: This table contains translated information about Service Request urgencies. , implementation_dba_data: CS.CS_INCIDENT_URGENCIES_TL ,
Table: CS_KB_LIB_LINKS_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_LIB_LINKS_TL, object_name:CS_KB_LIB_LINKS_TL, status:VALID, product: CS - Service , description: Not a generic feature. For OSS only. , implementation_dba_data: CS.CS_KB_LIB_LINKS_TL ,
Table: CS_KB_SOLN_CATEGORIES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_SOLN_CATEGORIES_TL, object_name:CS_KB_SOLN_CATEGORIES_TL, status:VALID, product: CS - Service , description: This table stores translated data defining a category for solutions. Parent base table is CS_KB_SOLN_CATEGORIES_B. , implementation_dba_data: CS.CS_KB_SOLN_CATEGORIES_TL ,
Table: CS_UPG_SLABS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_UPG_SLABS, object_name:CS_UPG_SLABS, status:VALID, product: CS - Service , description: A control table that is used for data migration. , implementation_dba_data: CS.CS_UPG_SLABS ,
Table: CS_SR_ACTION_CODES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_ACTION_CODES_TL, object_name:CS_SR_ACTION_CODES_TL, status:VALID, product: CS - Service , description: Translation table for all action definitions. , implementation_dba_data: CS.CS_SR_ACTION_CODES_TL ,
Table: CS_INST_DTL_INTERFACE 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INST_DTL_INTERFACE, object_name:CS_INST_DTL_INTERFACE, status:VALID, product: CS - Service , description: The interface table for installation details. , implementation_dba_data: CS.CS_INST_DTL_INTERFACE ,
Table: CS_KB_SET_RECS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_SET_RECS, object_name:CS_KB_SET_RECS, status:VALID, product: CS - Service , description: Knowledge base set recommendations. This table maintains a list of recommended sets or solutions. , implementation_dba_data: CS.CS_KB_SET_RECS ,
Table: CS_KB_WF_FLOWS_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_WF_FLOWS_TL, object_name:CS_KB_WF_FLOWS_TL, status:VALID, product: CS - Service , description: Solution flows translation table , implementation_dba_data: CS.CS_KB_WF_FLOWS_TL ,
Table: CS_CONTACTS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_CONTACTS, object_name:CS_CONTACTS, status:VALID, product: CS - Service , description: Party and employee information related to an entity. , implementation_dba_data: CS.CS_CONTACTS ,
Table: CS_KB_ELE_ATTR_VALS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_ELE_ATTR_VALS, object_name:CS_KB_ELE_ATTR_VALS, status:VALID, product: CS - Service , description: Knowledge base element attribute values. This table implements the many to many relationship between elements and attribute values. Not used since before 11.5.8 , implementation_dba_data: CS.CS_KB_ELE_ATTR_VALS ,
Table: CS_CTR_ASSOCIATIONS 12.1.1
product: CS - Service , description: Counter group associations to inventory items. , implementation_dba_data: Not implemented in this database ,
Table: CS_COST_STAGING 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_COST_STAGING, object_name:CS_COST_STAGING, status:VALID, product: CS - Service , implementation_dba_data: CS.CS_COST_STAGING ,
Table: CS_INCIDENT_LINKS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_LINKS, object_name:CS_INCIDENT_LINKS, status:VALID, product: CS - Service , description: Service Request can be linked to another Service Request or to any other object defined in JTF Objects. This link information is stored in this table. , implementation_dba_data: CS.CS_INCIDENT_LINKS ,
Table: CS_TIME_ZONES 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_TIME_ZONES, object_name:CS_TIME_ZONES, status:VALID, product: CS - Service , implementation_dba_data: CS.CS_TIME_ZONES ,
Table: CS_SYSTEM_OPTIONS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SYSTEM_OPTIONS, object_name:CS_SYSTEM_OPTIONS, status:VALID, product: CS - Service , description: This table stores Service Security Setup information , implementation_dba_data: CS.CS_SYSTEM_OPTIONS ,
Table: CS_FORUM_MESSAGES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_FORUM_MESSAGES_TL, object_name:CS_FORUM_MESSAGES_TL, status:VALID, product: CS - Service , description: Forum messages (translation table). , implementation_dba_data: CS.CS_FORUM_MESSAGES_TL ,
Table: CS_KB_CTXT_REPO_MAPS_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_CTXT_REPO_MAPS_TL, object_name:CS_KB_CTXT_REPO_MAPS_TL, status:VALID, product: CS - Service , description: This table stores the translateable information for the CS_KB_CTXT_REPO_MAPS_B table. , implementation_dba_data: CS.CS_KB_CTXT_REPO_MAPS_TL ,
Table: CS_SYSTEMS_ALL_B_TEMP 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SYSTEMS_ALL_B_TEMP, object_name:CS_SYSTEMS_ALL_B_TEMP, status:VALID, product: CS - Service , description: Temporary table to fix the Customer Id issue (Temporary data). , implementation_dba_data: CS.CS_SYSTEMS_ALL_B_TEMP ,
Table: CS_CF_FLOW_PAGES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_CF_FLOW_PAGES_TL, object_name:CS_CF_FLOW_PAGES_TL, status:VALID, product: CS - Service , description: This is the translation table for CS_CF_FLOW_PAGES_B. , implementation_dba_data: CS.CS_CF_FLOW_PAGES_TL ,
Table: CS_KB_LIB_SECTIONS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_LIB_SECTIONS, object_name:CS_KB_LIB_SECTIONS, status:VALID, product: CS - Service , description: Not a generic feature. For OSS only. , implementation_dba_data: CS.CS_KB_LIB_SECTIONS ,
Table: CS_PARTY_ROLE_GROUPS_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_PARTY_ROLE_GROUPS_B, object_name:CS_PARTY_ROLE_GROUPS_B, status:VALID, product: CS - Service , description: This is the base table for storing all the party role group definition. , implementation_dba_data: CS.CS_PARTY_ROLE_GROUPS_B ,
Table: CS_KB_AUTOLINK_USAGES 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_AUTOLINK_USAGES, object_name:CS_KB_AUTOLINK_USAGES, status:VALID, product: CS - Service , description: Knowlegde Base AutoLink Usages , implementation_dba_data: CS.CS_KB_AUTOLINK_USAGES ,
Table: CS_TP_TEMPLATE_LINKS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_TP_TEMPLATE_LINKS, object_name:CS_TP_TEMPLATE_LINKS, status:VALID, product: CS - Service , description: Template Driven SR and external objects linking table. This table implements the one to many relationship between a template and external entities. , implementation_dba_data: CS.CS_TP_TEMPLATE_LINKS ,
Table: CS_SR_ACTION_DETAILS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_ACTION_DETAILS, object_name:CS_SR_ACTION_DETAILS, status:VALID, product: CS - Service , description: Table contains action details associated to all event rules. , implementation_dba_data: CS.CS_SR_ACTION_DETAILS ,
Table: CS_TEMPLATES_B 12.1.1
product: CS - Service , description: This table holds the template metadata. , implementation_dba_data: Not implemented in this database ,
Table: CS_KB_HISTORIES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_HISTORIES_B, object_name:CS_KB_HISTORIES_B, status:VALID, product: CS - Service , description: Knowledge base histories (Base table). , implementation_dba_data: CS.CS_KB_HISTORIES_B ,
Table: CS_KB_REPORT_DATA 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_KB_REPORT_DATA, object_name:CS_KB_REPORT_DATA, status:VALID, product: CS - Service , description: Knowledge Base Report Data Summarization table. Not used since before 11.5.8 , implementation_dba_data: CS.CS_KB_REPORT_DATA ,
Table: CS_SR_TYPE_CATEGORIES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_TYPE_CATEGORIES_TL, object_name:CS_SR_TYPE_CATEGORIES_TL, status:VALID, product: CS - Service , description: This table stores translated information about service request type category. , implementation_dba_data: CS.CS_SR_TYPE_CATEGORIES_TL ,
Table: CS_CUSTOMER_PRODUCTS_ALL 12.1.1
product: CS - Service , description: The Customer installed base Products information. , implementation_dba_data: Not implemented in this database ,
Table: CS_FORUM_CATEGORIES_TL 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_FORUM_CATEGORIES_TL, object_name:CS_FORUM_CATEGORIES_TL, status:VALID, product: CS - Service , description: Forum categories (translation table). , implementation_dba_data: CS.CS_FORUM_CATEGORIES_TL ,