Repeating Program Stage or Repeating Campaign Fails with Error SBL-DAT-00498: 'Repeating Expires' is a required field. (Doc ID 2005636.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Marketing - Version 8.1.1.9 [23016] to 8.1.1.10 [23021] [Release V8]
Siebel Marketing - Version 8.2.2.2 SIA[23016] to 8.2.2.3 SIA [23021] [Release V8]
Information in this document applies to any platform.

Symptoms

After setting a number of columns/list of values (LOVs) as multilingual, including column S_EVT_ACT.APPT_REPT_TYPE / LOV REPEATING_APPT_TYPE, when attempting to schedule a Daily Repeating Program the following error occurs.

ERROR
-----------------------
SBL-DAT-00498: 'Repeating Expires' is a required field. Please enter a value for the field.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Deploy a multilingual environment (e.g. ENU, FRA, DEU etc)
2. In Siebel Tools query for the S_EVT_ACT table
3. Query for the column 'APPT_REPT_TYPE' column
4. Set the Translation Table property to S_LST_OF_VAL
5. Compile the table into the SRF and apply the schema change to the database.
6. Start the Siebel services
7. Log into Siebel Marketing
8. Go to Administration - Data > List Of Values and set:
  a) Display Value=REPEATING_APPT_TYPE (set Multilingual=Y)
  b) Type=REPEATING_APPT_TYPE (set Multilingual=Y and Active=Y)
  c) Click 'Clear Cache' button
9. Create a Campaign, Offer, Treatment and List
10. Associate Offer and Treatment to the Campaign
11. Associate List and Allocate the List to the Treatment (e.g. 100%)
12. Create a Program record in Programs screen
13. Drill onto the Program record
13. In the Program Designer, drag the Stage icon to the palette and then the Campaign icon
14. Associate the Campaign record created in 9 with the Stage
15. Double click the Stage
16. Go from Schedule > Details to Schedule > Calendar
17. Click New button (or click on day if it works)
18. Set:
Type: Stage Execution
Planned Start: Date/Time+a few minutes
Stage: Select the Stage created
Frequency: Daily
19. Make sure 'Active Flag' is set to Y and then click 'Save This One'
20. When the Planned Start date/time comes, you should see the Stage being executed. It will error out with the above error message.

Cause

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