Home > Default > Decimal places lost after Account metadata load via ERP Integrator

Decimal places lost after Account metadata load via ERP Integrator

November 30Hits:0
Advertisement
Hi!
Does anybody faced something like this?
I'm losing my HFM app decimal places after loading Metadata from EPRi > Metadata.
EPM System 11.1.2.0
Oracle EBS 12
Thanks!
-Cheers!

Answers

The issue is that you are mapping "Data Value" to amount in the Target Application import format:
SELECT SCENARIO "Scenario" 
  ,YEAR "Year"
  ,PERIOD "Period"
  ,DATAVIEW "View"
  ,DATAVALUE "Value"
  ,ACCOUNT "Account"
  ,ENTITY "Entity"
  ,ICP "ICP"
    ,UD2 "Area"
    ,UD1 "Tail"
    ,UD3 "Special"
    ,UD4 "Facility"
  ,AMOUNT "DataValue"
  FROM AIF_HS_BALANCES
  WHERE LOADID = 300
You need to map AMOUNT to "AMOUNT" in the HFM Application.  Check that the dimension mapping is correct for the class in the target application and that your import format is going to the proper target dimension(Amount).    

Read other 2 answers

Tags:

Related Articles

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.550 s.