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 laterInformation 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:
-- 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:
<DOM>---01</DOM>
</DOMList>
<BillingSegmentList>
<BillingSegment>101</BillingSegment>
</BillingSegmentList>
Sample of PinBillRunControl_102.xml:
<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_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 |