Skip to Content
avatar image
Former Member

No data for currency translation generated in RTC

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Jan 17 at 01:41 PM

    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

    Add comment
    10|10000 characters needed 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

  • Jan 17 at 05:08 PM

    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

    Add comment
    10|10000 characters needed 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

  • Jan 23 at 03:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jan 25 at 05:43 PM

    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

    Add comment
    10|10000 characters needed 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)
  • Feb 01 at 05:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01 at 05:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 11 at 05:08 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 16 at 01:35 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded