Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think you have to add
nvl(ssi.TIERS_1, ssi.TIERS2),
ssi.compte,
to the group by
or comment these 2 fields and see if it works
it's ok, thank you M G