OsBC_SYS_400 024 STARWOOD_Synonym_Schema

Problème :

Solution :

Note :

Document Background

This document is designed to outline the procedure that should be used to create the STARWOOD synonym schema within an Opera database.

It will be one of the standard steps during a new Opera installation in a Starwood hotel.

Prerequisites:

The environment consists of an Opera installation with an existing OPERA schema in the database.

System Checks:

Verify that there is no STARWOOD synonym schema already present in the database.

• 1. Creating a new STARWOOD synonym schema

1. Open the Opera SMT tool and select Schema Maintenance Click on Advanced.
2. Enter the login and password of the name of your Synonym Schema Click on Search.
3. Once you tick the box for “Create New Schema/User”, the lower part of the screen will change. Select “New Synonym Schema” and click “Create User”.

1. Confirm which schema the synonym should be made for, in this case the Opera schema.

1. Opera SMT tool will then return to the main screen and the synonym is created.
   1. Verify that STARWOOD schema is a synonym of OPERA
2. To verify the synonyms of a schema, log in as the Opera schema and go to “Refresh Synonyms”, this screen will display all synonyms of that particular schema.

• 1. Creating the ips_seq table in the STARWOOD schema

1. You now have a synonym schema, but with no tables inside. For IPS to function correctly, you need to add ONE table in which you will later insert the numeric sequence supplied by Starwood.
2. To create the table, log into SQL+ and type:

DROP TABLE starwood.ips_seq

/

CREATE TABLE starwood.ips_seq

( resort VARCHAR2(20) NOT NULL,

seq_type VARCHAR2(4) NOT NULL,

seq_start NUMBER(12) NOT NULL,

seq_end NUMBER(12) NOT NULL,

request NUMBER(12) NOT NULL,

seq_sts VARCHAR2(1) NOT NULL,

seq_cur NUMBER(12) NOT NULL

);

alter table ips_seq

add constraint ips_seq_pk primary key(resort,seq_type,seq_start);

/* Granting the Permissions to ALL */

GRANT SELECT,UPDATE,DELETE,INSERT ON starwood.ips_seq TO PUBLIC;/

1. This will have created the table required.
   1. Inserting the IPS stack
2. Starwood supplies scripts* with the numeric sequences that must be inserted in the IPS_SEQ table so that reservations can be booked.

This script will look similar to this:

Delete from ips_seq;

INSERT INTO ips_seq(resort,seq_type,seq_start,seq_end,request,seq_sts,seq_cur) VALUES ('ANDALOUS', 'CNCL', 952920000, 952939999, 952930000, 'A', 952920000);

INSERT INTO ips_seq(resort,seq_type,seq_start,seq_end,request,seq_sts,seq_cur) VALUES ('ANDALOUS', 'CONF', 731380000, 731399999, 731390000, 'A', 731380000);

Commit;

*NOTE: resort values should be changed to the property name of the hotel

• 1. Loading the UDF package into the OPERA schema

1. In order to be able to create reservations (once all previous steps have been completed), a package needs to be loaded into the OPERA schema. The package for Opera version 5.0.04.01e20 is included below.

1. Run the script in SQL+ logged in as the Starwood schema.
   1. Compile the schema with SMT
2. In order to have all objects valid you must open SMT tool under D:\MICROS\opera\Tools and compile Schema