Filter
Top Products
298 APPENDIX E: MANUALLY CONFIGURING THE BILLING SUPPORT SERVER
The USER_CALL_HISTORY table should be populated from information in
the call records for each URI_ID. The call history for a user can be viewed
in the web provisioning server.
Any call where the start time, end time, and duration equals zero (for
example, when a call is forwarded or not answered), the date is
translated to 1970-01-01 in the Start Time and End Time columns of the
Call History.
Manually Running
the Super CDR Export
Use the CWE.OUTPUT procedure to manually export super CDRs to a flat
file.
To manually export super CDRs:
1 From a SQL Plus command line, login as the cwbss user.
2 Enter the following script, making sure to set the p_dir and p_filename
variables equal to the correct directory and filename:
SET SERVEROUTPUT ON;
DECLARE
p_dir varchar2(250);
p_filename varchar2(250);
p_separator varchar2(10);
BEGIN
p_dir:='/export/home/users/oracle/temp/output';
p_filename:='SuperCDR';
p_separator:='|';
CWE.OUTPUT(p_dir,p_filename,p_separator);
END;
The file set as the export file contains the CDR fields specified in the
job_export_fields_map table.
Manually Scheduling
the Super CDRs
Export
Use the CWE.JOB_EXPORT procedure to complete the
USER_CALL_HISTORY and to export Super CDRs into a flat file as
scheduled in the job_export_supercdr table. This job schedule actually
schedules two jobs: fill_out job and export job.
To export the super CDRs on a schedule:
1 Add the job to the job_export_supercdr table.
2 Verify the configuration of the job_export_supercdr table.