Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RTD/RTS tables HFM database after migration have non unique ID's

2956788May 24 2015 — edited May 25 2015

Hi HFM Experts,

When the HFM application was upgreaded from version 9.3 to 11.1.2.3, the RTD and RTS tables have non unique ID's Which failed to load HFM application, hence the non unique ID's rows had to be deleted from these tables as per KB Doc '"Cannot insert duplicate key row in object 'dbo.ApplicationName_RTD_2_2010' with unique index" When Running Schema Upgrade. (Doc ID 1566998.1)'

however, I want to understand the significance of these Tables in HFM, to identify the impact they might have on the upgraded App. because, as per the explanation in KB doc, these tables are generated or updated by HFM upon consolidation, however when i did consolidation, i do not see the respective RTD or RTS table updated.

Thanks & Regards,

J mishra

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2015

Added on May 24 2015

#business-intelligence-applications, #financial-consolidation, #performance-management-applications

1 comment

999 views