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

Last updated on MAY 01, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.3.0 and later
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.
 


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms