Completed Circuits Custom Report Showing Dates as 00/01/1900 and Circuit Status as Pending, CLR/DLR Issued or In Progress

(Doc ID 2024404.1)

Last updated on JUNE 25, 2015

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Goal

QUESTIONS

Customer is printing a report of active circuits, but the query is bringing circuits that are not active as they are showing status : CLR Issued, Pending, Issued DLR.

Why is this happening, even by using the Serv_Item FROM_EFFECTIVE_DATE to TO_EFF_DT.

(1) Sample report (Excel spreadsheet) with 00/01/1900 date value

                     Date                Date                     Actual
Circuit           Activation        Disconnection     Activation         Validation
=========================================================
1456_1000    7/10/2014                                  00/01/1900      NOK
1456_1100    15/6/2015                                  15/06/2015      OK
1456_1102    8/4/2015                                    08/04/2015      OK
1456_1103    27/10/2014                                00/01/1900      NOK
- - -


(2) Sample run for the script used with Business Objects with invalid statuses:

First ECCKT    Min...           SvcType    Status
===========================================
1456_1000    1456_1000    ELINE       In Progress
1456_1100    1456_1100    ELINE       In Progress
1456_1102    1456_1102    ELINE       Pending
1456_1103    1456_1103    ELINE       Pending
1456_1227    1456_1227    ELINE       In Progress
1456_1607    1456_1607    ELINE       Pending
1456_1608    1456_1608    ELINE       Pending
1456_1609    1456_1609    ELINE       Pending
1496_1104    1496_1104    ELINE       In Service
1496_1104    1496_1104    ELINE       In Service
- - -

Solution

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