PL/SQL Procedure With B_CREDATE and B_UPDDATE Not Mapped or Loaded, Columns Will Be Null
F
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
F
Fathia Jama
said
over 2 years ago
Hello Hammad
If B_CREDATE orB_UPDDATEare 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
F
Fathia Jama
said
over 2 years ago
Answer
Hello Hammad
If B_CREDATE orB_UPDDATEare 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.
Fathia Jama
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
Hello Hammad
If
B_CREDATE
orB_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
Fathia Jama
Hello Hammad
If
B_CREDATE
orB_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
-
Import Data Into Entities via Azure Data Lake
-
Recover Deleted(soft Delete) Record and Configure in Application
-
Data Quality in batch mode and real-time integration
-
Integration with analytics tools
-
Query/Load/Delete data with the REST API
-
Does the Done Tab in Inbox have a limit?
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Matching Rules But Only The Latest Record Creates a Golden Record
-
Unstructured and Semi Structured Data in Semarchy?
-
Read CSV files from AWS S3
See all 72 topics