Cannot View Products In Customer Center Under Plans Tab After Patch 5969907 For Branding (Doc ID 470421.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.2.1.0.0 [Release 7.2.1]
Information in this document applies to any platform.
Checked for relevance on 30-Apr-2012.
Checked for relevance on 24-Jan-2014.

Symptoms

After installing Patch 5969907, when you click on the Plans tab on the Customer Center, an error message shows up, and no information related to the plans is displayed. This behavior only happens when connected as a brand user. Logging in as root does not cause the problem.

Patch 5969907 includes fm_subscription.so file. When changing fm_subscription.so to previous version, the error does not happen.

cm.pinlog file shows the following search and error:

D Wed Sep 26 10:21:35 2007 myhost cm:564 fm_subscription_read_acct_products.c:647 1:mypc:CustomerCenter:0:AWT-EventQueue-0:81:1189364032:0 
       event search: input
# number of field entries allocated 20, used 7
0 PIN_FLD_POID POID [0] 0.0.0.1 /search/pin -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_TEMPLATE STR [0] "select X from /event where ( F1 = V1 and ( F2 like V2 or F3 like V3 ) ) and poid_id0 < 35184372088832 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 774830 13
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1     PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/action/purchase -1 0
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1     PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/action/cancel -1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 8
1     PIN_FLD_POID POID [0] NULL poid pointer
1     PIN_FLD_CREATED_T TSTAMP [0] (0) <null>
1     PIN_FLD_DESCR STR [0] NULL str ptr
1     PIN_FLD_SYS_DESCR STR [0] NULL str ptr
1     PIN_FLD_SERVICE_OBJ POID [0] NULL poid pointer
1     PIN_FLD_SESSION_OBJ POID [0] NULL poid pointer
1     PIN_FLD_ACTION_INFO ARRAY [*] NULL array ptr
1     PIN_FLD_PRODUCT SUBSTRUCT [0] NULL substruct ptr
D Wed Sep 26 10:21:35 2007 myhost cm:564 fm_subscription_read_acct_products.c:651 1:mypc:CustomerCenter:0:AWT-EventQueue-0:81:1189364032:0 
       event search: result
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /search/pin -1 0
0 PIN_FLD_ERR_BUF ERR [0]

         <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
         <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
         <facility=0 msg_id=0 version=0>
E Wed Sep 26 10:21:35 2007 myhost cm:564 fm_subscription_read_acct_products.c:788 1:mypc:CustomerCenter:0:AWT-EventQueue-0:81:1189364032:0
fm_subs_rap_search_and_add_elem_events error
         <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
         <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0> 
         <facility=0 msg_id=0 version=0>

dm_oracle.pinlog shows:

E Sun Sep 26 10:22:48 2007 myhost dm:509 dm_subr.c(100):6904 1:mypc:CustomerCenter:0:AWT-EventQueue-0:81:1189364032:0
     ORACLE error: do_sql_mr_select: PINStmtExecute: code 918, op 0
     =ORA-00918: column ambiguously defined

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