Bgrenon

2. Migrate the Platform schema objects.

To migrate the Platform schema objects, do the following:

• Ask your DBA to grant the following privileges to the Platform schema owner:

GRANT EXECUTE ON SYS.GENADVISORSJOBCLASS TO &&platformschemaowner;
GRANT CREATE JOB TO &&platformschemaowner;

• Make sure that the Platform schema owner has select privileges to all views that belong to all GENESYS sources listed in the Platform ICM_DATABASE table.

  To verify the privileges, connect as the Platform schema owner and run the following set of queries for each <AGA Metrics Schema Name> listed in the Platform ICM_DATABASE table.

SELECT * FROM  <aga metrics="" schema="" name="">.AGENT_SKILL_GROUP_REAL_TIME WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.CALL_TYPE WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.CALL_TYPE_REAL_TIME WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.CONTROLLER_TIME WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.INTERACTION_QUEUE WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.INTERACTION_QUEUE_REAL_TIME WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.LOGICAL_INTERFACE_CONTROLLER WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.PERIPHERAL WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.PERIPHERAL_REAL_TIME WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.SERVICE WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.SERVICE_MEMBER WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.SERVICE_REAL_TIME WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.SKILL_GROUP WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.SKILL_GROUP_REAL_TIME WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.QUEUE_SET1_REAL_TIME WHERE ROWNUM<2;
SELECT * FROM  <aga metrics="" schema="" name="">.QUEUE_SET2_REAL_TIME WHERE ROWNUM<2;