Currency Conversion Issue!

[Former Member]

Hi,

We have currency conversion issue. Though the Currency conversion package runs successfully but none of the records are being updated.

we are 7.5 SP5.

FXTRANS Logic -

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %C_CATEGORY_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

OTHER = C_ENTITY=%C_ENTITY_SET%

*ENDRUN_PROGRAM

here is the package log -

LOG BEGIN TIME:2011-02-09 10:26:00

FILE:\ROOT\WEBFOLDERS\TEST_APSHELL\ADMINAPP\CONSOLIDATION\FXTRANS.LGF

USER:ABC/ABCD

APPSET:TEST_APSHELL

APPLICATION:CONSOLIDATION

RUN CURRENCY CONVERSION

0 SUBMITTED, 0 SUCCESS, 0 FAIL.

SCRIPT RUNNING TIME IN TOTAL:0.78 s.

LOG END TIME:2011-02-09 10:26:01

verified the properties of the dimensions setup in Consolidation and Rate application. they seem to be in sync with 'How to Set up Curr Conv doc'

are we missing something?

[Former Member · Accepted solution]

Hi,

This means that the selection for which the currency translation is being run, doesnt have data. Thats the reason you are getting 0 read. Please check the region for which you have data and then run the program for that region.

Hope this helps.

[Former Member · Accepted solution]

Hi,

i have the data in rate application as follows-

Time period range between = 2005 - 2008

Category = Actual

InputCurrency = USD,EUR,AED,INR and so on..!!

R_Entity = Global

when i run the package the Currency Conversion package in Consol application, my selection is -

Category = Actual

Time = 2008.APR (this period exists in date range of rate application, but in Consol application i have data for 2010,2011)

RptCurrency = USD

Entity = 5000 (value selected from the existing entity value)

this is how im running the package and the data i have in Rate and Consol application.

Any expert advise/inputs? missing something ?

[Former Member · Accepted solution]

Hi,

The problem is you are specifying the time as 2008. However, in your consol application, you have data only for 2010 and 2011. You need to specify the time as 2010 or 2011. Moreover, you should have the conversion rates pertaining to these times available in your rate application.

When you specify the time, it fetches the data from the main application for that time and applies the conversion factor from the rate application also of the same time.

Hope this helps.

[former_member561916]

Hi BPC Gurus,

I too have the same issue.

We are in the process of upgrading BPC7.5NW to BPC10.0 NW.

1) I am validating the below Currency Conversion script in BPC10.0:-

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

CURRENCY = %RPTCURR_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

OTHER = [ENTITY = %COMPANY_SET%]

*ENDRUN_PROGRAM

The data manager package runs w/o any errors, but log says:-

LOG BEGIN TIME:2013-02-26 20:36:16

FILE:\ROOT\WEBFOLDERS\XXXXX\ADMINAPP\LEGAL_CON\FXTRANS.LGF

USER:JXXXX

APPSET:XXXXX

APPLICATION:LEGAL_CON

RUN CURRENCY CONVERSION

0  SUBMITTED, 0  SUCCESS, 0  FAIL.

SCRIPT RUNNING TIME IN TOTAL:1.16 s.

LOG END TIME:2013-02-26 20:36:18

2) When tested in UJKT in BW I have the below error LOG:

UJK_VALIDATION_EXCEPTION:Dimension set:"CATEGORY" not assigned in Data Manager

3) Model is of consolidation type with dummy(no data) Ownership model.

4) Below is screen shot of my Currency Translation rules post upgrade in BPC10.0NW.

Any clue why currency conversion is not picking any records??

Thanks in advance for your earliest help.

GMR

[former_member209721]

Yes, I agree, please provide more info about your master data and Business rules custo

Did you follow note SAP Note 1254330 - Precondition for running currency translation ?

[Former Member]

Hi,

Thanks for all your responses.

No rocket science, all it matters in the way you set the properties in respective dimensions in your application.

Its working now.

Unfortunatley, system does not prompt you with a message that something is missing hence your currency conversion isn't working as expected. If only system prompts/alerts the bpc user then lot of time is saved without having to debug the Curr conv code to figure out the reason for failure.

hope it improves in future versions.

Thanks.

[Former Member]

Hello,

Maybe the error is that you must to introduce data in LC RPTCURRENCY member normally, to make conversion works.

If you intriduce in USD value, you maust define formula "AS_IS" to conversion works.

I hope this help you

Kind regards,

Gabriel Garcí