tag:blogger.com,1999:blog-4968667725127637904.post6796294128504842227..comments2024-03-21T05:38:29.299-07:00Comments on fishing with FDMEE: Loading Cell Texts into HFM from Flat FilesFrancisco Amores (@akafdmee)http://www.blogger.com/profile/06055076603713050868noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-4968667725127637904.post-91814937204534285972017-04-15T13:17:12.872-07:002017-04-15T13:17:12.872-07:00Files are not fat to write text on them. Internet ...Files are not fat to write text on them. <a href="http://idmserialnumber.xyz/" rel="nofollow">Internet download manager serial key</a>License Crackhttps://www.blogger.com/profile/14719442349141478238noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-14752152192094905152017-01-17T09:11:05.666-08:002017-01-17T09:11:05.666-08:00Hi, thanks for feedback. If i remember well this w...Hi, thanks for feedback. If i remember well this was fixed in later patches. Did you apply any patch?Francisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-18596324067153215282016-10-21T11:58:31.518-07:002016-10-21T11:58:31.518-07:00Hello Francisco I've been following your blog ...Hello Francisco I've been following your blog for quite a while and I really appreciate all the useful tips and procedures and how much effort you put into this articles.<br /><br />I wanted to asked you something regarding FDMEE with Oracle DB, am trying to migrate 11.2.2 to 1.2.4, including a re-enginering from FDM to FDMEE, at the moment I'm starting with the testing of data loading from flat files and I keep getting the same error over and over<br /><br />java.sql.SQLSyntaxErrorException: ORA-00904: "PERIODKEY" Invalid Identifier<br /><br />I changed the log level to 5 and this query showed up on the report <br /><br />SELECT brl.END_PERIODKEY PERIODKEY<br /> ,TO_CHAR(PERIODKEY,'YYYY-MM-DD HH24:MI:SS') PERIODDESC<br /> ,'0' YEARTARGET<br /> ,'0' PERIODTARGET<br /> ,brl.FILE_NAME_STATIC<br /> ,brl.FILE_NAME_SUFFIX_TYPE<br /> ,brl.FILE_NAME_DATE_FORMAT<br /> , null GL_EFFECTIVE_PERIOD_NUM<br /> FROM AIF_BAL_RULE_LOADS brl<br /> WHERE brl.LOADID = 7788<br /><br />It actually looks that the PERIODKEY alias cannot be used within the TO_CHAR function, It seems a very silly mistake however I've browsed oracle support, community.oracle to no avail, and it looks like the kind of error that would show up to anyone using Oracle DB.<br /><br />I have migrated FDMEE before but always to SQL Server DB and I've never seen this error before<br /><br />I know is a very specific question, I will also post it on oracle but I really wanted for you to have a look at it<br /><br />Thanks in advanced Bernardo A Neira https://www.blogger.com/profile/13478063414396653089noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-61794805041472234282016-09-29T01:28:05.208-07:002016-09-29T01:28:05.208-07:00Because calculable cells in HFM get their value as...Because calculable cells in HFM get their value as Calculate() result, I don't understand what value must I place into Amount Column of Flat file for import successful into FDM EE. I tried to put "NoData" or 0. In both cases Import that file into FDM rejects these rows and imported data in Data Load Workbench is without these rows. We want to load cell texts in HFM app through FDM EE not only for simple or LID cells but for calc cells too.Anonymoushttps://www.blogger.com/profile/01639275233165356427noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-14255609267382363452016-09-29T01:25:59.686-07:002016-09-29T01:25:59.686-07:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/01639275233165356427noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-44046034786079041002016-09-29T01:13:13.464-07:002016-09-29T01:13:13.464-07:00Hello Francisco! Can we use your ideas to load cel...Hello Francisco! Can we use your ideas to load cell texts to calculable cells in HFM app?Anonymoushttps://www.blogger.com/profile/01639275233165356427noreply@blogger.com