Description

When generating file names dynamically using date expressions (https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG220), like Employee_%y%m%d%H%M%S.xls by default it takes UTC time zone.  

Example when an interface is ran at 2019-10-21 5:13:27 PM PST, the output file name is  Employee_20191022001327.xls (which is in UTC time zone.) rather than Employee_20191021051327.xls

Use Case and Business Need

Current work around is to use bursting query. But it would be much easier if the user time zone(which is defined under BI Time zone under 'My Account') is considered rather than default UTC while using date expressions. 

Original Idea Number: 8938f84612