Ora-00904: "INF2_LOCALTX_DAYS": Invalid Identifier (Doc ID 785441.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0
This problem can occur on any platform.

Symptoms

-- Problem Statement:
When running the pin_bill_day with -file option (Billing Segment in the XML file), dm_oracle reporting error as:
ORACLE error: do_sql_mr_select: PINStmtExecute: code 904, op 0=ORA-00904: "INF2_LOCALTX_DAYS": invalid identifier


-- Steps To Reproduce:
1. Configure the billing segment 101,102,103:
    BillingSegment ID 101
    DomAssignments billingSegmentRef='101' status=' Open ' dom= ' ---01 '
    BillingSegment ID 102
    DomAssignments billingSegmentRef='102' status=' Open ' dom= ' ---01 '
    BillingSegment ID 103
    DomAssignments billingSegmentRef='103' status=' Open ' dom= ' ---01 '
2. Run load_pin_billing_segment to load the pin_billing_segment.xml into BRM
3. Restart the CM
4. Create a customer with the billing segment 101 dom 1 and billing segment 102 and dom 1
5. Create a PinBillRunControl_101.xml and PinBillRunControl_102.xml as following:
 Sample of PinBillRunControl_101.xml:   
<DOMList>
    <DOM>---01</DOM>
</DOMList>
<BillingSegmentList>
   <BillingSegment>101</BillingSegment>
</BillingSegmentList>


Sample of PinBillRunControl_102.xml:
<DOMList>
   <DOM>---01</DOM>
</DOMList>
<BillingSegmentList>
   <BillingSegment>102</BillingSegment>
</BillingSegmentList>

6. Set the pin_virtual_time to +1 month in order to run the billing.
7. Run pin_bill_day at $PIN_HOME/apps/pin_billd directory with -file option
  pin_bill_day -file PinBillRunControl_101.xml
  pin_bill_day -file PinBillRunControl_102.xml

-- Business Impact:
Unable to bill the customer on the correct bill cycle.


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