My Oracle Support Banner

TD-NTUPL Restart Data Is Incorrect (Doc ID 2259907.1)

Last updated on OCTOBER 06, 2022

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.3.0 to 2.6.0.0.0 [Release 2.4 to 2.6]
Information in this document applies to any platform.

Symptoms

When TD-NTUPL fails, it is adding an ! to the end of the restart data
 
When attempting to restart the failed thread, the exclamation point at the end of the restart data causes the restart to fail.

The RESTART key on TD-NTUPL is not getting populated correctly with the following scenario:
1. The NT_UP_ID is less than 100000000000 which means the key is not full 12 digits and since the data type of NT_UP_ID is number, zeros are not padded on the key.
2. There is an error in one of the records being processed. So this means that at some point, a ROLLBACK will be done and that the job will have to restart from the RESTART key.
 
Now the issue is that the RESTART key essentially will have an "!" (exclamation point) when it should have numbers.
 


Changes

 

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
Changes
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.