2 Replies Latest reply: Feb 5, 2016 9:29 AM by Maurice ludo RSS

    Error rechargement

    Maurice ludo

      Bonjour,

      j'ai un souci de rechargement et je n'arrive pas a identifier l'erreur,

      quelqu'un peux m'aider SVP

      merci

      voici les lignes

      [RMSMART_FLARE.SA_SMAR_RM]:

        SQL select 

      sfsr.LEGAL_ENTITY_ID ,

        sfsr.COMPANY_ID ,

        ssi.CODE_RU ,

      translate(ssi.period,'1.','1') ,

        sum(ssi.montant) as ACTUALSMART,

        nvl(ssi.TIERS_1, ssi.TIERS2),

        ssi.compte,

       

        case when ssi.NATURE='0LIA01' then 'Collect'

      else  'Conso' end AS NATURE ,

      case when sfso.OPEX_COST_BASELINE ='X' then 'OPEX_COST_BASELINE'

             when sfso.OPEX_ROC ='X' then 'OPEX_ROC'

              when sfso.OTHER_EBITDA_OPEX ='X' then 'OTHER_EBITDA_OPEX'

              else 'N/A'

           end as OPEX_TYPE

       

             from FLARE.SA_SMAR_RM ssi

           inner join FLARE.SA_FLARE_SMART_REF_RU sfsr on

      ( sfsr.RU_ID=ssi.CODE_RU and sysdate between sfsr.VALID_FROM_DT and sfsr.VALID_TO_DT)

          

          inner join  FLARE.SA_FLARE_SPLIT_OPEX_CC_S_P  sfso

      on (ssi.compte= substr( sfso.SMART_ACCOUNT_ID,6,10) and

      (sysdate between sfso.VALID_FROM_DT and sfso.VALID_TO_DT) )

       

        where ssi.FLUX='F99'

      and ssi.CLASSE='R'

      and substr(ssi.period,6,2 )  in ('01','02','04','05','07','08','10','11')

                 group by sfsr.LEGAL_ENTITY_ID ,

        sfsr.COMPANY_ID ,

      ssi.CODE_RU ,

        translate(ssi.period,'1.','1') ,

       

      case when ssi.NATURE='0LIA01' then 'Collect'

      else  'Conso' end  ,

      case when sfso.OPEX_COST_BASELINE ='X' then 'OPEX_COST_BASELINE'

             when sfso.OPEX_ROC ='X' then 'OPEX_ROC'

             when sfso.OTHER_EBITDA_OPEX ='X' then 'OTHER_EBITDA_OPEX'

           else 'N/A'

           end

           Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-00979: not a GROUP BY expression

             General Script Error

             Execution Failed

           Execution finished.