Skip to Content
0

No data for currency translation generated in RTC

Jan 17 at 06:46 AM

272

avatar image
Former Member

Hello All,

We are using S4HANA 1610 FPS00 for RTC

We have followed all the steps in config document for RTC with currency translation integrated with BPC.

Following are the checks we have done on data:

1. Data successfully submitted to FINAL category

2. Auditrail, Scope, RPTCURRENCY, Group GL (RTCGLA), transaction type (RTCTTP) required properties correctly maintained.

3. Business rules maintained as required.

4. Note 2490401 - Customized entity InfoObjects to replace ERP-ECOMP & ERP-ICOMP to solve leading-zero problem in entity mapping.

5. Ownership manager maintained.

6. Currency exchange rates maintained.

7. Note 2460119 for key figure

8. 2495033 - RTC Consolidation Monitor - Rules Are Successfully Executed But No results are Written Back

I am trying to run currency translation using consolidation monitor. The status shows translation successful but we can see no data in composite provider.

My group currency is INR

Please help me what I am missing so that I get the CT results.

Data in CP

Ex-rates

data-in-cp.jpg (73.6 kB)
ex-rates.jpg (28.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

8 Answers

avatar image
Former Member Jan 17 at 01:41 PM
0

Hi Amit,

Does it show up any error in SLG1? What is the error it shows up, when ran through Back end?

Please do multiple level of checks:

First would be to debug or run the rule from back end and observe if it generates any records after data read -

a) GO to SLGI, after triggering the Currency translation from Cons Monitor

b) Check for the UJP sub object and identify the right log. Click on detail in the log and copy it

c) GO to SE38, execute BPC_TASK_SEQ_TEST. Copy the log captured in SLGI and execute

d) Displays the records read and generated

Now, check if the records are written back to the ACDOC/Hana View - CP/ADSO defined for write back

In case of CP/ADSO, BPC SP06/Before needs to be implemented with a Write back planning function

In case of ACDOC, please run the debugging steps in the class "CL_UJXP_MONITOR_EMBEDDED" -> DO POST

Share the screenshots after navigating through the debugging steps, helps to understand the issue better. Hope this will help you find the issue.

Regards,

Harsha

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Harsh,

I tried to step b from your answer.

I am unable to get any logs related to currency translation.

Could you help.

Regards,

Amit

0
Leila Lappin
Jan 17 at 05:08 PM
0

Hello Amit,

If the recommendations by Sri do not help then I would say it is time for deep dive review and analysis of the business rules. Personally, I use the approach of examining business rules individually so that I can have a very precise data region scope to examine the transaction data in the source and destination. This approach focuses if a specific rule is actually finding anything to process.

Best Regards,

Leila Lappin

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Leila,

Thanks for your input.

I actually have just one business rule in place right now so that I can test the process.

I have AVG rate conversion rule with data on P&L account.

Regards,

Amit

0
Leila Lappin
Jan 23 at 03:40 PM
0

Hi,

You are showing data in your CP but I cannot see the currency. Could you add the transactional data with the currency and also please include your CT rule. Thank you

Best Regards,

Leila

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Leila,

I have provided screen shot for CP with currency only. Currency is taken in column (LC). My GC is INR but there is no data for the same.

CT rule is Simple:

1. AVG maintained as RATETYPE for P&L accounts

2. Rule AVG maintained as Source flow 999 and Formula [AVG]

I have also tried creating dimlist for flows assigning END in dimlist for 999 and writing the rule.

Regards,

Amit

0

Hi Amit,

The values in R_ACCOUNT as shown in your rate model do not seem correct. I am assuming "Rate account" is the account dimension in rate model. This is the field that should have acctype in rate model.

Here is the screen print of the values shown on my BPC11 standard. Please note that consolidation engine is the same for both embedded and standard. So the same validations and constraints apply to both modes of BPC

dk02l.png (17.3 kB)
0
Former Member

Hi Leila,

RATEACCOUNT is account type in rate model and all the attributes are maintained as you have mentioned.

I have taken that dimension on column in my input template.

Regards,

Amit

0
avatar image
Former Member Jan 25 at 05:43 PM
0

Hi Amit,

It doesn't tag it as Log:

Rather you would see it in the context Information view (screen shots attached for the view : Ref only). Copy that Xml as mentioned in the above points and paste in the debugger (Execute)

If it doesn't generate this log, you need to revisit the Business rule and Task sequence and check if there is any configuration issue right from master data to the Consolidation monitor

log-for-bpc-consol-rule.jpg

log-for-bpc-consol-rule-2.jpg

log-for-bpc-consol-rule-3.jpg

Thank you

Regards,

Harsha


Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Harsha,

We implemented notes 2492528, 2393020 and 2514586 after which we started getting logs.

We followed the procedure you told us to execute the task sequence from backend and got following error.

Can you guide us way forward.

Regards,

Amit

ct-log1.png (32.1 kB)
ct-log2.png (36.1 kB)
0
avatar image
Former Member Feb 01 at 05:22 PM
0

Hi Amit,

This looks like a bug. Promoting your environment to FPS01 or further versions might resolve this issue. Please review SAP note 2465833

Comments in the note:

  • Sometimes, BPC Consolidation Monitor prompts error messages such as 'Invalid ROLLBACK WORK in an update function module.'. In the transaction code ST22 in back-end, you can find it is related to the class CL_RTC_ACDOCC_IPROV_WRITABLE and method WRITE_DATA, which contains the statement ROLLBACK WORK. The statement triggers a post-transaction operation which prevents the useful messages from displaying in the front-end. Unfortunately, this defect can only be fixed by upgrading to S/4HANA 1610 FPS01 or higher releases/feature package stacks. If this solution is not applicable in your case, you can copy this sample write-back class and customize it by removing the statement 'ROLLBACK WORK', then replace the old class in Virtual Provider Modeling.

Hope this would help you understand the issue.

Regards,

Harsha

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 01 at 05:22 PM
0

Hi Amit,

This looks like a bug. Promoting your environment to FPS01 or further versions might resolve this issue. Please review SAP note 2465833

Comments in the note:

  • Sometimes, BPC Consolidation Monitor prompts error messages such as 'Invalid ROLLBACK WORK in an update function module.'. In the transaction code ST22 in back-end, you can find it is related to the class CL_RTC_ACDOCC_IPROV_WRITABLE and method WRITE_DATA, which contains the statement ROLLBACK WORK. The statement triggers a post-transaction operation which prevents the useful messages from displaying in the front-end. Unfortunately, this defect can only be fixed by upgrading to S/4HANA 1610 FPS01 or higher releases/feature package stacks. If this solution is not applicable in your case, you can copy this sample write-back class and customize it by removing the statement 'ROLLBACK WORK', then replace the old class in Virtual Provider Modeling.

Hope this would help you understand the issue.

Regards,

Harsha

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 11 at 05:08 PM
0

Hi ,

Try to go and activate your model / regenerate hana views and renew posting API from top menu bar ( as it troubled me a lot).

Also make sure you have assigned hierarchy in the model and it is appearing correctly in the business rules.

You have posted data to 999 so make sure that flow is selected. You have assigned Rate type to the accounts which are having data.

Ownership is present for those entities.

Hope that helps.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Rakesh,

Thanks for the inputs. We already tried this.

Amit

0
Lucas Costa Feb 16 at 01:35 AM
0

There can be so many things here... business rules, dimension mapping, hana views, bw...

First I thing I suggest is to apply notes:

2492528 - A trouble-shooting tool for BPC task sequence at backend

2393020 - Improvement of log for embedded consolidation

This will enable you to retrieve proper logs using SLG1. We can know for example, if the transactional data, rates, are being read and filters the system is using.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Dear Lucas,

We have already done that. We posted the results in previous comments.

Regards,

Amit

0

Well, I couldn't find any SLG1 logs.. if you cannot bother posting here no way to help you...

0