Add Products On Portal Catalog , Error in Log file SBL-DAT-00354 for LOY Product Offering

(Doc ID 1292765.1)

Last updated on AUGUST 24, 2016

Applies to:

Siebel Loyalty Engine - Version 8.1.1 [21112] and later
Information in this document applies to any platform.

Symptoms


In eLoy application -

1) Go to Catalog - select Category then product
2) drill down on the product - Points and Point type field is empty
3) Also Add item button is disable.

At product level -

Set Points - Point type and payment method Txn type as Redemption.
Pricing - Master Price list
Catalog and category - public.
Category level - set display template as Redemption and also tested with Product Template.

The products were released and added to the price list and same products added to the categories under the catalog.
The catalog is set to 'Buying' type and the categories have display template set to 'Redemption'
The catalog and categories are not flagged as 'private' and the access group has been added to all of them
Refreshed cache for the categories and refreshed the product cache.
When User login to the eLoyalty portal, the catalog and the categories are visible under 'Buy/Redeem Products'. The count of products are also being shown in braces against the category.

If you check the Log file for eLoy - there is an error -

I can see below query -
CchMgrLog CchMgrAcsInfo 4 0000000247841b8c:0 2008-01-09 05:23:19 Accesses item [LOY_OFFER_TYPE_CD.DO.ENU] in cache [LOV].
CchMgrLog CchMgrAcsInfo 4 0000000247841b8c:0 2008-01-09 05:23:19 Item [LOY_OFFER_TYPE_CD.DO.ENU] is in cache [LOV].
ObjMgrSqlObjLog Search 5 0000000247841b8c:0 2008-01-09 05:23:19 Begin: SetSearchSpec for SqlObj 'LOY Product Offering' at 19205558, Search Spec: '[Partner Id] = '1-45X9' AND [Product Id] = '04-EPZ0H' AND [Program Id] = '1-45XK' AND [Offer Type Cd] = 'Redemption' AND ( [Eff End Dt] >= '01/09/2008 04:23:19' OR [Eff End Dt] IS NULL ) AND [Eff Start Dt] <= '01/09/2008 04:23:19'
ObjMgrQueryLog Warning 2 0000000247841b8c:0 2008-01-09 05:23:19 (query.cpp (13993)) SBL-DAT-00354: The query could not be run because the criteria for field '<?>' contained an invalid arithmetic expression. Please ensure that the search criteria is correctly formatted.
This error is often caused by a missing operator (e.g. = or <) or missing quotes. If you aren't sure what may have caused this please contact your systems administrator.
ObjMgrSqlObjLog Search 5 0000000247841b8c:0 2008-01-09 05:23:19 End: SetSearchSpec for SqlObj at 19205558
ObjMgrSqlObjLog NamedSearch 5 0000000247841b8c:0 2008-01-09 05:23:19 Begin: SetNamedSearch for SqlObj 'LOY Product Offering' at 19205558, Named Search: 'Bookmark Id Named Search' - ''


The SearchSpec for BC 'LOY Product Offering' does not have a closing single quote.

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