Hi,
When loading multi period load when data is in this format:
Account,CostCenter,Employee,Entity,Job,Location,Property,Version,BegBal-19,1/1/2019,2/1/2019,3/1/2019,4/1/2019,5/1/2019,6/1/2019,7/1/2019,8/1/2019,9/1/2019,10/1/2019,11/1/2019,12/1/2019,BegBal-20,1/1/2020,2/1/2020,3/1/2020
OWP_Basic Salary,96510,8672,1,HR Training & Development Dir,0,OWP_Value,OEP_Working,,90738.34,90738.34,90738.34,90738.34,90738.34,90738.34,90738.34,90738.34,90738.34,90738.34,90738.34,90738.34,,90738.34,90738.34,90738.34
Is there any 'magic' that needs to happen. I have read JG's blog, but it's for a load where it's a single column of data and Period and Year are moved to the rows. Is there any blog etc. out there that explains how to get this file format to load?
Currently right when we try the Import step it fails instantly:
2019-02-26 17:00:17,131 INFO [AIF]: FDMEE Process: 802, Log Level: 4
2019-02-26 17:00:17,131 INFO [AIF]: Location : WFP (Partitionkey:32)
2019-02-26 17:00:17,131 INFO [AIF]: Period Name : Jan-18 (Period Key:1/31/18 12:00 AM)
2019-02-26 17:00:17,131 INFO [AIF]: Category Name: OEP_Forecast (Category key:2)
2019-02-26 17:00:17,131 INFO [AIF]: Rule Name : OEP_Forecast (Rule ID:65)
2019-02-26 17:00:20,430 INFO [AIF]: FDM Version: 11.1.2.4.230
2019-02-26 17:00:20,430 INFO [AIF]: Log File Encoding: UTF-8
2019-02-26 17:00:21,685 INFO [AIF]: -------START IMPORT STEP-------
2019-02-26 17:00:22,249 INFO [AIF]: File Name: Test_Labor_Laod_2_26_2019Jan-18.csv
2019-02-26 17:00:22,561 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::802;32:2:65:[NONE]:/u03/inbox/:MULTIPER
2019-02-26 17:00:22,573 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2019-02-26 17:00:22,573 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2019-02-26 17:00:22,722 ERROR [AIF]: Error opening file.
2019-02-26 17:00:22,798 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2019-02-26 17:00:22,798 INFO [AIF]: EPMFDM-140274:Message - File Name Test_Labor_Laod_2_26_2019Jan-18.csv
periodKey2018-01-31
2019-02-26 17:00:22,804 ERROR [AIF]: EPMFDM-140274:Message - null
2019-02-26 17:00:22,812 ERROR [AIF]: Unexpected error: <type 'java.lang.RuntimeException'>
java.lang.RuntimeException
2019-02-26 17:00:22,813 FATAL [AIF]: Error in FileData.importData
Traceback (most recent call last):
File "<string>", line 96, in importData
RuntimeException: java.lang.RuntimeException
2019-02-26 17:00:22,939 FATAL [AIF]: Error in File Import Data
2019-02-26 17:00:22,947 INFO [AIF]: FDMEE Process End, Process ID: 802
On the 'Data Load Rule' setup. The 'File Name Suffix Type' is grayed out but it's populated with 'Period Name' value. Do I have to use that or should that be blank and I'm stuck and have to create a new Data Load Rule?
Anyways, appreciate any insight, the Oracle documentation is fricking terrible and can't find a real blog on how to do this.
Thanks!!!