Asked a question 9 months ago

Hello, when i enter data with a PL/SQL procedure with B_CREDATE and B_UPDDATE fields mapped with SYSTIMESTAMP then i have SYSTIMESTAMP generated dates in my SD table. When i dont mapped them, they are NULL in my SD table instead of being set to submit date of the batch, why so ? thanks in advance


Peter TseSEMARCHY TEAM
Training & Solutions Architect at Semarchy

Hello Hammad

If B_CREDATE or B_UPDDATE  are not mapped or loaded, then the columns will remain NULL. 

You should map or populate these columns with values from your PL/SQL procs.

It looks like there is a documentation bug in our Integration Guide which wrongly states that the columns are set to the submit date of the batch. I will raise an issue on our side.

Thank you for pointing this out.

Regards, Peter