Instantiation of Export List for Siebel Campaigns

Once a direct mail Campaign is launched/executed in Siebel, a Export List is instantiated based on the Export List format (defined in OBIEE and typically containing the Campaign Members), writing the file to the shared marketing file system for distributing to external Agencies.

This progress and completion of the process between OBIEE writing the file and Siebel loading the file via the Integration Object to the Campaign Member Table S_CAMP_CON can also be check from the Task Log Applet of the Campaign :


While the Oracle BI system will check the current campaign Members (at point of launching the Campaign) and associate the data according to the export list format definition, not all scenarios might return data. E.g. a Export list may join the Campaign Members with a Asset, but in case of a small Campaign maybe none of the selected Members might own a Asset resulting in zero Records. In this no(zero) records is the correct result of the Export List. This is also displayed as a Warning in the Task Log Applet:


However, a Bug exists (3-12931858661 : List Export formats in Marketing Segmentation behave differently when there is no data) in the current release of Oracle BI (OBIEE) for this process, as a file containing zero Records is not written as a file (no file created) leading to a Error in Siebel instead:


Since the Issue is with Oracle BI this can also be re-produced within the Oracle BI instance. When clicking the Generate Preview button a error Message is displayed in the List Format designer, informing that no file has been created:


Which is also logged in the Administration of Marketing Jobs view:

The Workaround

To enforce the generation of Export files, even in case of zero records the XML definition of the Export List needs to be changed by adding a header / footer XML tag.

When creating a new Export list the XML definition does not contain a header / footer XML Tag when clicking the “Get XML” Button:

To add a header / footer Tag to the XML definition of the Export list, one needs to just click on the Header and Footer Tab and then click the “Set XML” Button resulting in a header / footer Tag in the XML definition:

This header/ footer Tag will ensure that a Export file is always written to the shared Marketing file system. The preview looks then like the following:

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.