Manually Generate Invoices

  1. Login to NexOSS as UID ossadmin and navigate to the billing directory.
   $ cd $NexOSS_HOME/sql/billing
  1. Edit the file invoice_report.sql and define the start and end billing date.
   $ ls
   invoice_report.sql
   $ vi invoice_report.sql
   define billingStart = "2008-01-01"
   define billingEnd = "2008-02-01"
  1. Login to SQLPlus and execute invoice_report.sql.
   $ sqlplus nexoss/******@telasip
   SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 2 15:20:00 2008
   Copyright (c) 1982, 2005, Oracle. All rights reserved.
   Connected to:
   Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
   With the Partitioning, OLAP and Data Mining options
   SQL> @invoice_report.sql
   old 17: O_CallStartTime >= '&billingStart'
   new 17: O_CallStartTime >= '2008-01-01'
   old 19: O_CallStartTime < '&billingEnd'
   new 19: O_CallStartTime < '2007-02-01'
   ~
   7| .00
   |989732 |GAYLORD |2008-01-04|2008-01-04|
   2| 2.10| 0.0114| .02
   |989737 |SAGINAW |2008-01-04|2008-01-04|
   3| 7.60| 0.0074| .06
   |989772 |MTPLEASANT |2008-01-02|2008-01-16|
   4| 4.60| 0.0114| .05
   |989775 |MTPLEASANT |2008-01-11|2008-01-25|
   3| .00| 0.0114| .00
   |989855 |MUIR |2008-01-17|2008-01-17|
   1| .30| 0.0114| .00
   |989859 |MIDLAND |2008-01-17|2008-01-17|
   1| .00| 0.0078| .00
   |989876 |AU GRES |2008-01-04|2008-01-04|
   1| 2.20| 0.0169| .04
   ******************************| | | | |
   +++++++++-|++++++++++++-| |++++++++++++-
   Total | | | | | 53,032| 68,472.50| | 553.69
   14160 rows selected.
   Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
   With the Partitioning, OLAP and Data Mining options
   [ossadmin@oss billing]$

The entire billing report will be printed to the screen, but you will be able to view and download the Invoice from the NexOSS user interface after this step is complete. Go to “BILLING,” “Billing Invoices,” “By Source” or “By Destination”, then click on the “View Selected File” button or the “Download Selected File” button.

NexOSS Interface