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

Last updated on SEPTEMBER 08, 2023

Applies to:

Symptoms

pin_rel is unable to a load a rated Call Detail Record (CDR) file due to UPDATE_ERROR during loading the CDR to the database (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" 

Steps to reproduce:
------------------------
1. Identify the account for which CDR is being processed.
2. Find out the balance group poid from account_t.
3. Update the poid_id0 value for the same balance group in bal_grp_t table.
4. Load the out file using pin_rel.
    The file loading will fail with UPDATE_ERROR.
5. Update the the poid_id0 value to original value in bal_grp_t table.
6. Load the file again.
    The file should get processed successfully.
7. Verify if the TMP_PROF table getting deleted.

Cause

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