CAUTION Make sure triggers are generated only for an assignment policys

Caution make sure triggers are generated only for an

This preview shows page 222 - 224 out of 314 pages.

CAUTION: Make sure triggers are generated only for an assignment policy’s criteria. Large data loads can experience performance issues otherwise. Do not modify the database triggers. However, before generating or applying triggers for dynamic assignment, you might want to review the trigger.sql file. It is recommended you work with your database administrator to do so. NOTE: If you discover redundant triggers, you need to deactivate the appropriate assignment criteria and assignment attribute using Siebel Tools. Complete the steps in the following procedure to review triggers for dynamic assignment. This task is a step in the “Process of Running Dynamic Assignment” on page 221 . To review triggers for dynamic assignment 1 Use Siebel Tools, or view the trigger.sql file ( SIEBSRVR_ROOT /trigger.sql), to examine the appropriate table columns. For more information about using Siebel Tools, see Using Siebel Tools . 2 Disable the inappropriate columns by inactivating the assignment attribute column. For detailed information, see “About the Relationship Between Attributes and Skills” on page 152 . If you inactivate only the assignment attribute column and leave the assignment attribute and assignment criteria active, then the assignment criteria appears in the user interface in the assignment administration views, which means you can create assignment rules based on that criteria. The following is the result of this action based on whether or not the Employee Skill field is checked: If the Employee Skill field is checked, then the assignment criteria is skill-based and, as such, should continue to work for assignment rules. For example, the criteria works if you run batch assignment because that mode does not rely on triggers. If the Employee Skill field is not checked, then the assignment criteria is object-based, and as such, relies on a valid assignment attribute column configuration. If you attempt to create assignment rules, you get an error message when the task is run. 3 Drop and regenerate new triggers. See “Generating Triggers for Dynamic Assignment Using the GUI.” 4 Recheck the trigger.sql file, to confirm that the trigger is no longer active.
Image of page 222
Running Siebel Assignment Manager Running Dynamic Assignment Siebel Assignment Manager Administration Guide Version 8.1, Rev. A 223 NOTE: When dynamic assignment is running, due to the database concurrency feature, some users might receive the following error when attempting to modify a record: “The selected record has been modified by another user since it was received. Please continue.” This result can occur because Assignment Manager updated the record by assigning it while an user was trying to edit it. In this situation, the user’s changes may be lost. The solution is to refresh the query and reenter the changes.
Image of page 223
Image of page 224

You've reached the end of your free preview.

Want to read all 314 pages?

  • Summer '16
  • Oracle
  • Management, Sales, Siebel Assignment Manager, Siebel Assignment Manager Administration Guide

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors