Oracle Loyalty: Reports Returns Less Rows When Using a Different Language
(Doc ID 2641074.1)
Last updated on FEBRUARY 24, 2020
Applies to:Oracle Fusion Loyalty - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
This issue impacts Oracle Loyalty 19D and 20A.
If you apply report filters under a given NLS setting on any deprecated code Presentation Columns, then the report you are attempting to view does not return any records if you view the Report under a different NLS setting. For example, if you apply the following filter expression under US English, then the report does not return any records under the Korean language NLS setting:
Member Status Code = 'Active' (US English)
Some of the out of the box reports where this issue is observed:
Loyalty - Member Revenue by Partner
Loyalty - Member Revenue by Product
Loyalty - Members at Risk
Loyalty - Members By Status
Loyalty - Partner Revenue - Trend Chart
Loyalty - Partner Transactions
Loyalty - Points Expired
Loyalty - Points Expiring
Loyalty - Primary Points Accrual, Redemption, Expiration and Point Balance Trend
Loyalty - Program Liability Trend
Loyalty - Program Revenue YoY
Loyalty - Programs at a Glance
Loyalty - Redemption Velocity
Loyalty - Revenue by Partner
Loyalty - Top N Partners by Revenue
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