Administration Guide for Oracle Billing Insight > Loading Billing Data Into Oracle Billing Insight > Methods for Loading Provisioning Data >

Using the AWK Extraction Tool to Generate a Batch Provisioning Input File

The AWK extraction tool provides a backup alternative if you cannot provide a separate provisioning data file from your billing data file. This tool lets you extract the provisioning data from the billing file and can be useful for backward compatibility.

Once you generate the batch provisioning input file, you use the ProvisioningData Command Center job to load the provisioning data before loading the associated billing file.

To generate a batch provisioning input file using the Extraction tool:

• Run the extract_bill.awk Extraction tool using the following format:

  $EDX_HOME/bin/extract_bill.awk input_billing_filename > PROV_BILLING_$(date +%Y%m%d%H%M%S).DAT

  where:

  • input_billing_filename is the name of the billing file from which to extract provisioning data.
  • PROV_BILLING_$(date +%Y%m%d%H%M%S).DAT is the file name pattern that the extraction tool uses for the generated batch provisioning data file; do not change this file name or pattern.

    For example:

  $EDX_HOME/bin/extract_bill.awk EBILLING_B2B-DATA-FILE-121202.DAT > PROV_BILLING_$(date +%Y%m%d%H%M%S).DAT