It is recommended that you review the topics on extension tables and columns in

It is recommended that you review the topics on

This preview shows page 280 - 283 out of 314 pages.

It is recommended that you review the topics on extension tables and columns in Configuring Siebel Business Applications before completing this process.
Image of page 280
Availability-Based Assignment Process of Configuring Assignment Objects for Availability-Based Assignment Siebel Assignment Manager Administration Guide Version 8.1, Rev. A 281 Extending an Assignment Object’s Base Table for Availability-Based Assignment Using Siebel Tools, you extend an assignment object’s base table for availability-based assignment by performing the following tasks. This task is a step in “Process of Configuring Assignment Objects for Availability-Based Assignment” on page 280 . To extend an assignment object’s base table for availability-based assignment 1 Start Siebel Tools. 2 In the Object Explorer, expand the Table object, and then select Column. 3 In the Tables window, query for the appropriate table. For example, if you are extending the Service Request assignment object, query for the S_SRV_REQ table. 4 With the table selected, choose Tools, then Lock Project (or Alt+L), to lock the project. 5 In the Columns list, choose Edit, then Add New Record, to add the records as described in the following table. 6 After you have created the new records you need in the Table column window, click Apply Doing this sends the new columns to the appropriate tables in the database. 7 Complete the fields in the Apply Schema dialog box. a In the Tables field, click the select button, and choose one of the following: All Current Query Current Row Property Record 1 (Required) Record 2 (Required) Record 3 (Optional) Name X_DURN_MIN X_START_TIME X_EARLY_START_TIME Physical Type Number UTC Date Time UTC Date Time Length 22 7 7 Precision 22 Not applicable Not applicable Scale 7 Not applicable Not applicable LOV Type APPOINTMENT_DURATION Not applicable Not applicable Cascade Mode Ignore Ignore Ignore TxnLog Code TRUE TRUE TRUE
Image of page 281
Siebel Assignment Manager Administration Guide Version 8.1, Rev. A Availability-Based Assignment Process of Configuring Assignment Objects for Availability-Based Assignment 282 b In the Table owner password field, enter the appropriate value. c Click Apply. The base table is now extended with the following three columns: X_DURN_MIN, X_EARLY_START_TIME, and X_START_TIME. NOTE: For IBM DB2 for z/OS or OS/390, you must create a storage control file to accommodate the table space. You provide the location of the control file in the Apply Schema dialog box accordingly. You must create the storage control file from the SIEBSRVR_ROOT /bin directory and the bufferpool size should be either 16 KB or 32 KB. If the Siebel Server is running on UNIX or Linux, the storage control file generation is command-driven. If the Siebel Server is running on Windows, you generate the storage control file using the GUI.
Image of page 282
Image of page 283

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