My Oracle Support Banner

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

Last updated on MARCH 27, 2019

Applies to:

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


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  <HOSTNAME> cm_test:24783  cm_child.c(109):4661 1:<HOSTNAME>:CustomerCenter:0:AWT-EventQueue-0:81:1387953861:0
op PCM_OP_CUST_READ_ACCT_PRODUCTS returned an error
<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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.