Issues Implementating Breaking Start/Stop (Doc ID 2300551.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.5.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On :  2.5.0.2.0 version, Customer information

ACTUAL BEHAVIOR  
---------------
Error is encountered when activating an SA that has been started using Start/Stop and the
Person linked to it has gap in sequence on Person Phone list.

SYSUSER - 205368-83934-1  2017-05-22 12:42:26,997 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO  (support.sql.PreparedStatementImpl) Executing SQL:                  SELECT                    ACCT_ID,                    SEQ_NUM,                    PHONE_TYPE_CD,                    COUNTRY_CODE,                    PHONE,                    EXTENSION,                    VERSION                 FROM                    CI_SS_PHONE_OVRD                 WHERE                    ACCT_ID = :S-ROW-IN-DATA.ACCT-ID                     AND SEQ_NUM = :S-ROW-IN-DATA.SEQ-NUM /* SQL for program 'com.splwg.ccb.domain.customerinfo.account.entity.ProgramCIPCPPOR_Impl', SQL name 'S_ROW' */

SYSUSER - 205368-83934-1  2017-05-22 12:42:27,014 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO  (support.context.FrameworkSession) (Server Message)
Category: 3
Number: 253
Call Sequence: ;CIPCPPHR
Program Name: CIPCPPHR
Text: Person ID field missing
Description: A mandatory field has been left blank.  Please enter a value and retry your request.
Table: CI_PER_PHONE
Field: PER_ID
SYSUSER - 205368-83934-1  2017-05-22 12:42:27,015 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO  (api.program.Displayer_Impl) 2017-05-22 User: SYSUSER  12:42:27.01 End  :         CIPCOMAN
SYSUSER - 205368-83934-1  2017-05-22 12:42:27,024 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO  (support.context.FrameworkSession) (Server Message)
Category: 3
Number: 253
Call Sequence: ;CIPCPPHR;CIPCOMAN
Program Name: CIPCPPHR
Text: Person ID field missing
Descri

Expected Result
----------------------
SA should have been activated and no change on Person Phone list should.

Business impact
-----------------------
SAs cannot be activated.

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