Oracle Connector Configuration
- Nathaniel Halbrooks
This is a step by step guide on how to configure the PBXact Oracle Connector module with your Oracle Hotel Property Management system. This will require the following software and licenses from Sangoma.
PBXact (Does not work on FreePBX)
Sangoma Property Manager Module License
Oracle Connector Module License
1) Go to User Manager, select the groups tab, then select Property Management from the list and click Add to add a new group. This will add a new group to the Property Management dictory.
2) Label the new group "PMS-Rooms" and leave everything else at defaults, then save the new group.
3) Go to Extensions and Add a new PJSIP extension. This will be your first hotel room extension. Ensure the extension number is the same as the room number in Oracle, then give it any display name such as "Room 101". Next change it to the Property Management Directory and set the group to PMS-Rooms. Then Save the extension leaving the rest at defaults.
4) Next go to Outbound Routes and Add a new route called Emergency. Set the Route CID to the main number of the property which will have the correct E911 information attached to it. Set the Type to Emergency and then select your Trunk the to PSTN. In this case calls will be routed through the SBC SIP trunk.
5) Next go to the Dial Patterns Tab and only select the US Emergency option. This will generate dial patterns for 911. If this is being installed where the emergency number is not 911, then adjust the dial pattern accordingly. Generate the routes and save the outbound route.
6) Next Add a new route called Local after saving the previous route. Define a CID and configure it for your Trunk to the PSTN. In this case our SIP Trunk to the PSTN is called SBC.
7) Next go to the Dial Patterns tab and select the 7 digits and 10 digit pattern as those will be local calls. Once done click Generate Route. If this is being setup in a location where 7 and 10 digits are not local, please adjust the generated dial plan accordingly.
8) Next Add a new route called National after saving the previous route. Define a CID and configure it for your Trunk to the PSTN. In this case our SIP Trunk to the PSTN is called SBC.
9) Next go to the Dial Patterns tab and select everything except for US International. Once done click Generate Route. If this is being set up outside of the US/Canada please adjust the generated dial plan accordingly.
10) Next Add a new route called International after saving the previous route. Define a CID and configure it for your Trunk to the PSTN. In this case our SIP Trunk to the PSTN is called SBC.
11) Next go to the Dial Patterns tab and select every option as shown below. Once done click Generate Route. If this is being set up outside of the US/Canada please adjust the generated dial plan accordingly.
12) Next go to Class Of Service module and click Add New CoS.
13) Do not add any rooms to the Members Allowed Tab, but go to Routes Tab and add the Emergency Route, and call the CoS "SPM-Internal". The "SPM-" prefix is required to show up in Oracle Connector. Save the CoS and add another one.
14) The next CoS will have no members as well. Name it "SPM-Local" and add the Emergency and Local routes. Save the CoS and add another one.
15) The next CoS will have no members as well. Name it "SPM-National" and add the Emergency, Local and National routes. Save the CoS and add another one.
16) The next CoS will have no members as well. Name it "SPM-National" and add the Emergency, Local, National and International routes. Save the CoS and the CoS configuration is now complete.
17) Next go to the Property Management module, then go to Config → General.
18) Then go to the Taxes tab and click Add, then enter the label of Tax and the value of 0. This is just placeholder data, and in future releases may not be needed.
19) Next go to Config → Billing Rate then configure each route with a connection charge, price and mask of 0. Select the previously defined tax and the Billing duration should be 1. Once done click Submit in the bottom right. Do this step for each of the 4 Outbound Routes.
20) Now the system is ready to be connected with Oracle. Go into the Oracle Connector module in the PBXact webUI. Then click on the hamburger button the right side to get the menu, and click on Settings.
21) On the settings page enter the IP and port of the Oracle system. As well set the Class of Services as shown below. Once done click Submit.
22) Now that the changes are submitted then click on the Start button as shown below to start the Oracle connector module. The module will now be reaching out to Oracle to make a connection.
23) Wait a few minutes, then go to the Panel from the hamburger button on the right. The panel should show all of the rooms now along with their status.
24) Below is a list of feature codes that can be used to change the room states and do a wakeup call.
*361 - Dirty Vacant
*362 - Dirty Occupied
*363 - Clean Vacant
*364 - Clean Occupied
*365 - Inspected Vacant
*366 - Inspected Occupied
*68 - To arrange a wake up call
25) With the latest Oracle Connector version, When you will start to install it and go to SPM to set Oracle Connector as Operating mode, then it will create taxes, billing rates automatically. Also, The rooms are created when you synchronize the database.
The PBX reloading is done after each Link Start (LS), so Keep Alive setting and so every 5 minutes.