My Oracle Support Banner

TMP_PROF Tables Are Not Deleted By REL (Doc ID 2793095.1)

Last updated on JULY 23, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.3.0 and later
Information in this document applies to any platform.

Symptoms

pin_rel is unable to a load a rated CDR file due to UPDATE_ERROR during loading the CDR to the DB. The file is then attempted to be loaded again and succeeds. However, the TMP_PROF table associated
with the file is not dropped only status gets updated in batch_t table

cat *log |grep 123456789
2 PIN_FLD_TABLES STR [0]
"event_t;event_bal_impacts_t;event_essentials_t;event_dlay_sess_tlcs_t;event_d
lay_sess_tlcs_svc_cds_t;event_tax_jurisdictions_t;event_rum_map_t;tmp_prof123456789"

 

 

Cause

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
Symptoms
Cause
Solution
References


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