Skip to main content
Question

Date parameter error in Database Task schedule

  • June 12, 2024
  • 1 reply
  • 71 views
A
Sidekick (Customer)
Forum|alt.badge.img+8

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
 

1 reply

asahin
Do Gooder (Customer)
Forum|alt.badge.img+4
  • asahin
  • Do Gooder (Customer)
  • June 13, 2024
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.
https://www.linkedin.com/in/ayhansahin-70547112b/
Terms & ConditionsCookie settingsAccessibility statement