10 Replies Latest reply: Dec 26, 2012 10:49 PM by asifkabirdba RSS

    Ora-600

    846231
      Hi all,

      11.2.0.1

      Have you encountered this kind of issue?
      SQL> SELECT 'MTR PRF' MTR_PREFIX
        2                          , 'MTR SZE' MTR_SIZE
        3                          , MTR.MTR_ID
        4                          , 'City' ACCT_CITY
        5                          , ACCT.CUST_CL_CD
        6                          , (SELECT ENTITY_NAME
        7                              FROM CI_PER_NAME PERNAME
        8                                , CI_ACCT_PER ACCTPER
        9                              WHERE ACCTPER.ACCT_ID = ACCT.ACCT_ID
       10                                AND ACCTPER.MAIN_CUST_SW = 'Y'
       11                                AND PERNAME.PER_ID = ACCTPER.PER_ID
       12                                AND PERNAME.NAME_TYPE_FLG = 'PRIM') ENTITY_NAME
       13                          , 'Postal' POSTAL
       14                          , 'State' STATE
       15                          , 'Cons 1' SA_CHAR1
       16                          , 'Cons 2' SA_CHAR2
       17                          , 'Cons 3' SA_CHAR3
       18                          , BILL.BILL_DT -- Computed
       19                          , ACCT.BILL_CYC_CD
       20                          , BILL.BILL_DT
       21                          , BILL.DUE_DT
       22                          , BILL.BILL_STAT_FLG
       23                          , 'CNCL' BILL_CAN_RSN
       24                          , ACCT.ACCT_ID
       25                          , (SELECT SUM(TOT_AMT)
       26                            FROM CI_FT FT
       27                            WHERE FT.BILL_ID = BILL.BILL_ID) TOT_AMT
       28                          , '0000000000' -- CIS Account #
       29                          , 'CITY EX'
       30                          , SP.SP_TYPE_CD
       31                          , 'Cnl Dist' -- Council District
       32                          , 'District'
       33                          , 'HOUSE SZE'
       34                          , SYSDATE -- Last Read Date
       35                          , 'LOT SZE'
       36                          , 0.00 -- Tier 1 Consumption
       37                          , 0.00 -- Tier 1 Rev
       38                          , 0.00 -- Tier 2 Consumption
       39                          , 0.00 -- Tier 2 Rev
       40                          , 0.00 -- Low Income
       41                          , 0.00 -- Lifeline
       42                          , 0.00 -- Sewer Surcharge
       43                          , 0.00 -- Sewer CR
       44                          , 'Mailing Address'
       45                          , 'RT' -- Read Type
       46                          , 'NAICS' -- NAICS Code
       47                          , SYSDATE -- Accounting Date
       48                          , SYSDATE -- Freeze Date
       49                          , 'RT Class' -- Rate Class
       50                          , 'RD Code' -- Rate Code
       51                          , MTR.SERIAL_NBR
       52                          , 'PREM.ADDRESS1' -- PREM.ADDRESS1
       53                          , 'SVC NBR' -- Service Number
       54                          , 'SEWER CHG' -- Sewer Charge Code
       55                          , 'SEWER REV' -- Sewer Rev
       56                          , SA.SIC_CD
       57                          , 0.00 -- Water Consumption
       58                          , 0.00 -- Calculated
       59                  FROM CI_SA SA
       60                  INNER JOIN CI_ACCT ACCT ON (ACCT.ACCT_ID = SA.ACCT_ID)
       61                  INNER JOIN CI_BILL BILL ON (BILL.ACCT_ID = ACCT.ACCT_ID)
       62                  INNER JOIN CI_SA_SP SASP ON (SASP.SA_ID = SA.SA_ID)
       63                  INNER JOIN CI_SP SP ON (SP.SP_ID = SASP.SP_ID)
       64                  INNER JOIN CI_SP_MTR_HIST SP_MTR_HIST ON (SP_MTR_HIST.SP_ID = SP.SP_ID)
       65                  INNER JOIN CI_MTR_CONFIG MTR_CONFIG ON (MTR_CONFIG.MTR_CONFIG_ID = SP_MTR_HIST.MTR_CONFIG_ID)
       66                  INNER JOIN CI_MTR MTR ON (MTR.MTR_ID = MTR_CONFIG.MTR_ID)
       67                  WHERE SA.SA_TYPE_CD IN (SELECT SATY.SA_TYPE_CD FROM CI_SA_TYPE SATY WHERE SATY.SVC_TYPE_CD IN ('W', 'WW') AND SA.SA_TYPE_CD = SATY.SA_TYPE_CD)
       68                    AND SA.SA_STATUS_FLG IN ('20', '30', '40', '50', '60')
       69                    AND (BILL.BILL_DT >= TO_DATE('2000-01-01.00.00.00', 'YYYY-MM-DD.HH24.MI.SS')
       70                    AND BILL.BILL_DT <= TO_DATE('2000-01-01.23.59.59', 'YYYY-MM-DD.HH24.MI.SS'))
       71                    AND SASP.STOP_MR_ID = ' '
       72                    AND SASP.START_DTTM = (SELECT MAX(SASP1.START_DTTM)
       73                                          FROM CI_SA_SP SASP1
       74                                          WHERE SASP1.STOP_MR_ID = ' '
       75                                          AND SASP.SA_SP_ID = SASP1.SA_SP_ID)
       76                    AND SP_MTR_HIST.SP_ID = SP.SP_ID
       77                    AND SP_MTR_HIST.REMOVAL_MR_ID = ' ';
                      INNER JOIN CI_SA_SP SASP ON (SASP.SA_ID = SA.SA_ID)
                                 *
      ERROR at line 62:
      ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [],
      [], [], [], []
      How do I resolve this please.....

      Thanks a lot,
      Kinz