dtujo2022
Member
I have an Orchestration that has an input of a UKID that is then using a data request to fetch a record from a table. Two of the columns it is fetching are Date Fields where one or the other is populated with a date and the other is populated with a zero. I can confirm this is the case with Oracle SQL developer where the column is 0. When sending the data from the DREQ into a logic extension I receive the errors {28=DD validation failed for value null} or {29=DD validation failed for value null} depending on which field is populated with a date and which field is zero. I have also tried setting a default value in the Logic Extensions transformations and setting it to 0 as well as making sure those inputs are not required. Am I missing something here? Is JDE automatically assigning 0 as null for transformations in the Orchestrator?