Error "invalid identifier" when using a Custom Member Attribute in the Loyalty Promotion (Doc ID 2360277.1)

Last updated on MAY 17, 2021

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.