I'm doing a Currency Translation on the Finance Application, and right now this issue came up,
When Executing from Data Manager the Package FX Restatement , it failed and gave me this error:
Logic Executed:
AdminApp\FINANCE\FXTrans.lgx
Executing SPRUNCONVERSION 'FINANCE','ACTUAL','','GLOBAL','%SCOPETABLE','SPLOG_962476'
SPRunConversion Version 7.0.116
ERROR FX-070 No Entity available in your Application
The Script Logic File is FXTRANS.LGF
//=============================================
// Currency translation logic
//=============================================
*INCLUDE SYSTEM_CONSTANTS.LGL
*SYSLIB SYSTEM_LIBRARY.LGL
//*XDIM_MAXMEMBERS TIMEDIM=12 // if you experience memory problems try adjusting this setting to 6 or less (and remove the leading backslashes)
//*SYSLIB MULTICURRENCYTRANS.LGL
*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','%CATEGORY_SET%','','GLOBAL','%SCOPETABLE','%LOGTABLE%')
//Culmulative Translation Adjustment (CTA)-(Edit for your accounts)
//TRANSLATE_LDI( CYNI, FXCYNI, AVG, END )
// Balance Sheet Historical Amts Overrides-(Edit for your accounts)
//FX_OVERRIDE( OD_CommonStock, CommonStock, FXDiff, USD )
//FX_OVERRIDE( OD_PreferredStock, PreferredStock, FXDiff, USD )
//FX_OVERRIDE( OD_APIC, APIC, FXDiff, USD )
//FX_OVERRIDE( OD_RetainedEarn, RetainedEarn, FXDiff, USD )
//FX_OVERRIDE( OE_CommonStock, CommonStock, FXDiff, EURO )
//FX_OVERRIDE( OE_PreferredStock, PreferredStock, FXDiff, EURO )
//FX_OVERRIDE( OE_APIC, APIC, FXDiff, EURO )
//FX_OVERRIDE( OE_RetainedEarn, RetainedEarn, FXDiff, EURO )
*COMMIT
And the Dimensions on the Application Finance are:
Account
Category
DataSrc
Entity
Flow
IntCo
RptCurrency
Time
Also, the System_Constants file on AdminApp\Finance are:
// application constants
//----
*FUNCTION CATEGORYDIM=CATEGORY
*FUNCTION TIMEDIM=TIME
*FUNCTION CURRENCYDIM=RPTCURRENCY
*FUNCTION ENTITYDIM=ENTITY
*FUNCTION ACCOUNTDIM=ACCOUNT
*FUNCTION INTCODIM=INTCO
*FUNCTION DATASRCDIM=DATASRC
*FUNCTION RPTCURRENCYDIM=RPTCURRENCY
*FUNCTION FLOWDIM=FLOW
// This part is needed when a RATE cube
// is associated to the application
// (FX = single or multi currency)
//----
*FUNCTION THISAPP=FINANCE
*FUNCTION RATEAPP=RATE
*FUNCTION RATEENTITYDIM=RATESRC
*FUNCTION RATEACCOUNTDIM=RATE
*FUNCTION INPUTCURRENCYDIM=INPUTCURRENCY
*FUNCTION RATEENTITYMBR=RATEINPUT
*FUNCTION RATESRCCALCMBR=RATECALC
*FUNCTION AVGRATEID=AVG
*FUNCTION ENDRATEID=END
Hope this detail help to diagnose this issue.
Regards,
Rodrigo