Find Rate Plan ID

Every rate plan provisioned to the NexOSS database is assigned a unique rate plan ID. To delete a specific rate plan, the rate plan ID must be known.

  • NexOSS Web Interface

    A list of rate plan IDs by account can be found on the NexOSS web interface at http://:7080/billing/oss_billing_rate_plan.htm.

  • Command Line Interface

    A list of rate plan IDs for each account may be listed using the command line interface. Please see the following examples.

    • MySQL Example:

      Log into the MySQL database. Do not include parentheses around username, password, or database name.

      [ossadmin@linux-lab ~]$ mysql -u(username) -p(password) -D(database name)
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 579644
      Server version: 5.1.66 Source distribution
      
      Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
      
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
      
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      
      mysql> select ID, CUSTOMERNAME, EFFECTIVEDATE from RATEPLAN order by CUSTOMERNAME, EFFECTIVEDATE;
      ++++-+++++++++++++++++++--+++++++++++++++++++++++
      | ID | CUSTOMERNAME       | EFFECTIVEDATE       |
      ++++-+++++++++++++++++++--+++++++++++++++++++++++
      | 62 | Belgacom_Tier-1    | 2001-01-02 00:00:01 |
      | 66 | Belgacom_Tier-1    | 2001-01-02 00:00:02 |
      | 64 | Belgacom_Tier-1    | 2002-01-04 00:00:03 |
      | 65 | Belgacom_Tier-2    | 2002-01-04 00:00:03 |
      | 27 | BluIP - 360 Data   | 2013-05-01 23:59:59 |
      |  7 | BluIP - GX         | 2013-05-06 23:59:59 |
      | 11 | BluIP - Intelepeer | 2013-05-06 23:59:59 |
      | 54 | BluIP - Level3     | 2013-05-01 23:59:59 |
      | 42 | BluIP - Peerless   | 2013-05-01 23:59:59 |
      |  5 | BluIP - Peerless   | 2013-05-06 23:59:59 |
      | 32 | BluIP - SIPRoutes  | 2013-05-06 23:59:59 |
      |  8 | BluIP - Transcom   | 2013-05-01 23:59:59 |
      | 43 | BluIP - Verizon    | 2013-05-01 23:59:59 |
      | 12 | BluIP - Verizon    | 2013-05-06 23:59:59 |
      | 23 | BluIP Simulation   | 2013-05-01 23:59:59 |
      | 53 | BluIP Simulation   | 2013-05-02 00:00:00 |
      | 67 | NQU1               | 2002-01-04 00:00:00 |
      |  2 | Standard           | 2012-12-05 00:00:00 |
      |  1 | TermCust           | 2012-12-05 00:00:00 |
      ++++-+++++++++++++++++++--+++++++++++++++++++++++
      19 rows in set (0.00 sec)
      
      mysql>
      
    • Oracle Example

      Login to the Oracle database. Do not include parentheses around username, password, or database name.

      solaris10$ sqlplus (username)/(password)@(database name)
      
      SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 4 13:39:24 2014
      
      Copyright (c) 1982, 2009, Oracle.  All rights reserved.
      
      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      
      SQL> select ID, CUSTOMERNAME, EFFECTIVEDATE from RATEPLAN order by CUSTOMERNAME, EFFECTIVEDATE;         ID CUSTOMERNAME   EFFECTIVEDATE       353 Customer-28    01-JAN-00 12.00.00.000000 AM       354 Customer-38    01-JAN-00 12.00.00.000000 AM       355 Customer-41    01-JAN-00 12.00.00.000000 AM       356 Customer-44    01-JAN-00 12.00.00.000000 AM       357 Direct Peering 01-JAN-00 12.00.00.000000 AM       344 PlusTest       07-JAN-12 12.34.59.000000 PM       345 Premium        01-JAN-13 12.00.01.000000 AM       342 Provider-136   04-JAN-02 12.00.01.000000 AM       343 Provider-35    07-JAN-12 12.23.59.000000 PM       340 Provider-39    06-FEB-14 12.00.00.000000 AM       341 Provider-48    04-JAN-02 12.00.00.000000 AM       358 Provider-56    01-JAN-00 12.00.00.000000 AM       359 Provider-60    01-JAN-14 12.00.00.000000 AM 13 rows selected. SQL>