E1: UBE: Level Break on Alpha Field does not Ignore Case Sensitive Data in SQL Database (Doc ID 2206324.1)

Last updated on AUGUST 14, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Data is stored case insensitive in SQL database. When level break footer is defined on Alpha field in Report Design Aid, UBE creates multiple level break footers on same case insensitive data, when it should be a single level break footer

Steps to Duplicate:

1. Fastpath P01012 Work With Addresses

Find Address Number 77, click Copy
Populate Address Number with 881, Alpha Name with ABC (uppercase)
Find abc in QBE(Alpha Name)
Should return Address Number 881, click Copy
Populate Address Number with 882, Alpha Name with abc (lowercase)
Find abc in QBE(Alpha Name)
Should return Address Numbers 881, 882

2. Fastpath OMW, copy R014021 to R584201

3. Go into RDA of R584021

Section Address Book-One Line Report
Add data selection on BC_Address Number(AN8): 881, 882
Modify data sequence, remove Alias DC, add Alias ALPH (Alpha Name)
Sort properties, check Level Break
Create Level Break Footer section on Alpha Name
Insert report constant, in properties change variable name to LBFooter(AlphaName)

4. Run R584021 local. In PDF level break occurs each on 881 and 882 taking into account the case sensitive data

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