FUSION APPLICATIONS: BI PUBLISHER: Date Parameters, When Profile Is Not English, Do Not Produce Results.

(Doc ID 2104683.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Using BI Publisher in Fusion Applications 11.1.9.2.0 and later, using dates as parameters in a report that is not in the English language locale does not produce results from a query.

ACTUAL BEHAVIOR
---------------

When a user who is setup as English runs a report with date parameters, the report returns results. When that same user changes their language to a different language (i.e. Brazilian Portuguese), there are no results. I believe this is due to the name of the month being passed in differently than what the compiler is expecting. Example would be for December, the date could be 01-DEC-2014. But in Portuguese it is 01-DEZ-2014.


EXPECTED BEHAVIOR
-----------------------
Data should be returned no matter what the language of the user

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created a data set with following query:
select * from PER_ALL_PEOPLE_F
where creation_date > :start_date
order by creation_date desc

2. Defined start_date as date parameter (dd-MMM-yyyy). format

Logged into English and run the report based on above query.
start_date = 07-Jan-2015

Records are returned.
Logged out and log back in with Language = Portuguese (Brazil)
Ran the same report with same start_date. No data found.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Because date formats are different between regions, it can be confusing to users to understand the format of the date.

1/12/2014 - This could be January 12, 2014 in the US, but it could mean Decebmer 1, 2014 to someone in Brazil.

Changes

No changes have been made to the environment.

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