Hi all,
I am facing issues while writing-back budget data from the PBCS Cloud to the ERP cloud. Data flow from ERP to PBCS is working fine.
I am getting two different errors based on if I choose the Account dimension as 'Accounts' or 'generic' in the target application structure.
Any pointers will help immensely. ERP application has 6 additional dimensions compared to the PBCS application.
Below screen shot has my target Essbase ERP back-end application.
Below is the import format I created :
Below is the global period mapping : ERP and PBCS has different period formats.
Below is the target ERP application period mapping :
I have created the mappings and rules accordingly.
Now the issue is if I take the Accounts dimension in the target application as Accounts and run the rule, I am getting the below error in FDM log : Basically the period isn't picked up in the output file.
---------------------------------
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText="Period Activity Cr":StartPos=1:SourceClName=Amount
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText="GBP":StartPos=1:SourceClName=Currency
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD9:ImpFieldText=Jan-18:StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=300000001869007:StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Company
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=CostCentre
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=1:SourceClName=Division
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD8:ImpFieldText=null:StartPos=1:SourceClName=Intercompany
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,765 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=1:SourceClName=Project
2018-03-10 11:44:19,766 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText="Budget":StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,766 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD11:ImpFieldText="Base":StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,766 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD12:ImpFieldText="Period Activity Cr":StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,766 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD6:ImpFieldText=0:StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,766 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD7:ImpFieldText=0:StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,766 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD14:ImpFieldText="Entered":StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,766 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD13:ImpFieldText="GBP":StartPos=1:SourceClName=Accounts
2018-03-10 11:44:19,767 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2018-03-10 11:44:19,767 INFO [AIF]: EPMFDM-140274:Message - File Name HPLRPT_247.dat
periodKey2018-01-31
2018-03-10 11:44:19,767 INFO [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL
2018-03-10 11:44:19,767 DEBUG [AIF]: BOM exists
2018-03-10 11:44:19,767 DEBUG [AIF]: After removing BOM ["Years","CostCentre","Division","Project","Scenario","Version","Company","Intercompany","Drivers","Accounts","Period"]
2018-03-10 11:44:19,767 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "CostCentre", "Division", "Project", "Scenario", "Version", "Company", "Intercompany", "Drivers", "Accounts", "Period"]
2018-03-10 11:44:19,801 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 247
PARTITIONKEY: 28
IMPORT GROUP: Imp_Bud_WB_Prod
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: HPLRPT_247.dat
PROCESSING CODES:
-----------------------------------------------------------------------------------
BLANK............. Line is blank or empty.
NN................ Non-Numeric, Amount field contains non numeric characters.
TC................ Type Conversion, Amount field could not be converted to a number.
ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.
SKIP FIELD.............. SKIP field value was found
NULL ACCOUNT VALUE.............. Account Field is null
SKIP FROM SCRIPT.............. Skipped through Script
HEADER ROW.............. Header Row
ERROR_INVALID_PERIOD.............. Invalid period specified in the file.
[TC] - [Amount=NN] "FY18","CC614","100","P000","Budget","Working_1","101","00000","No Driver","70152",454
[TC] - [Amount=NN] "FY18","CC615","100","P000","Budget","Working_1","101","00000","No Driver","70151",444
[TC] - [Amount=NN] "FY18","CC617","100","P000","Budget","Working_1","101","00000","No Driver","70154",4545
[TC] - [Amount=NN] "FY18","CC618","100","P000","Budget","Working_1","101","00000","No Driver","70153",454
Rows Loaded: 0
Rows Rejected: 4
Basically it fails in the validate step.
----------------------
If I change the Accounts dimension to Generic and assigned a UD value in the target and make the Ledger as Account type in the target and run the rule, I get the below error :
Releasing Root AM...
Pre Validating Budget Data Started for Run Name: FDM-241
Prevalidating Budget data errored. Error message: There exist multiple ledgers associated with different Chart Of Accounts and Calendar. All ledgers in a single run should be associated with the same Chart Of Accounts and Calendar
Budget data has multiple ledgers but not a common calendar.
--------------------------------------------------------- END: Process Log From the Ess Job ---------------------------------------------------------
The FusionAdapter main program has completed.
INFO: The script FusionCloudAdapter has failed as reported above.
2018-03-10 11:20:57,471 INFO [AIF]: Standard Error: java.lang.Exception: Ess request has completed with errors.
at com.hyperion.aif.fusion.FusionAdapter.pollEssRequestStatus(FusionAdapter.java:658)
at com.hyperion.aif.fusion.FusionAdapter.main(FusionAdapter.java:267)
---------------------------------------------------------
Can anyone kindly help me in this situation? I am struggling with this since a lot of time now. Will really be grateful. Thanks in adavance.
Also one more thing I wanted to share that in the mappings, I have mapped both the data and the balance amount column to 'Period Activity Cr' member in the ERP where I want to write the budget data.
Thanks,
SM