on 06-14-2011 1:25 PM
Hi ,
I have a situation that currency conversions is not reading any records. Detail log is reading as submitted records , success and failed records all as zero.
I checked all the dimension property required for translations. like rptcurrency ( Y and R ) , Entity ( local currency and also G) ,
ratetype ,datsrc (Y , type as M ) . I did uploaded the rates in application. I have also data in my consolidation application with rpt currency as LC . In my rate application also I did uploaded rates for inputcurrencies also . But still program is not reading any data records.
Can someboody help me where Iam still missing ?
Thanks ,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Madhu,
Could you please do a quick check if you have maintained the rate information also for the currency that your running the translation into.
For example, if you are converting all the data into USD or GBP, please also maintain the rate data against the USD & GBP as 1. Please check if you have already done this. Please make this change and run the Fx Trans and confirm.
Thanks,
Sreeni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sreeni ,
does this maintenance is required for every period ? (Say If I am using monthly closing ) .
My input currency is EUR and Iam converting few groups to USD . In this case shall I maintain two records for EUR
in my rate application ? one for 1:1 and another for say 1 EUR = 0.8 USD ( say ) ?
I maintained all other dim properties as said by Rashmi .
Reagrds
MYL
Hello All ,
Thanks for all your replies I did checked the dimenstion properties and also the rate application maintenance as suggested .
I also did verified according to How to Paper . But could not get result. My UJKT is also giving the same result
like submitted 0 , success 0 fail 0. I am pasting my script logic and constatns below .
I did checkd that legal cube contains data with currency (enitity ) as EURO . RPT currency as LC . and Iam trying to convert to USD . My rate application is also loaded with 1:1 rate for USD and releavent rate types for input currencies which is EUR.
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %C_CATEGORY_SET%
TID_RA = %TIME_SET%
CURRENCY = %RPTCURRENCY_SET%
RATEENTITY = GLOBAL
ENTITY=%ENTITY_SET%
*ENDRUN_PROGRAM
systems constatns ( extract )
============================
/ application constants (Planning Application)
//----
*FUNCTION CATEGORYDIM=C_CATEGORY
*FUNCTION TIMEDIM=TIME
*FUNCTION CURRENCYDIM=RPTCURRENCY
*FUNCTION ENTITYDIM=ENTITY
*FUNCTION ACCOUNTDIM=C_ACCT
*FUNCTION DATASRCDIM=C_DATASRC
*FUNCTION INTCODIM=INTCO
*FUNCTION ACCDETAILDIM=FLOW
*FUNCTION GROUPDIM=CONSGROUP
// This part is needed when a RATE cube
// is associated to the application
// (FX = single or multi currency)
//----
*FUNCTION THISAPP=LEGALAPP //Name of legal consolidation Application
*FUNCTION RATEAPP=RATE //Name of Legal Rate Application
*FUNCTION RATEENTITYDIM=R_ENTITY
*FUNCTION RATEACCOUNTDIM=R_ACCT
*FUNCTION INPUTCURRENCYDIM=INPUTCURRENCY
*FUNCTION RATEENTITYMBR=GLOBAL
*FUNCTION RATESRCCALCMBR=GLOBAL
*FUNCTION AVGRATEID=AVG
*FUNCTION ENDRATEID=END
Please let me know where Iam still missing.
Regards
Madhu,
1. Did you maintain the Business Rule Table for rate type AVG?
2.Check your data in the Rate application, does the USD has the value 1? Given below is the example:
TIME CATEGORY R_ACCT R_ENTITY INPUTCURRENCY SIGNEDDATA
2010.APR PLAN AVG GLOBAL GBP 1.8
2010.APR PLAN AVG GLOBAL EUR 1.72
2010.APR PLAN AVG GLOBAL USD 1
Thanks
Edited by: Rushendra Pemmasani on Jun 20, 2011 3:15 PM
Hi Mahdu:
I can see your script logic is considering the currency type dimension, but, aren´t You using the G type dimension? If this is your case, ps modify your scrit as follow:
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %C_CATEGORY_SET%
GROUP = %GROUP_SET% //This should be replaced with your G type Dimension
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
//ENTITY=%ENTITY_SET% // If you are using Groups currency conversion, entity is not necessary.
*ENDRUN_PROGRAM
Also, please verify, you have entered the OWNERSHIP infomation, otherwise the FX program will return 0 generated records.
Regards,
LDT
Did you use group in your currency conversion? which SP you are using?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
check below -
1. Have you set the CURRENCY on Entity to its respective currency?
Say for INDIA01 entity, the CURRENCY would be INR, for US01 entity Currency would be USD etc.
2. These currencies you would define it in INPUTCURRENCY dimension. In this dimension you need to maintain MD as either (M)ultiply or (D)evide.
3. Category dimension - YEAR, RATE_YEAR, FX_SOURCE_CATEGORY and RATE_CATEGORY to be defined. If left blank, then it would consider the ones from the source itself.
4. RATETYPE must be defined on ACCOUNT dimension for each account for which currency conversion is required.
5. The data for this RATETYPE, CATEGORY, TIME should be there in RATE application
6. CURRENCY CONVERSION business rule to be set up for each RATETYPE.
Hope this helps.
Regards,
Rashmi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.