Error "invalid identifier" when using a Custom Member Attribute in the Loyalty Promotion
(Doc ID 2360277.1)
Last updated on JULY 08, 2020
Applies to:
Siebel Loyalty Engine - Version 16.0 [IP2016] and laterInformation in this document applies to any platform.
Symptoms
On : 16.0 [IP2016] version, Loyalty
When processing a Transaction, the custom Member Attribute is not updated in the S_LOY_MEMBER_X table. The following error occurs:
ERROR
-----------------------
SQLParseAndExecute Execute 5 000000095a7c0a20:0 2018-02-08 07:21:55 OCIStmtExecute: DML error or affected 0 rows
ObjMgrBusCompLog Error 1 000000095a7c0a20:0 2018-02-08 07:21:55 (oracon.cpp (3919)) SBL-DBC-00111: An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute Execute 5 000000095a7c0a20:0 2018-02-08 07:21:55 ORA-00904: "ATTRIB_12": invalid identifier
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Add to the LOY Member BC and LOY engine Member a new field joining to S_LOY_MEMBER_X > ATTRIB_12
Name:: ABC Last Transaction Date
- compile
- In Admin - Data -> List Of Values. Query for LOY_ATTRIB_FIELDS_MEMEBER. Add "ABC Last Transaction Date" as Display Name and LIC .
- In LOY Programs > Program Level Attribute, add a new Member field Attribute:
Name : ABC Last Transaction Date
Field : ABC Last Transaction Date
Read Only : N
Active : Y
- Add a Transaction Attribute so this can be used as source field to update custom field.
-- LOY Programs > Program Level Attribute > Transaction Attribute
Name: ABC Txn Date
Field: Transaction Date
- Create a Promotion - ABC Update Custom Attribute:
Rule Action:
Type: Update Attribute
Update this attribute
Object: Member
Attribute: ABC Last Transaction Date
Action: Set
With this attribute:
Object: Transaction
Attribute: ABC Txn Date
- Create a Transaction and process it
- Check the Processing Info
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |