PIN_REL Error - New Events In tmp_unprocessed_events_t Table
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.4.0]
Information in this document applies to any platform.
Steps to reproduce error:
1. Create an account (opcode OP_CUST_CREATE_CUSTOMER)
2. Create a service PSTN or VIDEO (opcode OP_CUST_MODIFY_CUSTOMER)
3. Buy an offer for the created service (opcode PCM_OP_SUBSCRIPTION_PURCHASE_DEAL)
4. Generate an activity for service
- load CDR to pipeline
- start pin_rel application
5. After billing:
- Amount in bill_t: 42.35
- Balance group: 49.59
Amount of tax base (event_bal_impacts_t.quantity) is incorrect for /event/billing/cycle/tax.
For tax event, there is quantity 34.5 (tax base) but it should be 39.59. This amount does not include some events.
After upgrading to PS13 we have a problem with pin_rel. After each test we find two new events in tmp_unprocessed_events_t and we think that is source of problem.
Note - In PS13 some pin_rel stored procedures have changed. We assume that this is a reason of error, because after downgrading pin_rel files and stored procedures to PS12 version, the error doesn't occur.
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