Error SBL-DAT-00225 When Trying To Run a Bulk Member Adjustment In A Non-ENU Environment
(Doc ID 2997922.1)
Last updated on JANUARY 15, 2024
Applies to:
Siebel Loyalty Engine - Version 15.0 [IP2015] and laterInformation in this document applies to any platform.
Symptoms
In an Non-ENU environment, when trying Adjust Points" using "Bulk Member Admin", it fails with the error below:
SBL-DAT-00225: Il valore immesso nel campo Transaction Sub Type del Business Component LOY ABB Transaction non corrisponde a nessun valore nell'elenco di selezione collegato LOY PickList Transaction Sub Type
SBL-DAT-00225: The value entered in field Transaction Sub Type of Business Component LOY ABB Transaction does not match any value in the bounded pick list LOY PickList Transaction Sub Type
SBL-DAT-00225: The value entered in field Transaction Sub Type of Business Component LOY ABB Transaction does not match any value in the bounded pick list LOY PickList Transaction Sub Type
The error happened just after the query below found in the Workflow Process Manager log:
ObjMgrSqlLog Detail 4 0000078a657a07f8:0 2023-12-14 13:28:03 SELECT statement with ID: 1F8AD5A0
SELECT
T1.CONFLICT_ID,
CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8),
CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' + CONVERT (VARCHAR (10),T1.CREATED, 8),
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.PRODUCT_ID,
T1.TXN_TYPE_CD,
CAST(? AS VARCHAR(128))
FROM
dbo.S_LOY_SRV_PROD T1
WHERE
(T1.OBJECT_TYPE = 'SRV') AND
(T1.TXN_TYPE_CD = ?)
ObjMgrSqlLog Detail 4 0000078a657a07f8:0 2023-12-14 13:28:03 Bind variable 1: WfProcMgr,xxxxx,16777242,SADMIN,0000078a657a07f8:0,,LOY Service Product Assoc,
ObjMgrSqlLog Detail 4 0000078a657a07f8:0 2023-12-14 13:28:03 Bind variable 2: Accredito manuale
ObjMgrSqlLog Debug 5 0000078a657a07f8:0 2023-12-14 13:28:03 User search spec: [Transaction Type] = "Accredito manuale"
ObjMgrSqlLog Debug 5 0000078a657a07f8:0 2023-12-14 13:28:03 Named search [System Search]: [Object Type] = 'SRV'
SELECT
T1.CONFLICT_ID,
CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8),
CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' + CONVERT (VARCHAR (10),T1.CREATED, 8),
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.PRODUCT_ID,
T1.TXN_TYPE_CD,
CAST(? AS VARCHAR(128))
FROM
dbo.S_LOY_SRV_PROD T1
WHERE
(T1.OBJECT_TYPE = 'SRV') AND
(T1.TXN_TYPE_CD = ?)
ObjMgrSqlLog Detail 4 0000078a657a07f8:0 2023-12-14 13:28:03 Bind variable 1: WfProcMgr,xxxxx,16777242,SADMIN,0000078a657a07f8:0,,LOY Service Product Assoc,
ObjMgrSqlLog Detail 4 0000078a657a07f8:0 2023-12-14 13:28:03 Bind variable 2: Accredito manuale
ObjMgrSqlLog Debug 5 0000078a657a07f8:0 2023-12-14 13:28:03 User search spec: [Transaction Type] = "Accredito manuale"
ObjMgrSqlLog Debug 5 0000078a657a07f8:0 2023-12-14 13:28:03 Named search [System Search]: [Object Type] = 'SRV'
The issue can be reproduced at will with the following steps:
1. Login to the ITA language Application
2. In the Loyalty Program, navigate to the Bulk Membership Administration
3. Process an Action of "Adjust Points"
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 |