Filter
Top Products
Manually Configuring Upload from Multiple Accounting Servers 291
■ BSS_SERVER_CONFIG — See “Configuring bss_server_config” on
page 303 for fields descriptions.
2 Verify there are database links from the billing support server to each
accounting server. When creating database links, from the
ACCT_SERVER_LIST table, the SERVER_CONNECTION field must be used
as the remote service name.
3 Configure the JOB_COLLECT_CDR table to schedule the upload job. For
each accounting server from which the billing support server collects
CDRs, there must be one record in the JOB_COLLECT_CDR table. See
“Configuring job_collect_cdr” on page 306 for more information.
For each record, the following fields should be correct:
■ JOB_ID — assign a number to this record, it is the ID field.
■ JOB_NUMBER — Just keep it empty since Oracle overwrites this
column and assigns a correct job number.
■ JOB_TO_SUBMIT — Enter the type of job to run such as
CWU.UPLOADRUNTIMECDR or CWU.CDRCOPY.
■ JOB_NEXT_RUN — Can leave empty.
■ JOB_INTERVAL — Enter sysdate+1/(24*12) which sets the job
interval to every 5 minutes or sysdate+1/(24*6) which sets the job
interval to every 10 minutes.
■ CREATE_TIME — Can leave empty.
■ ACTIVE_STATUS — Must be set to 1 if you want it active. It will be
overwritten to 2 if this job is scheduled successfully.
■ CDR_NUM_PER — Leave this empty.
■ DESCRIPTION — Enter a description for the job.
■ SERVER_ID_ACCT — Enter the correct ACCT SERVER ID. This value
must be defined in ACCT_SERVER_LIST.
For example, if there are two accounting servers sending CDRs to one
billing support server, then the table JOB_COLLECT_CDR must have 2
records configured.
4 Submit the uploading jobs.
Connect to SQL plus as the user cwbss and run the following script:
set serveroutput on
begin