Forum Stats

  • 3,768,285 Users
  • 2,252,771 Discussions
  • 7,874,515 Comments

Discussions

Error duering regenerate scenario

Sangeeta Pandey
Sangeeta Pandey Member Posts: 196 Red Ribbon

Hello Experts,

I am wondering about below error when using below filter condition in my ODI mapping:

Filter

(

(

(TRX_RESERVATION_V.RESCL_FINALIZED_DT_WID BETWEEN 19000101

and TO_NUMBER(TO_CHAR(SYSDATE-1, 'YYYYMMDD'))) and TRX_RESERVATION_V.CONSCL_FINALIZED_DT_WID <>'-1'

AND TRX_RESERVATION_V.CONSCL_REVERSAL_INDICATOR ='Y'

)

OR

(

(TRX_RESERVATION_V.RESCL_FINALIZED_DT_WID BETWEEN 19000101

and TO_NUMBER(TO_CHAR(SYSDATE-1, 'YYYYMMDD'))) and TRX_RESERVATION_V.CONSCL_FINALIZED_DT_WID <>'-1'

AND TRX_RESERVATION_V.CONSCL_REVERSAL_INDICATOR ='N'

AND TRX_RESERVATION_V.RESCL_REVERSAL_INDICATOR ='N'

and not exists

(

select count(1)

from OHAPAH_TRX.TRX_RESERVATION_V V3

where TRX_RESERVATION_V.reserv_claim_code=v3.reserv_claim_code

and TRX_RESERVATION_V.reserv_claim_version=v3.reserv_claim_version

and TRX_RESERVATION_V.RESCL_REVERSAL_INDICATOR='N'

group by TRX_RESERVATION_V.reserv_claim_code,TRX_RESERVATION_V.reserv_claim_version, TRX_RESERVATION_V.RESCL_REVERSAL_INDICATOR

having count(1) >1

)

)

)

Error

If I run the sql query with this filter through sql developer, it is running fine:

Kindly help !!!


Thanks,