Hi Gurus,
I am facing an issue with creating an Objects. Below is my code
case when IOWA.SHIPMENT.SHIPMENTTYPE = 'BOOKOUT' then 24+trunc(IOWA.FINDETAIL.BEGTIME, 'MM') -- 25th of Delivery Month when IOWA.TRADE.TRADETYPE like '%SWAP' then 4+Add_months(trunc(IOWA.FINDETAIL.BEGTIME, 'MM'),1) -- 5th of Month after Delivery Month when IOWA.TRADE.TRADETYPE = 'PHYSICAL COAL' then case when IOWA.COUNTERPARTY.MASTERAGREEMENT = 'N' and IOWA.TRADE.INVFREQ = 'BI-MONTHLY' then IOWA.FINDETAIL.BEGTIME+14 --14 days + Payment Terms else -1+Add_months(trunc(IOWA.FINDETAIL.BEGTIME, 'MM'),1) -- End of Delivery Month + Payment Terms end + case when IOWA.FINDETAIL.PAYMENTTERMS is not null then 'timecount' else 0 end else -1+Add_months(trunc(IOWA.FINDETAIL.BEGTIME, 'MM'),1) -- End of Delivery Month end
ERROR
Parse failed: Exeption: DBD,ORA-00932:inconistent datatypes: expected CHAR got NUMBER
Edited by: S.N... on Nov 28, 2011 5:02 PM