Date Format Got Changed After Applying The Patch FDMEE .210 (Doc ID 2287592.1)

Last updated on AUGUST 08, 2017

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.210 and later
Information in this document applies to any platform.

Symptoms

Version: 11.1.2.4.210, FDMEE

Date format in SQL got changed after applying the .210 patch. Earlier it was like YYYY-MM-DD but now it is DD-MMM-YY

Blank page appearing when doing drill through from HFM data grid even though there is data in the selected intersection.

Below is the drill through log:
2017-06-06 07:42:17,458 INFO [AIF]: attribute[0] = system.ds.hfm
2017-06-06 07:42:17,458 INFO [AIF]: attribute[1] = app.ds.TCHS2TXU
2017-06-06 07:42:17,458 INFO [AIF]: attribute[2] = cluster.ds.TCHFMQ
2017-06-06 07:42:17,459 INFO [AIF]: attribute[3] = Scenario.id.Actual
2017-06-06 07:42:17,459 INFO [AIF]: attribute[4] = Year.id.2016
2017-06-06 07:42:17,459 INFO [AIF]: attribute[5] = View.id.<Scenario View>
2017-06-06 07:42:17,459 INFO [AIF]: attribute[6] = Value.id.<Entity Currency>
2017-06-06 07:42:17,459 INFO [AIF]: attribute[7] = ICP.id.[ICP None]
2017-06-06 07:42:17,459 INFO [AIF]: attribute[8] = Reporting.id.RP_GL026
2017-06-06 07:42:17,459 INFO [AIF]: attribute[9] = Function.id.FN_000
2017-06-06 07:42:17,460 INFO [AIF]: attribute[10] = Geography.id.GO_000
2017-06-06 07:42:17,460 INFO [AIF]: attribute[11] = SuppDetail.id.SD_TBload
2017-06-06 07:42:17,460 INFO [AIF]: attribute[12] = BusinessUnit.id.BU_HLTHCR
2017-06-06 07:42:17,460 INFO [AIF]: attribute[13] = BookType.id.BT_P
2017-06-06 07:42:17,460 INFO [AIF]: attribute[14] = Account.id.AC_5250201102
2017-06-06 07:42:17,460 INFO [AIF]: attribute[15] = Entity.id.LE_MS0171.LB_5807
2017-06-06 07:42:17,461 INFO [AIF]: attribute[16] = Period.id.AP12
2017-06-06 07:42:17,461 INFO [AIF]: Application Name:TCHS2TXU
2017-06-06 07:42:17,461 INFO [AIF]: Target Application Type:HFM
2017-06-06 07:42:17,464 INFO [AIF]: ERPI Target Application Name:TCHS2TXU
2017-06-06 07:42:19,072 INFO [AIF]: Year Target:2016
2017-06-06 07:42:19,072 INFO [AIF]: Period Target:AP12
2017-06-06 07:42:19,084 INFO [AIF]: SELECT PARAMS:[281, 280, 279, 278, 277, 276, 275, 274, 273, 272, 271, 270, 269, 268, 267, 266, 299,



Changes

There was a change in the way period key is stored in the parameters table.

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