Start a new topic
Answered

PL/SQL Procedure With B_CREDATE and B_UPDDATE Not Mapped or Loaded, Columns Will Be Null

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


Best Answer

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

1 Comment

Answer

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

Login to post a comment