cancel
Showing results for 
Search instead for 
Did you mean: 

Error While Sending Data for Currency Translation

Former Member
0 Kudos


Hello Experts,

I am trying to send data via template. Data is getting saved but I am getting following error displayed.

1.) When I try to enter data for a particular month then, error as FX-200.

2.) When I try to enter data accross months of more than year then , FX-045 and FX-310 error.

I had look on various SAP Notes available for the errors.

As per them, I ran Full optimization, I checked rates are maintained for previous year too, I checked for LC Currency Type Property is maintained as L.

But nothing Worked.

Currently only the 3 members are maintained in Rate Dimension, so exceeding the size limit cannot be an issue.

Kindly Suggest, what could be another possible reason for the errors.

Regards,

Apoorva Garg

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

FX-200 usually means that the system cannot find any rates. You could check that your script references the correct rate entity.

BR,
Arnold

Former Member
0 Kudos

Yes, I checked that.

It is referencing to Correct Entity- GLOBAL

Actually we are doing Currecny Translation via Bsiness Rule,

so we called standard SPRUNCONVERSION Business Rule in Default Logic where RateEntity referenced is GLOBAL and we have data maintained for the same.

Regards,

Apoorva

Former Member
0 Kudos

Hi,

could you attach your default logic.

BR,
Arnold

Former Member
0 Kudos

Hello,

The following is the Default Logic Maintained:

// Default base level logic - applies to all base members in all dimensions

*INCLUDE system_constants.lgl

//Process_Each_Member = TIME

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','KPI_Working_Act_FX','','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

*COMMIT

Regards,

Apoorva

Former Member
0 Kudos

Hi,

into which currencies do you want to convert your data?

Have you tried to just convert to one currency by specifying it? See example below which should convert to USD.

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','KPI_Working_Act_FX','USD','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

BR,

Arnold

Former Member
0 Kudos

Hi,

The Reporting Currency is "USD".

I tried what suggested by you, it too didn't resolve the issue.

Regards,

Apoorva

Former Member
0 Kudos

Hi,

could you post:

a) a screenshot of the rates you have in the system for the period in question

b) a screenhot of the fx business rule(s) that should be applied

BR,
Arnold

Former Member
0 Kudos

Hello,

1.)  I am getting issues  for example for 2010.Mar, 2010.Dec, 2013.Dec, 2012.Dec

2.)  Business Rules Maintained

3.) Business Rule called via Default Script Logic

 

// Default base level logic - applies to all base members in all dimensions

*INCLUDE system_constants.lgl

//Process_Each_Member = TIME

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','KPI_Working_Act_FX','','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

*COMMIT

//*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','KPI_Working_AOP_FX','','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

//*COMMIT

Regards,

Apoorva

former_member186498
Active Contributor
0 Kudos

Hi Apoorva,

it seems you want to use AVG, so please verify that the account dim has AVG as ratetype and in your used rate dimension (AVG) that the property ratetype contains "FX".

Regards

     Roberto

Former Member
0 Kudos

Hello Roberto,

We are using three rate types: AVG, END and 1TO1
and account dimension has rate type maintained as AVG for some accounts and We do have  FX maintained in RateType property.

Regards,

Apoorva

former_member186498
Active Contributor
0 Kudos

Hi Apoorva,

which version and sp are you using?

Can you please share your time dimension?

Regards

     Roberto

Former Member
0 Kudos

Hi,

the screenshot shows data for rate AVG, do you also have rates for END in your system?

BR,
Arnold

Former Member
0 Kudos

Hi,

Yes we do have maintained.

Regards,

Apoorva

Former Member
0 Kudos

We are on BPC MS 7.0 SP 5.0.

Former Member
0 Kudos

Hi,

is your application YTD or periodic?

BR,

Arnold

Former Member
0 Kudos

Hello,

Could you please guide me to how to get that information -whether application is YTD or Peridic for BPC MS 7.0?

Thanks in Advance!!

Regards,

Apoorva

Former Member
0 Kudos

Hi,

In the web interface go to the admin section and then to the application parameters. There should be a parameter called YTDINPUT which is either set to Y or N.

BR,
Arnold

Former Member
0 Kudos

Hello,

Thanks..

Application is Periodic.

Regards,

Apoorva

Former Member
0 Kudos

Hi,

could you try to untick the option "apply to periodic" in your business rule.

BR,
Arnold