5 Replies Latest reply: Aug 26, 2014 10:39 PM by Nagaian Krishnamoorthy RSS

    preceding load with sql statement  column names are not loading in Properties -> Available fields

      OS_NET :

      LOAD

      OSPAY as OS_PAY,

      OSREC as OS_REC

      where  CE_CLOSE_DT>Today() AND CLM_CLOSE_DT<= Today()

      ;

      SQL SELECT comp_short_name,trunc(CLM_CLOSE_DT),TRUNC(CE_CLOSE_DT),CLM_RISK_SR_NO,CE_RISK_SR_NO,NVL(SUM(DECODE(CE_EST_TYPE, '1', NVL(CE_AMT_LC_1, 0), 0) - DECODE(CE_EST_TYPE, '3', NVL(CE_AMT_LC_1, 0), 0)), 0) OSPAY,

        NVL(SUM(DECODE(CE_EST_TYPE, '2', NVL(CE_AMT_LC_1, 0), 0) - DECODE(CE_EST_TYPE, '4', NVL(CE_AMT_LC_1, 0), 0)), 0)  OSREC 

             FROM t_gi_claim, T_gi_clm_est, m_company

            WHERE   clm_trans_id = CE_CLM_TRANS_ID

             AND (NVL(CLM_STATUS,'N') <> 'C' OR (NVL(CLM_STATUS, 'N') = 'C' AND  :P_REP_VAL_45 <=  TRUNC(CLM_CLOSE_DT)))

             AND NVL(CLM_STATUS,'N') <> 'R'     

            AND (NVL(CE_CLOSE_YN, '0') = '0'

             OR (NVL(CE_CLOSE_YN, '0') = '1' AND TRUNC(CE_CLOSE_DT) > :P_REP_VAL_45))       

              AND TRUNC(CE_DT) <= :P_REP_VAL_45

            AND  CLM_RISK_SR_NO = CE_RISK_SR_NO

              AND CLM_SOURCE_FM=CE_SOURCE_FM

              AND CLM_LOB_CODE=CE_LOB_CODE

              --and CLM_TRANS_ID=CE_CLM_TRANS_ID

              AND CLM_COMP_CODE=CE_COMP_CODE

              and  clm_close_dt is not null

              and CLM_COMP_CODE= comp_code group by comp_short_name,trunc(CLM_CLOSE_DT),CLM_RISK_SR_NO,CE_RISK_SR_NO,TRUNC(CE_CLOSE_DT);

       

       

      i want to display OSPAY as OS_PAY, OSREC as OS_REC . The script executes fine without any error but the  OSPAY as OS_PAY, OSREC as OS_REC   is not listed in properties -> available fields