Search Results item category codes

The CS_SR_TYPE_ITEMCAT_MAPS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 plays a critical role in the Service Request (SR) module, particularly in mapping service request types to item categories. This table facilitates the association between service request types defined in the CS_INCIDENT_TYPES_B table and item categories from the MTL_ITEM_CATEGORIES table, enabling organizations to streamline service request categorization and reporting based on product or item classifications.

Table Structure and Key Columns

The CS_SR_TYPE_ITEMCAT_MAPS table consists of the following key columns:

SR_TYPE_ITEMCAT_MAP_ID: Primary key identifier for the mapping record.
INCIDENT_TYPE_ID: Foreign key referencing CS_INCIDENT_TYPES_B.INCIDENT_TYPE_ID, linking to the service request type.
CATEGORY_ID: Foreign key referencing MTL_ITEM_CATEGORIES.CATEGORY_ID, linking to the item category.
ORGANIZATION_ID: Specifies the inventory organization to which the mapping applies (references ORG_ORGANIZATION_DEFINITIONS).
START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period of the mapping.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Audit columns tracking record creation and modifications.

Functional Significance

This mapping table enables organizations to:

Standardize Service Request Classification: By associating SR types with item categories, businesses ensure consistent categorization of service requests based on product lines or service offerings.
Enable Automated Assignment Rules: The mappings support the configuration of assignment rules in CS_SR_ASSIGN_CRITERIA, allowing automatic routing of SRs to appropriate support teams based on product categories.
Facilitate Reporting and Analytics: The relationship allows for granular reporting on service requests by product category, aiding in trend analysis and service level monitoring.
Support Multi-Org Implementations: The ORGANIZATION_ID column enables distinct mappings per inventory organization, critical for multi-org deployments.

Integration Points

The table integrates with several key EBS modules:

Inventory Management: Through the MTL_ITEM_CATEGORIES relationship, ensuring alignment with item master data.
Service Contracts: Supporting service entitlement validation when contracts are tied to specific product categories.
Installed Base: Enabling service requests to be linked to products in the installed base through their category associations.

Technical Considerations

Implementation teams should note:

The table is subject to the Oracle Trading Community Architecture (TCA) security model when used in multi-org environments.
Indexes exist on INCIDENT_TYPE_ID, CATEGORY_ID, and ORGANIZATION_ID for performance optimization.
Data is typically maintained through the Service Request Administrator responsibility via the "Service Request Types" form.
In version 12.2.2, the table may be subject to Online Patching (ADOP) requirements during maintenance.

Common Use Cases

Typical implementations leverage this table for:

Configuring product-specific service workflows
Implementing category-based service level agreements (SLAs)
Enabling warranty validation based on product categories
Supporting service analytics by product family

The CS_SR_TYPE_ITEMCAT_MAPS table represents a critical junction between service management and product data in Oracle EBS, enabling organizations to deliver more contextual and efficient customer service operations.

File: R12 Service Codes ERD.pdf 12.1.1
product: CS - Service , size: 96.463 KBytes , file_type: PDF Diagram ,
File: R12 Service Codes ERD.pdf 12.2.2
product: CS - Service , size: 96.463 KBytes , file_type: PDF Diagram ,
File: R12 Service Codes Usage ERD.pdf 12.1.1
product: CS - Service , size: 92.173 KBytes , file_type: PDF Diagram ,
File: R12 Service Codes Usage ERD.pdf 12.2.2
product: CS - Service , size: 92.173 KBytes , file_type: PDF Diagram ,
Lookup Type: CS_SR_TGT_SEARCH_RULES 12.2.2
product: CS - Service , meaning: Task Template Serach Rule Codes , description: Task Template Search Rule Codes ,
Lookup Type: CS_SR_TGT_SEARCH_RULES 12.1.1
product: CS - Service , meaning: Task Template Serach Rule Codes , description: Task Template Search Rule Codes ,
Lookup Type: CS_SR_PRODUCT_RELATION_TYPE 12.2.2
product: CS - Service , meaning: Service : Item , Item Category, None selection , description: Item , Item Category, None selection ,
Lookup Type: CS_SR_PRODUCT_RELATION_TYPE 12.1.1
product: CS - Service , meaning: Service : Item , Item Category, None selection , description: Item , Item Category, None selection ,
Lookup Type: CSZ_SAGT_INSTANCE_LIST_FILTER 12.1.1
product: CS - Service , meaning: Customer Support Agent Instance List Filter , description: Customer Support Agent Instance List Filter ,
Lookup Type: CSZ_SAGT_INSTANCE_LIST_FILTER 12.2.2
product: CS - Service , meaning: Customer Support Agent Instance List Filter , description: Customer Support Agent Instance List Filter ,
Lookup Type: CSZ_SAGT_INSTANCE_SRCH_FILTER 12.1.1
product: CS - Service , meaning: Customer Support Agent Instance Search Filter , description: Customer Support Agent Instance Search Filter ,
Lookup Type: CSZ_SAGT_INSTANCE_SRCH_FILTER 12.2.2
product: CS - Service , meaning: Customer Support Agent Instance Search Filter , description: Customer Support Agent Instance Search Filter ,
Lookup Type: CS_SR_AUDIT_FIELDS 12.1.1
product: CS - Service , meaning: CS_SR_AUDIT_FIELDS ,
Lookup Type: CS_SR_AUDIT_FIELDS 12.2.2
product: CS - Service , meaning: CS_SR_AUDIT_FIELDS ,
Lookup Type: CS_CONTACT_CATEGORY 12.2.2
product: CS - Service , meaning: CS Contact Category , description: CS Contact Category ,
Lookup Type: CS_BILLING_CATEGORY 12.1.1
product: CS - Service , meaning: Service Billing Category , description: Billing Category for Billing Types ,
Lookup Type: CS_CONTACT_CATEGORY 12.1.1
product: CS - Service , meaning: CS Contact Category , description: CS Contact Category ,
Lookup Type: CS_BILLING_CATEGORY 12.2.2
product: CS - Service , meaning: Service Billing Category , description: Billing Category for Billing Types ,
Lookup Type: CS_SR_DUP_CRITERIA 12.2.2
product: CS - Service , meaning: Service: Service Requests Duplicate Criteria , description: Service: Service Requests Duplicate Criteria ,
Lookup Type: CS_SR_DUP_CRITERIA 12.1.1
product: CS - Service , meaning: Service: Service Requests Duplicate Criteria , description: Service: Service Requests Duplicate Criteria ,
Lookup Type: CS_SR_EAM_SERIAL_NUM_SOURCE 12.1.1
product: CS - Service , meaning: Lookup type - source of values in Serial Num LOV for EAM SRs , description: Lookup type - source of values in Serial Num LOV for EAM SRs ,
Lookup Type: ACCESS_TEMPLATE_ENTITY 12.1.1
product: CS - Service , meaning: ACCESS_TEMPLATE_ENTITY , description: Entities for Access Control Template ,
Lookup Type: ACCESS_TEMPLATE_ENTITY 12.2.2
product: CS - Service , meaning: ACCESS_TEMPLATE_ENTITY , description: Entities for Access Control Template ,
Lookup Type: CS_SR_EAM_SERIAL_NUM_SOURCE 12.2.2
product: CS - Service , meaning: Lookup type - source of values in Serial Num LOV for EAM SRs , description: Lookup type - source of values in Serial Num LOV for EAM SRs ,
Lookup Type: CSZ_INCIDENT_SKTYPES_SDESKITIL 12.2.2
product: CS - Service , meaning: HTML Service Service Key Lookup for Service Desk ITIL Flavor , description: HTML Service Service Key Lookup for Service Desk ITIL Flavor ,
Lookup Type: REPORT_CPI_ORDER 12.2.2
product: CS - Service , meaning: REPORT_CPI_ORDER , description: Sorted by method on Customer Product Installations Report ,
Lookup Type: CSZ_INCIDENT_ITIL_TYPE 12.2.2
product: CS - Service , meaning: Service Key Lookup for ITIL ,
Lookup Type: REPORT_CPI_ORDER 12.1.1
product: CS - Service , meaning: REPORT_CPI_ORDER , description: Sorted by method on Customer Product Installations Report ,
Table: CS_SR_TYPE_ITEMCAT_MAPS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_TYPE_ITEMCAT_MAPS, object_name:CS_SR_TYPE_ITEMCAT_MAPS, status:VALID, product: CS - Service , description: This table will store the mapping information, between the service request type and item category. , implementation_dba_data: CS.CS_SR_TYPE_ITEMCAT_MAPS ,
Table: CS_SR_TYPE_ITEMCAT_MAPS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_TYPE_ITEMCAT_MAPS, object_name:CS_SR_TYPE_ITEMCAT_MAPS, status:VALID, product: CS - Service , description: This table will store the mapping information, between the service request type and item category. , implementation_dba_data: CS.CS_SR_TYPE_ITEMCAT_MAPS ,
Lookup Type: SERVICE_ITEM_TYPE 12.2.2
product: CS - Service , meaning: SERVICE_ITEM_TYPE , description: Service Program Type ,
Lookup Type: SERVICE_ITEM_TYPE 12.1.1
product: CS - Service , meaning: SERVICE_ITEM_TYPE , description: Service Program Type ,
Lookup Type: ACCESS_AUTO_TEMPLATE_ENTITY 12.1.1
product: CS - Service , meaning: ACCESS_AUTO_TEMPLATE_ENTITY , description: Access auto template entity ,
Lookup Type: ACCESS_AUTO_TEMPLATE_ENTITY 12.2.2
product: CS - Service , meaning: ACCESS_AUTO_TEMPLATE_ENTITY , description: Access auto template entity ,
Lookup Type: CS_PARTYROLE_TYPES 12.2.2
product: CS - Service , meaning: Type List Item in the Define Notification Rules page , description: Look up for the Type List Item in the Define Notification Rules page. ,
Lookup Type: CS_PARTYROLE_TYPES 12.1.1
product: CS - Service , meaning: Type List Item in the Define Notification Rules page , description: Look up for the Type List Item in the Define Notification Rules page. ,
Lookup Type: CS_CHG_DEF_PARENT_VAL 12.2.2
product: CS - Service , meaning: CS_CHG_DEF_PARENT_VAL , description: Values for Profile Service: Default Parent Information ,
Lookup Type: CS_SR_DUPLICATE_REASON_CODE 12.2.2
product: CS - Service , meaning: Service: Duplicate Check found Reason Code , description: Service: Duplicate Check found Reason Code ,
Lookup Type: CS_SR_DUPLICATE_REASON_CODE 12.1.1
product: CS - Service , meaning: Service: Duplicate Check found Reason Code , description: Service: Duplicate Check found Reason Code ,
Lookup Type: CS_SR_FILTERBY_SRTAB 12.1.1
product: CS - Service , meaning: Service request tab fileter by list , description: Service request tab fileter by list ,
Lookup Type: CS_SR_FILTERBY_SRTAB 12.2.2
product: CS - Service , meaning: Service request tab fileter by list , description: Service request tab fileter by list ,
Lookup Type: INTERACTION_DOCUMENT 12.2.2
product: CS - Service , meaning: INTERACTION_DOCUMENT , description: Type of reference document of customer interaction ,
Lookup Type: INTERACTION_DOCUMENT 12.1.1
product: CS - Service , meaning: INTERACTION_DOCUMENT , description: Type of reference document of customer interaction ,
Lookup Type: INC_AUDIT_ATTRIBUTES 12.1.1
product: CS - Service , meaning: INC_AUDIT_ATTRIBUTES , description: Incident attributes that have audit history ,
Lookup Type: INC_AUDIT_ATTRIBUTES 12.2.2
product: CS - Service , meaning: INC_AUDIT_ATTRIBUTES , description: Incident attributes that have audit history ,
Lookup Type: INCIDENT_SUBTYPE 12.2.2
product: CS - Service , meaning: INCIDENT_SUBTYPE , description: Used to select between Incidents and Product Change Requests ,
Lookup Type: INCIDENT_SUBTYPE 12.1.1
product: CS - Service , meaning: INCIDENT_SUBTYPE , description: Used to select between Incidents and Product Change Requests ,
Lookup Type: CS_SR_SERV_REQ_ENABLED_TYPE 12.1.1
product: CS - Service , meaning: CS_SR_SERV_REQ_ENABLED_TYPE , description: Used to determine if an item can have a Service Request logged for it. ,
Lookup Type: CS_SR_SERV_REQ_ENABLED_TYPE 12.2.2
product: CS - Service , meaning: CS_SR_SERV_REQ_ENABLED_TYPE , description: Used to determine if an item can have a Service Request logged for it. ,
Lookup Type: INC_SERVICE_VALIDATION_TYPE 12.1.1
product: CS - Service , meaning: INC_SERVICE_VALIDATION_TYPE , description: Type of service allowed in incident entry form ,