My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.


-- 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:   


Sample of PinBillRunControl_102.xml:


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.




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

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