Project Status

Client/Agency: Duke Energy/CCC
Project Extention: May 2005 - May 2006, 54 Weeks.

Project Summary:

Long term maintenance project, replacing VB code with Java 2/C# code.

Skill Sets Employed:

Java and IBM Web Sphere Application Server (WSAD), Microsoft C#, JAVA 2, JSP, Servlets, Microsoft Visual Studio.NET 2003, XML, Cobol, DB2, CICS.

Classes Attended:

JAVA Training Class 2004-2.


Last Week / Outstanding PCR's / Links / Bottom of Page

Entries in black History / Entries in red last/current week / Entries in blue Projected weeks

Overall Active PCR Status
Blue Currently Working on, Red complete & ready for Prod move:

Task PCR's:

Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs, last update 8/11. Sent note to TB pertaining to this PCR.
Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
Product Change Request ID RKR10974-22, Generation meters for HP accounts , ChangeMan Package # YCPS012091. Put on hold until end of July per KW.
Product Change Request ID SSC10013-32, Dashboard -Cycle Bills Rendered On Time measure is incorrect, ChangeMan Package # YCPS012128. PCR resurrected, currently under analysis.
08/10/05 - Review August run stats for job W037BPM2(08/14/2005) , concentrating on late rerouted accounts. Manually calculate days late & compare with report values, run query DEHUENG.LATEREROUTES in prda Using following formula: Process Date is the Start Date, Bill Mail Date is the end date. Days Late = (End Date - Start Date) – 3 * *Only counting Business Days
11/08/2005 - Reviewed the 10092005 run following results: Reviewed RMDS output, table late reroutes from that date & manually calculated days late for rerouted accounts.
12/01/2005 - Attempted to establish comms with BU, need to resolve/ID problem accounts.
4/27/2006 - Waiting for BU for added data.
 Product Change Request ID PPJ13356-45, Random Selection of Revenue Actions < $500" & "All Revenue Adjustment Actions >= $500, ChangeMan Package # YCPS012537.
3/31/2006 - Unable to verify problem in production, on the Random Selection of Revenue Actions < $500 report for A11 Transaction code (Adjust Receivable) that there is a 'doubling' effect - transaction ADJ DLRS are being doubled and shown in the DOLLAR AMOUNT section as being doubled - Example - Acct 1252123004 in CBISQA - adjust receivable entered for $1.30 - ADJ DLRS showing as $1.30, but business unit totals section shows $2.60 ** .
4/27/2006 - 
Pertaining to subject PCR.
Doubling noted in QA for RECEIV_IDN =1721999075 after non damaged Testing.  Above doubling a result of adjustments made to the account, when an adjustment is made a detail line is generated after the standard detail line from data aquired by the following query:

SELECT
         CRGCMP.REGIS_TYPE_CODE
       , RCVCRG.RECEIV_IDN
       , RCVCRG.CHRG_CMPT_CODE
       , RCVCRG.CHRG_AMOUNT_DLRS
       , RCVCRG.PRECISE_BILLED_QTY
FROM
         CBISQA.CHARGE_COMPONENT  CRGCMP
       , CBISQA.RECEIVABLE_CHARGE  RCVCRG
WHERE
         RCVCRG.RECEIV_IDN =1721999075
    --      :KEYSET-RECEIV-IDN
  AND
         CRGCMP.CHRG_CMPT_CODE =
             RCVCRG.CHRG_CMPT_CODE

Results from above Query:


REGIS                CHRG             CHRG            PRECISE
TYPE         RECEIV  CMPT            AMOUNT           BILLED
CODE          IDN    CODE             DLRS              QTY
------  -----------  ----  ----------------  ----------------
-        1721999075  ST               -8.08             0.000

This data is used to populate a 2nd detail line with the charge component code & the charge amount dollars.
In short if an adjustment is made to the account it will generate a detail line the amount generated, thisamount will be displayed & tallied on the report.

Resolution modification of code however the Buss User deems pertinent. 

Again the number of entries generated by the random < 500/00 report is contingent on the value returned by query

SELECT   COUNT(*)
--INTO  :TRNLOG-IDN
FROM     CBIS.TRANSACTION_LOG  TRNLOG,
         CBIS.TRANSACTION_CODE TRANCD
WHERE    TRNLOG.TRANSACTION_CODE     =  TRANCD.CODE
AND      TRANCD.MONTRY_REPORT_CODE   = 'REV'
AND      TRNLOG.CREATE_TMSTMP       >= '2006-04-05-04.00.22.979689'

Extracted Value:

       COL1
-----------
       1779

Calcualation of WS-RANDOM-VALUE-REV:

EVALUATE TRUE
   WHEN TRNLOG10-IDN = 0
       MOVE +30 TO WS-RANDOM-VALUE-REV

   WHEN TRNLOG10-IDN <= WS-RANDOM-COUNT
       MOVE +1 TO WS-RANDOM-VALUE-REV

   WHEN OTHER
      COMPUTE WS-RANDOM-VALUE-REV ROUNDED =
             (TRNLOG10-IDN / 30)

END-EVALUATE
Product Change Request ID MBS11117-8, Change CBIS Route Download Process to Correct Probe Problem. ChangeMan Package # YCPS012586.
4/06/2006 - Problem lies with program PXDST110 need to Add mods to paragraph BUILD-TOU-RECORD in program PXDSP110. Questions a. Just TOU records? note sent to JM for resolution.
4/24/2006 - Waiting on BU feed back.

Tracking PCR's, PROJECTS:

MLP12994-49 (Refund Signature Change), MJE13094-42 (Changes 4/21 Prod) , No Tracking PCR for Project. SYNERGY Merger Project. All required mods AFP (MF will handle).
2/27/2006 - Project Kick-Off. To date no Watts # & tracking PCR.
3/07/2006 - Modified refund check Logo.
3/13/2006 - Generaed Nantahala letters(in-house), sent to BU for review.
3/29/2006 - Modified refund check Logo sent to AT&T for test, BU has some questions on logo size.
3/31/2006 - Modified refund check new signature moved into prod for Legal Day One.
4/21/2006 - Modified refund check (new logo) moved to production.
Implementation Schedule:
Refund Check (Signature Change) - Completed 3/31/2006.
Logo on Refund Checks - Completed 4/21/2006.
Nantahala Delq letters 04/27/2006.
Bill Messaging mods 05/01/06.

SoftWare Linkage Sites:

AFP Tech Area
XML Site
XML Training/Certification
Servlets & JSP
Java Net Beans
WinRunner
FTP Return Codes, Assignment of.
Java Tips / A simple Servlet / Compiling a Servlet / Deploying a Servlet / Dynamic Example / Printer Friendly Version.
JAVA Training Class 2004-2.
IBM JCL Pub/IBM OS 390 Pub / IBM OS 390 Pub
WebSphere Tutorial
Visual Explain
DB2 Misc TidBits
Java Passport Chapter 2/Java Passport Chapter 3/Java Passport Chapter 11/
Note to capture various application windows use key board print screen button, alt & print button will capture sub window stationed on.
DOM Technical Link
PCR History


Top of Page

URL :dukeenergy3.html

Revised:1/10/2005

Layout, design & revisions David E. Huenger