Client Timezone Profile Is Not Considered At User Level (Doc ID 786693.1)

Last updated on OCTOBER 04, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 10.1.3.2.0 to 11.1.1.6.0 [Release 10.1 to 11.1]
Oracle Application Object Library - Version 12.0.0 to 12.0.4 [Release 12]
Information in this document applies to any platform.

Symptoms

On 12.0.4 in Production:
Reports showing incorrect from/to dates, for example: Italian Purchase VAT Register has been submitted with  period name Sep-09 as parameter. Sep-09 period has dates from 01-Sep-08 to 30-Sep-08 but report shows date from 31-Aug-2008 to 29-Sep-2008
    
EXPECTED BEHAVIOR
 -----------------------
Expect  dates from 01-Sep-08 to 30-Sep-08
    
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run Italian Purchase VAT Register
    
BUSINESS IMPACT
 -----------------------
The issue has the following business impact:
    Cannot print report with correct results

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