Error While Loading A Delayed Event With IREL (Doc ID 408365.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 6.5.0.1.0 and later   [Release: 6.5.0 and later ]
HP 9000 HP-UX 11.0 (32 bit)
Oracle Solaris on SPARC (32-bit)
***Checked for relevance on 09-Mar-2011***

Symptoms

One might get an error "Item is already billed, cannot be updated" when loading a late(delayed) event with iREL.

Scenario:

  1. Define price plan with product having billing in advance for one month.
  2. Create account and purchase above product
  3. Rate a CDR (delayed event) with Pipeline
  4. Load Event with iRel
  5. Event loaded successfully
  6. Move pin_virtual_time forward
  7. Execute billing
  8. Move pin_virtual_time forward
  9. Rate a CDR (delayed event) with Pipeline
  10. Load event with iREL


The following error occurs in rel.pinlog:  

    

Error 11/24/04 3:41:19:0684 PM ( 1101307279684 )  T:main REL IREL 
1:machine01:UnknownProgramName:0:main:7:1101307279:0
        Exiting with return code: 1
Error 11/24/04 5:07:31:0231 PM ( 1101312451231 )  T:Update SP Thread 1 REL 
RELUpdaterThread 1:machine01:UnknownProgramName:0:Update SP Thread 
1:0:1101312451:0
        ORA-20010: Error -20010 occurred in the update procedure
ORA-06512: at "BTO_PIN1.PIN_REL", line 2144
ORA-20010: Item is already billed, cannot be updated 3355564
ORA-06512: at line 1

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