This appendix includes information on seeded security data.
This appendix covers the following topics:
This appendix lists seeded data for Oracle TeleService. You can enable or disable elements of the Oracle TeleService application including tabs, buttons, menus, and regions by mapping the functions listed in this appendix to responsibilities. You can use the seeded data security information as a guide to creating custom security.
Note: Do not modify seed data. Seed data is provided for you to use as delivered. If you want to make modifications, please make a copy and modify your copy.
This group of topics lists the functions you can map to responsibilities using procedures described in Oracle Applications System Administrator's Guide. It lists functions for:
This table lists the Contact Center functions you can map to responsibilities:
| Function | Description | Affected Tab or Window |
|---|---|---|
| CSCFAAB | Access the Account Interactions button on the Interactions tab | Contact Center Interactions tab |
| CSCSFACT | Access to the Accounts tab | Contact Center Accounts tab |
| CSCSFADB | Access to the Details button on the Accounts tab. This button launches the Customer Account Details window. | Contact Center Accounts tab |
| CSCSFADR | Access to the Addresses tab | Contact Center Addresses tab |
| CSCSFAIB | Access to the All Interactions button in the Interactions tab | Contact Center Interactions tab |
| CSCSFAMB | Access the Assignment Manager button next to the Owner and Assignee fields of the Tasks tab | Contact Center Tasks tab |
| CSCSFANB | Access to the Add Notes button on the Tasks tab | Contact Center Tasks tab |
| CSCSFAPB | Access to the Adjustment Processing button | Contact Center Invoices tab |
| CSCSFATB | Access the Details button on the Tasks tab | Contact Center Tasks tab |
| CSCSFCAD | Create and update addresses on the Addresses tab | Contact Center Addresses tab |
| CSCSFCAT | The ability to create accounts on the Accounts tab | Contact Center Accounts tab |
| CSCSFCCC | Ability to create a customer in Create Contact window | Create Contact window |
| CSCSFCCP | The ability to create and update contact points in the Contact Points tab | Contact Center Contact Points tab |
| CSCSFCIB | Access to the Call Information icon in the toolbar and the corresponding menu selection | Toolbar |
| CSCSFCNO | Create and update Notes on the Notes tab | Contact Center Notes tab |
| CSCSFCOL | Access to the Collateral tab | Contact Center Collateral Tab |
| CSCSFCPT | Access to the Contact Points tab | Contact Center Contact Points tab |
| CSCSFCRB | Access to the Contact Restrictions button on the Party Information tab | Contact Center Party Information tab |
| CSCSFCRD | Access to the Credit tab of the Customer Account Details window. | Contact Center Accounts tab Account Details Window |
| CSCSFCRE | The ability to create and update relationships on the Relationships tab. | Contact Center Relationships tab |
| CSCSFCSN | Access to the Customer Standard button on the Accounts Tab. This button launches the Customers - Standard window. | Contact Center Accounts tab |
| CSCSFCTK | Create a task on the Tasks tab | Contact Center Tasks tab |
| CSCSFCWU | Access to the Call Wrap Up icon in the toolbar and the corresponding menu selection | Toolbar |
| CSCSFDBU | Access to the Details button on the Party Information tab | Contact Center Party Information tab |
| CSCSFDSB | Access to the Dashboard tab* | Contact Center Dashboard tab |
| CSCSFECO | Access to the Edit Contact button | Contact Center header |
| CSCSFECT | Access to the Edit Customer button | Contact Center header |
| CSCSFECW | Access to the Open Email Compose Window icon in the Toolbar, the Contact Center header, and the Contact Points tab. This also controls access to the corresponding menu selection. | Contact Center header and tabs |
| CSCSFIAB | Access to the Identifying Address button on the Addresses tab. This button is used to create or change the customer's identifying address. | Contact Center Addresses tab |
| CSCSFIB | Access to the Install Base tab | Contact Center Install Base tab |
| CSCSFINT | Access to the Interactions tab | Contact Center Interactions tab |
| CSCSFINV | Access to the Invoices tab | Contact Center Invoices tab |
| CSCSFLWF | Access to the Launch Workflow button on the Tasks tab | Contact Center Tasks tab |
| CSCSFMBU | Access to the More button on the Tasks tab | Contact Center Tasks tab |
| CSCSFNCO | Access to the Create Contact button | Contact Center header |
| CSCSFNCT | Access to the Create Customer button | Contact Center header |
| CSCSFOKS | Access to the Contracts tab | Contact Center Contracts tab |
| CSCSFORD | Access to the Orders tab | Contact Center Orders tab |
| CSCSFPBU | Access to the Initiate Call button in the Contact Center header and Contact Points tab. This button is located next to the Phone field. | Contact Center header |
| CSCSFPDB | Access to the Payment Details button | Contact Center Invoices tab |
| CSCSFPPB | Access to the Payment Processing button | Contact Center Invoices tab |
| CSCSFPTY | Access to the Party Information tab | Contact Center Party Information tab |
| CSCSFQMB | Access to the Quick Menu icon in the toolbar and the corresponding menu selection | Toolbar |
| CSCSFRBU | Access to the Dashboard tab Refresh button | Contact Center Dashboard tab |
| CSCSFREL | Access to the Relationships tab | Contact Center Relationships tab |
| CSCSFROL | Access to the Roles tab of the Customer Account Details window and the ability to create and update roles. | Contact Center Accounts tab Account Details Window |
| CSCSFRTB | Access to the Relationships tab of the Customer Account Details window and the ability to create new relationships. | Contact Center Accounts tab Account Details Window |
| CSCSFSCB | Access to the Script icon in the toolbar and the corresponding menu selection | Toolbar |
| CSCSFSCP | Access to the Site Contact Points button on the Addresses tab. This button makes it possible to enter addresses for customer sites. | Contact Center Addresses tab |
| CSCSFSIT | Access to the Sites tab of the Customer Account Details window and the ability to create and update sites. | Contact Center Accounts tab Account Details Window |
| CSCSFSPB | Access to the Soft Phone icon in the toolbar and the corresponding menu selection | Toolbar |
| CSCSFSR | Access to the Service Request tab | Contact Center Service Request tab |
| CSCSFSUS | Access to the Suspensions tab of the Customer Account Details window. | Contact Center Accounts tab Account Details Window |
| CSCSFTDB | Access to the Transaction Details button | Contact Center Invoices tab |
| CSCSFTSK | Access to the Tasks tab | Contact Center Tasks tab |
| CSCSFUAT | The ability to update account information in the Accounts tab | Contact Center Accounts tab |
| CSCSFUPI | The ability to update customer information on the Party Information tab | Contact Center Party Information tab |
| CSCSFUTB | Access to the Use Template button on the Tasks tab | Contact Center Tasks tab |
| CSCSFUTK | Update a task on the Tasks tab | Contact Center Tasks tab |
| CSCSFUWQ | Access to the Universal Work Queue icon in the toolbar and the corresponding menu selection | Toolbar |
| CSCSFWKB | Access to the Notes tab | Contact Center Notes tab |
| CSCSKBIC | Access to the Knowledge Base icon in the toolbar and the corresponding menu selection | Toolbar |
| CSCSNORB | Access to the New button on the Orders tab of the Contact Center | Contact Center Orders tab |
| CSCSODEB | Access to the Details button on the Orders tab | Contact Center Orders tab |
The following table lists the service-request-related functions:
| Function | Description | Affected Tab or Window |
|---|---|---|
| CS_HA_ADD_NOTES | Ability to create notes | Workbench tab |
| CS_HA_AXS_ABORT_SRWF_SM | Access the Abort Service Request Workflow Special Menu item | Menu item |
| CS_HA_AXS_ACCESS_HOURS_BTN | Access the Access Hours button | Tasks tab of the Service Request window |
| CS_HA_AXS_AM_BTNS | Access Assignment Manager UI | Service Request header |
| CS_HA_AXS_ATTACHMENT_UI | Access attachments | Service Request window |
| CS_HA_AXS_CONTACTS_TAB | Access to the Contacts/Addresses tab | Contacts/Addresses tab |
| CS_HA_AXS_COPY_SR_SM | Access to the Copy Service Request item on the Special Menu | Menu item |
| CS_HA_AXS_COUNTER_SM | Access to the Counters item on the Special Menu | Menu item |
| CS_HA_AXS_CUSTOMER_BTN | Access Customer Update UI | Service Request window |
| CS_HA_AXS_CUSTOMER_PROFILE_BTN | Access Customer Profile | Service Request window |
| CS_HA_AXS_FIND_ICON | Access to the Find Icon | Service Request header |
| CS_HA_AXS_FIND_PRD_BTN | Access the Find Instance button | Service Request header |
| CS_HA_AXS_FOLDER_BTN | Access Folder Button | Service Request window |
| CS_HA_AXS_FULFILMENT_SM | Access Fulfillment Special Menu Item | Menu item |
| CS_HA_AXS_INTERACTION_TAB | Access Interactions Tab | Interactions tab |
| CS_HA_AXS_KB_UI | Access to the Search Knowledge button | Workbench tab |
| CS_HA_AXS_LAUNCH_SRWF_SM | Access Launch Service Request Workflow Special Menu Item | Menu item |
| CS_HA_AXS_LAUNCH_WF_BTN | Access Launch Workflow Button | Task tab |
| CS_HA_AXS_LOG_TAB | Access the Log Tab | Service Request window |
| CS_HA_AXS_NOTE_DETAIL_BTN | Access to the Note Detail button | Workbench tab |
| CS_HA_AXS_NOTES_SM | Access Notes Special Menu Item | Menu item |
| CS_HA_AXS_OUTBOUND_EMAIL_SM | Access Outbound Email Special Menu Item | Menu item |
| CS_HA_AXS_OWC_SM | Access web conferencing special menu item | Menu item |
| CS_HA_AXS_PARTS_BTN | Access the Parts button | Tasks tab of the Service Request window |
| CS_HA_AXS_PRD_CONFIG_BTN | Access Instance Configuration button on the Subject tab | Subject tab |
| CS_HA_AXS_PRD_COV_TAB | Access to the Subject tab | Subject tab |
| CS_HA_AXS_PRINT_REQUEST_SM | Access Print Request Special Menu Item | Menu item |
| CS_HA_AXS_PROFIT_MARGIN_SM | Service Request Profit Report Audit Special Menu Item | Menu item |
| CS_HA_AXS_QUICKMENU_SM | Access Quick Menu Special Menu Item | Menu item |
| CS_HA_AXS_REL_DOCS_TAB | Access Related Documents Tab | Related Objects tab |
| CS_HA_AXS_SCRIPTING_SM | Access Scripting Special Menu Item | Menu item |
| CS_HA_AXS_SEND_MESSAGE_SM | Access Send Message Special Menu Item | Menu item |
| CS_HA_AXS_SKILLS_BTN | Access the Skills button | Tasks tab of the Service Request window |
| CS_HA_AXS_SR_AUDIT_SM | Access Audit Report Special Menu Item | Menu item |
| CS_HA_AXS_SR_ESCALATE_SM | Access Service Request Escalation Special Menu Item | Menu item |
| CS_HA_AXS_SRV_HIST_TAB | Access Service History Tab | Service History tab |
| CS_HA_AXS_TASK_DETAIL_BTN | Access Task Details UI | Task tab |
| CS_HA_AXS_TASK_ESCALATE_SM | Access Task Escalation Special Menu Item | Menu item |
| CS_HA_AXS_TASK_TAB | Access Tasks Tab | Task tab |
| CS_HA_AXS_TRANSALATION | Access Translation | Service Request window |
| CS_HA_AXS_USE_TEMPLATE_BTN | Access the Use Template Button | Tasks tab of the Service Request window |
| CS_HA_AXS_UWQ_BTNS | Access UWQ Buttons (Call Info, Call Wrap Up, End Call, and Agent on Break Buttons) | Universal Work Queue window |
| CS_HA_AXS_VIEW_LOG_BTN | Access to the Log and Notes button | Workbench tab |
| CS_HA_AXS_VIEW_MESSAGE_SM | Access View Message Special Menu Item | Menu item |
| CS_HA_AXS_WEB_ACT_SM | Access Web Availability Special Menu Item | Menu item |
| CS_HA_AXS_WORKBENCH_TAB | Access to the Workbench tab | Workbench tab |
| CS_HA_INST_CHRG | Create Charges | Charges tab of the Service Request window |
| CS_HA_INST_CONTACTS | Create Contact and Contact Point | Create Contact window |
| CS_HA_INST_INTERACTION_ACT | Create Interactions and Activities | Service Request window |
| CS_HA_INST_REL_DOCS | Create Related Document | Related Objects tab |
| CS_HA_INST_SERVICE_REQUEST | Create Service Request | Service Request Creation |
| CS_HA_INST_TASK | Create Tasks | Task tab |
| CS_HA_UPDT_CHRG | Update Charges | Charges tab on Service Request window |
| CS_HA_UPDT_CONTACTS | Update Contact and Contact Point | Service Request window |
| CS_HA_UPDT_NOTES | Ability to update notes | Workbench tab |
| CS_HA_UPDT_REL_DOCS | Update Related Document & Access Delete Link button | Related Objects tab |
| CS_HA_UPDT_SERVICE_REQUEST | Update Service Requests | Service Request Update |
| CS_HA_UPDT_TASK | Update Task | Service Request window |
| CS_MASS_SR_UPDATE | Ability to search for and update mass service requests | Mass Service Request Update window |
This section lists the seed data for the standard service security that comes with your application. You can use it as a guide for creating your own custom security.
The following table lists the objects used by standard service security:
| Object Name | Description |
|---|---|
| CS_SERVICE_REQUEST | Service Request |
| CS_SR_TYPE | Service Request Type |
| JTF_TASK_RESOURCE | Resources |
The following table lists and describes the seeded object functions. In previous releases these were also known as Form Functions.
| Object Function Name | Related Object | Description |
|---|---|---|
| CS_JTF_RESOURCE_SELECT_SEC | JTF_TASK_RESOURCE | Select Service Request Type |
| CS_SR_ACCESS_RESP_SEC | CS_SERVICE_REQUEST | Service request security for Oracle Telephony Manager |
| CS_SR_TYPE_SELECT_SEC | CS_SR_TYPE | Select Service Request Types |
| CS_SR_CREATE | CS_SERVICE_REQUEST | Create access to a service request |
| CS_SR_UPDATE | CS_SERVICE_REQUEST | Update access to a service request |
| CS_SR_VIEW | CS_SERVICE_REQUEST | Read access to a service request |
| CS_SR_DELETE | CS_SERVICE_REQUEST | Delete access to a service request |
The following table lists and describes the seeded object roles. These are the service related menus. In previous releases these were also known as Object Roles or FND Menus.
| Permission Set | Description |
|---|---|
| CS_SR_FULL_ACCESS | Provides full access to Service Request data |
| CS_SR_TYPE_SELECT | Select Service Request Types |
| CS_RESOURCE_ASSIGN | Assign service request resources |
| CS_SR_ACCESS_RESP | Security request security for Oracle Telephony Manager |
The following table lists and describes the seeded object role functions. In previous releases these were also known as Object Role Functions or FND Menu Functions.
| Permission | Object Function (Function_name in FND_FORM_FUNCTIONS) | Purpose |
|---|---|---|
| CS_SR_FULL_ACCESS |
|
Provides full access to service request data |
| CS_SR_TYPE_SELECT | CS_SR_TYPE_SELECT_SEC | To Secure CS_SR_TYPE in base queries in service security |
| CS_RESOURCE_ASSIGN | CS_JTF_RESOURCE_SELECT_SEC | For validating SR owner as resource. |
| CS_SR_ACCESS_RESP | CS_SR_ACCESS_RESP_SEC | Validates Oracle Telephony Manager access to service requests. |
The following table lists and describes the seeded object instance sets used by the application when normal security is turned on.
| Object Instance Set Name | Predicate | Description |
|---|---|---|
| CS_SR_SRTYPE_SEC | EXISTS ( SELECT '1' FROM cs_sr_type_mapping csmap WHERE csmap.incident_type_id = &TABLE_ALIAS.incident_type_id AND csmap.responsibility_id = sys_context( 'FND', 'RESP_ID') AND csmap.application_id = sys_context( 'FND', 'RESP_APPL_ID') AND trunc(sysdate) between trunc(nvl(csmap.start_date, sysdate)) and trunc(nvl(csmap.end_date,sysdate)) ) | Restricts service request access by Service Request Type |
| CS_SRTYPE_SEC | AND EXISTS(SELECT '1'FROM cs_sr_type_mapping csmapWHERE csmap.incident_type_id = cs_incident_types_b_sec.incident_type_id AND csmap.responsibility_id = sys_context( 'CS_SR_SECURITY', 'RESP_ID')AND csmap.application_id = sys_context( 'CS_SR_SECURITY', 'APPL_ID') AND trunc(sysdate) between trunc(nvl(csmap.start_date, sysdate)) AND trunc(nvl(csmap.end_date,sysdate)) ) | Restricts availability of Service Request Types |
| CS_RESOURCE_SEC | EXISTS (SELECT '1' from FND_USER_RESP_GROUPS ur, cs_sr_type_mapping csmap WHERE cs_jtf_rs_resource_extns_sec.user_id = ur.user_id AND ur.responsibility_id = csmap.responsibility_id AND ur.responsibility_application_id = csmap.application_id AND csmap.business_usage = 'AGENT' AND csmap.incident_type_id = sys_context( 'CS_SR_SECURITY', 'SRTYPE_ID') AND trunc(sysdate) between trunc(nvl(ur.start_date,sysdate)) AND trunc(nvl(ur.end_date,sysdate)) AND trunc(sysdate) between trunc(nvl(csmap.start_date, sysdate)) AND trunc(nvl(csmap.end_date,sysdate)) ) OR ( cs_jtf_rs_resource_extns_sec.user_id is NULL AND cs_jtf_rs_resource_extns_sec.category <> 'EMPLOYEE' )) | Restricts the assignment of resources to service requests |
| CS_SR_ACCESS_RESP_SEC | AND EXISTS (SELECT '1' from cs_sr_type_mapping csmap WHERE csmap.incident_type_id = cs_incidents_b_sec.incident_type_id AND csmap.responsibility_id = sys_context( 'CS_SR_SECURITY', 'RESP_ID')AND csmap.application_id = sys_context( 'CS_SR_SECURITY', 'APPL_ID') AND trunc(sysdate) between trunc(nvl(csmap.start_date, sysdate)) AND trunc(nvl(csmap.end_date,sysdate)) ) | Restricts access to service requests by Service Request Type and responsibility |
The following table lists and describes the seeded object instance sets used by the application when normal security is turned off and permits unrestricted access.
| Object Instance Set Name | Predicate | Description |
|---|---|---|
| CS_RESOURCE_NO_SEC | "1=1" | Permits unrestricted assignment of resources to service requests |
| CS_SR_ACCESS_RESP_NO_SEC | "1=1" | Permits unrestricted access to Service Request Types by responsibility |
| CS_SR_SRTYPE_NO_SEC | "1=1" | Permits unrestricted service request access by Service Request Type |
| CS_SRTYPE_NO_SEC | "1=1" | Permits unrestricted availability of Service Request Types |
The following table lists all of the seeded grants. All seeded grants are set with the grantee of GLOBAL.
| Description | Object Type | Object Role | Instance Set |
|---|---|---|---|
| Restricts access by Service Request Type | CS_SERVICE_REQUEST | CS_SR_FULL_ACCESS | CS_SR_SRTYPE_SEC |
| Permits access to all Service Request Types when security is turned off. | CS_SERVICE_REQUEST | CS_SR_FULL_ACCESS | CS_SR_SRTYPE_NO_SEC |
| Restricts service request access by Service Request Type and specific responsibility | CS_SERVICE_REQUEST | CS_SR_ ACCESS_RESP | CS_SR_ACCESS_RESP_SEC |
| Permits access to all Service Request Types by responsibility when security is turned off. | CS_SERVICE_REQUEST | CS_SR_ ACCESS_RESP | CS_SR_ACCESS_RESP_NO_SEC |
| Secures the Service Request Type list of values (LOV) | CS_SR_TYPE | CS_SR_TYPE_SELECT | CS_ SRTYPE_SEC |
| Permits access to all Service Request Types in the LOV when security is turned off | CS_SR_TYPE | CS_SR_TYPE_SELECT | CS_SRTYPE_NO_SEC |
| Restricts resources that can be assigned to service requests and service request tasks by Service Request Type. | JTF_TASK_RESOURCE | CS_RESOURCE_ASSIGN | CS_RESOURCE_SEC |
| Permits assignment of all resources to service requests and service request tasks when security is turned off | JTF_TASK_RESOURCE | CS_RESOURCE_ASSIGN | CS_RESOURCE_NO_SEC |