Filter
Top Products
292 APPENDIX E: MANUALLY CONFIGURING THE BILLING SUPPORT SERVER
cwu.job_upload;
end;
Manually
Configuring Oracle
Jobs on an
Accounting Server
In this configuration the billing support server extracts data from the
accounting server's RT_CDR1 and RT_CDR2 tables directly and inserts
them into its RT_CDR table and then truncates the tables on the
accounting server. There is additional configuration performed on the
accounting server database side.
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.
Some configuration steps are required on the accounting server, see
Configuring the Accounting Server for more information
1 Configure the following tables on the billing support server:
■ ACCT_SERVER_LIST
■ BSS_SERVER_LIST
■ BSS_ACCT_SERVER_MAP
■ BSS_SERVER_CONFIG
2 On the billing support server, configure a database link for each
accounting server from each billing support server.
3 On the billing support server, configure the JOB_COLLECT_CDR table.
Refer to the “Manually Scheduling the CDR Upload” on page 294.
a Set JOB_TO_SUBMIT to CWU.UPLOADRUNTIMECDR.
The package name is CWU, rather than CWHISTORY.
b Set JOB_INTERVAL to the job frequency. For example
SYSDATE+1/(24*12) equals 5 minutes and SYSDATE+1/(24*6) equals
10 minutes.
c Set ACTIVE_STATUS to 1 for this record.
4 Schedule the JOB for upload.