Filter
Top Products
Manually Merging CDRs into Super CDRs 295
■ Verify that the job_interval is set correctly.
3 From a SQL Plus command line, login as the cwbss user.
4 Enter the following script:
set serveroutput on
begin
CWU.JOB_UPLOAD;
end;
The CDR upload runs as scheduled. Once the CDR upload runs, the data
from the accounting server database’s RT_CDR table is loaded into the
billing support server’s RT_CDR table.
To kill a scheduled job, refer to Manually Dropping a Scheduled Job.
Manually Merging
CDRs into Super
CDRs
The billing support server merges CDRs collected during the CDR upload
procedure into a singe super CDRs per call (the CDRs are stored in the
rt_cdr table and merged into the rt_super_cdr_status table). The billing
support server can then export the collected super CDRs for use in
proprietary billing systems.
3Com recommends scheduling regular CDR merges but the
cwm.mergecdr procedure can be run separately for a one-time merge.
This section describes both procedures.
The billing support server installation procedure schedules all the
necessary Oracle jobs for the billing support server for default
configuration. If you want to use the default configuration, you do not
need to do any Oracle job scheduling such as uploading CDRs, merging
CDRs into Super CDRs, exporting Super CDRs, and deleting CDRs. If you
do not use the default configuration, you should drop the default
schedules of the Oracle jobs and submit the Oracle jobs following the
instructions in the dedicated sections of this guide.
Perform these procedures after Manually Uploading CDRs.
Manually Running
the CDR Merge
Use the CWM.JOB_MERGE procedure to manually merge individual
CDRs into super CDRs.