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

Start a new topic

Answered

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

Fathia Jama

started a topic over 2 years 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

Best Answer

Fathia Jama said over 2 years ago

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