Loyalty Error Updating custom TransactionAttribute (Doc ID 1969387.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Loyalty Engine - Version 8.1.1.11.10 [IP2013] to 8.1.1.11.15 [IP2013] [Release V8]
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11.10 [IP2013] version, Loyalty

When attempting to process an attribute on a custom column
the following error occurs.

ERROR
-----------------------
An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)ORA-00904:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Add to the LOY Transaction a new field joining to S_LOY_TXN_X > ATTRIB_15 named : Test Attribute

- Add to the LOY Engine Transaction BC a new field joining to S_LOY_TXN_X > ATTRIB_15 named : Test Attribute

- As per doc id : How To Create a New Transaction Attribute and Use it Within a Loyalty Promotion (Doc ID 473916.1)
add :
the LOV for : LOY_ATTRIB_FIELDS_TXN, add the 'Test Attribute' and select 'Clear Cache'

- Navigate to Program Administration > Program Level Attributes > Transaction Attributes. Add the 'Test Attribute' and uncheck the read only checkbox

- Add to the promotion action:
 - Apply to Transaction
 - Promotion Action : Update Attribute
 - Add in the 'Test Attribute value and set 'Add 100'

This should add 100 to the attribute value.

Run the transaction.

Error seen is:
---
An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application
configuration if the problem persists.(SBL-DBC-00111)ORA-00904:

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot add custom attributes

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