This discussion is archived
10 Replies Latest reply: Dec 26, 2012 8:49 PM by asifkabirdba RSS

Ora-600

846231 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points