My Oracle Support Banner

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

Last updated on APRIL 05, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
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.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.