Filter
Top Products
294 APPENDIX E: MANUALLY CONFIGURING THE BILLING SUPPORT SERVER
schedules of the Oracle jobs and submit the Oracle jobs following the
instructions in the dedicated sections of this guide.
Manually Running
the CDR Upload
Use the CWU.UPLOAD procedure to manually upload CDRs from the
accounting server(s) to the billing support server.
To manually upload CDRs:
1 From a SQL Plus command line login as the cwbss user.
2 Enter the following script:
set serveroutput on
begin
cwu.upload;
commit;
end;
If the script returns an error, make sure that the database link is correct
and that the SERVER_ID_BSS and SERVER_ID_ACCT mapping is correct.
The data from the accounting server database’s RT_CDR table is loaded
into the billing support server’s RT_CDR table.
Manually Scheduling
the CDR Upload
Use the CWU.JOB_UPLOAD procedure to upload CDRs as scheduled in
the job_collect_cdr table.
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.
To upload scheduled CDRs:
1 Add the job to the job_collect_cdr table.
2 Verify the configuration of the job_collect_cdr table.
■ Only the record with ACTIVE_STATUS=1 is submitted. Verify that only
one entry is set to ACTIVE_STATUS=1.
■ Verify that the job_to_submit is CWU.UPLOAD.