Skip to main content

Hi,

I am trying to set up Databas task schedule for Calc Purch Costs in IFS Cloud but I have got error in backgrundsjobb, please see the error message. I would like to use SYSDATE in date parameter but not sure if you can use SYSDATE as syntax. Could anyone advice me how I should write here? 

 

Error text

ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2075
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2020
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 286
 ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2075
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2020
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 286
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 861
 

I think it would be better if you take the date parameters as varchar and convert them to dates in the context of a function, procedure or SQL statement.

Reply


Terms & ConditionsCookie settings