Suspense Manager Is Unable to Edit/Update EDR Field Value in SUSP_USAGE_EDR_BUF Table (Doc ID 2444431.1)

Last updated on NOVEMBER 21, 2024

Applies to:

Symptoms

Suspense Manager is unable to edit/update EDR field value in SUSP_USAGE_EDR_BUF table.

While trying to edit the value of an editable field in the Event Detail Record (EDR) through Suspense Management Center, it was noticed that the value was getting updated for that particular /suspended_usage/telco object in the SUSP_USAGE_TELCO_INFO_T table, but the corresponding new value is not reflected in the SUSP_USAGE_EDR_BUF table. Hence when initiating recycle from Suspense Manager Center, it is sending the incorrect/old field value to pre-recycle pipeline and subsequently the EDR is again getting rejected.

EXPECTED BEHAVIOR
-----------------------
The SUSP_USAGE_EDR_BUF table should be updated also if the object from SUSP_USAGE_TELCO_INFO_T table is updated.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an input CDR with an incorrect login (A_NUMBER).
2. Pass the CDR through the rating pipeline. EDR should be rejected and the suspended EDR should be loaded to the database using SE Loader.
3. Search for this particular EDR in Suspense Management Center and edit the EDR. This time use a valid A_NUMBER which exists in the database.
4. Click the Recycle button to recycle the suspended EDR.
5. This time the EDR should be should be successfully rated, or throw some different error in case the rating fails again.

Scenario:
1. The EDR is getting rejected with the same error as the pipeline is receiving the old/incorrect A_NUMBER in the input again. [e.g.: Customer login not found: identifier=(xyz) prefix=(VOICE) serviceCode=().]
2. This is creating a "suspense_update*.rej.bc" file in the $IFW_HOME/data/reject/voice directory.
3. When SE Loader is trying to load this "suspense_update*.rej.bc", it is throwing an error:

Cause

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