(Doc ID 1089943.1)

Last updated on MAY 31, 2010

Applies to:

Oracle Communications Billing and Revenue Management - Version: and later   [Release: 7.3.1 and later ]
HP-UX Itanium


We need to make trial_bill for all clients in specific DOM date. 

When executing PIN_TRIAL_BILL_ACCTS with the dom.xml which only contains the description of DOM date, the pin_trial_bill_accts executes the following SQL that filters on the pay_type of default OOB types only:

 SQL_STMT dm_search_robj: cmd="select  distinct  billinfo_t.poid_DB,
 billinfo_t.poid_ID0, billinfo_t.poid_TYPE, billinfo_t.poid_REV,
 billinfo_t.account_obj_DB, billinfo_t.account_obj_ID0,
 billinfo_t.account_obj_TYPE, billinfo_t.account_obj_REV from billinfo_t, account_t  
 where billinfo_t.poid_id0 > 1 and ( billinfo_t.pay_type between 10001 and 10006 ) and billinfo_t.actg_next_t < :1 and billinfo_t.next_bill_t < :2 and account_t.poid_ID0 = billinfo_t.account_obj_ID0 and ( billinfo_t.actg_cycle_dom = :3 ) order by billinfo_t.poid_id0 "

The steps we execute the process are:
1. make dom.xml with the DOM date.
2. execute pin_trial_bill_accts -f_control dom.xml

Here is the dom.xml:
<?xml version="1.0" encoding="UTF-8"?>

    xsi:schemaLocation=" BusinessConfiguration.xsd">

    <!-- Sample input file for pin_bill_accts containing parameters for bill run management -->
    <!-- Modify according to guidelines -->

        <!-- List of DOMs for this bill run -->




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms