Error Message From Customer Center Plans Tab (Doc ID 1614408.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

We are purging and archiving of cancelled products in purchased_product_t table with retention period older than 6 months. It's been in place for the last 3 months. But since the data is still in au_purchased_product_t and other related audit tables, we've performed purging of orphan data which is not present in purchased_product_t table from audit tables. Received the following error message when accessing the plans tab from customer center 


E Wed Dec 25 14:44:36 2013  lonwin03  cm_test:24783  cm_child.c(109):4661 1:cmms-tm003-PC:CustomerCenter:0:AWT-EventQueue-0:81:1387953861:0
op PCM_OP_CUST_READ_ACCT_PRODUCTS returned an error
<location=PIN_ERRLOC_DM:4 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_NOT_FOUND:3>
<field num=PIN_FLD_RESULTS:9,51 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>

 Steps to reproduce 

1) Purge the cancelled products in purchased_product_t for an account
2) Purge the corresponding entries in the au_purchased_product_t for that account
3) click the plans tab in the customer center for the account which got purged and get the above error

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