"You have attempted to insert the value for the column 'GEN_DATE' in the table 'S_XMLP_REPOUTPT' twice in the same statement. (SBL-DAT-00418)" workaround. (Doc ID 2283858.1)

Last updated on AUGUST 01, 2017

Applies to:

Siebel CRM - Version 8.1.1.11.1 [IP2013] and later
Information in this document applies to any platform.

Goal

Issue description:-

1.Customer's first action (added PreDefault to Field "ReportGenerationStartTime") worked fine for the Generation of the report as Attachment with a Button.
   But the generation as E-Mail Attachment didn't work anymore (got error SBL-DAT-00418, please see below), so they removed PreDefault

    from  Field "ReportGenerationStartTime"to Field "Time Generated" in BC "Report Output BC".

2.Customer gets SBL-DAT-00418-error, when he tries to generate any report in the normal way with the Reports-Button in the Siebel Menu:
    "You have attempted to insert the value for the column 'GEN_DATE' in the table 'S_XMLP_REPOUTPT' twice in the same statement. (SBL-DAT-00418)"


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms