Upgrade: Not Upgrading Collections Properly (Missing Collections Upgrade Scripts) (From 6.5 to 7.2.1 or 7.3) (Doc ID 459016.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.2.1.0.0 to 7.3.0.0.0 - Release: 7.2.1 to 7.3.0
Information in this document applies to any platform.
Communications Apps (Portal) - Version: 7.2.1 to 7.3.0.0.0
***Checked for relevance on 14-Jul-2011***

Symptoms

6.5->7.2.1 upgrade should upgrade the collections tables poid type as follows:

/collections_action/writeoff -> /collections_action/writeoff_billinfo
/collections_action/close_account -> /collections_action/close_billinfo

It should also update the table with the appropriate billinfo object. In addition, pending actions that
are scheduled objects must also be updated. Here is an example from schedule_t

For Writeoff
# number of field entries allocated 20, used 16
0 PIN_FLD_POID POID [0] 0.0.0.1 /schedule 1000364009 1
0 PIN_FLD_CREATED_T TSTAMP [0] (1145342757) Tue Apr 18 02:45:57 2006
0 PIN_FLD_MOD_T TSTAMP [0] (1150346606) Thu Jun 15 00:43:26 2006
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 181899714 155
0 PIN_FLD_ACTION_NAME STR [0] "Collections:Writeoff"
0 PIN_FLD_DESCR STR [0] ""
0 PIN_FLD_FLAGS INT [0] 0
0 PIN_FLD_INPUT_FLIST BUF [0] flag/size/offset 0x0 197 0 data:
x000000 23206e756d626572206f66206669656c # number of fiel
x000010 6420656e747269657320616c6c6f6361 d entries alloca
x000020 7465642032302c207573656420320a30 ted 20, used 2.0
x000030 2050494e5f464c445f504f4944202020 PIN_FLD_POID
x000040 2020202020202020504f4944205b305d POID [0]
x000050 20302e302e302e31202f636f6c6c6563 0.0.0.1 /collec
x000060 74696f6e735f616374696f6e2f777269 tions_action/wri
x000070 74656f66662031303030333632343733 teoff 1000362473
x000080 20300a302050494e5f464c445f414343 0.0 PIN_FLD_ACC
x000090 4f554e545f4f424a20202020504f4944 OUNT_OBJ POID
x0000a0 205b305d20302e302e302e31202f6163 [0] 0.0.0.1 /ac
x0000b0 636f756e742031383138393937313420 count 181899714
x0000c0 3135350a00 155..
0 PIN_FLD_NAME STR [0] "Schedule Object"
0 PIN_FLD_OPCODE INT [0] 3821
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.0 0 0
0 PIN_FLD_STATUS ENUM [0] 1
0 PIN_FLD_SYS_DESCR STR [0] "Collections:Writeoff"
0 PIN_FLD_WHEN_T TSTAMP [0] (1150344000) Thu Jun 15 00:00:00 2006

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