PAY_TYPE Filter Problem With PIN_TRIAL_BILL_ACCTS (Doc ID 1089943.1)

Last updated on MAY 31, 2010

Applies to:

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

Symptoms

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"?>

<BusinessConfiguration
    xmlns="http://www.portal.com/schemas/BusinessConfig"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.portal.com/schemas/BusinessConfig BusinessConfiguration.xsd">

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

        <!-- List of DOMs for this bill run -->
        <DOMList>
            <DOM>---14</DOM>
        </DOMList>

    </BillRunConfiguration>

</BusinessConfiguration>

Cause

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