Home › Discussions › Questions & Answers › Blitz Report sharing problem

Blitz Report sharing problem

Avatar photoCustomer Questions & Answers 2 replies

Hi,
I shared the standard GL blitz reports to some GL responsibilities, but when I go into those responsibilities, only 1 report is shown by default. When I try to select the LOV to select another report, I get a ‘No records exist here’ error and I cannot select any other reports.
Almost as if the list is empty.
Can you please advise why this might be the case?
Thanks

2 replies

  • Support Enginatics

    Hi,

    We have seen this occasionally, in case the Compile Security did not synchronize the Blitz Report menu entry into the table fnd_compiled_menu_functions.
    Please execute the following query:

    select
    fme.menu_id
    from
    fnd_form_functions fff,
    fnd_menu_entries fme
    where
    fff.function_name=’XXEN_REPORTS’ and
    fff.function_id=fme.function_id and
    (fme.function_id, fme.menu_id) not in (select fcmf.function_id, fcmf.menu_id from fnd_compiled_menu_functions fcmf where fcmf.grant_flag=’Y’);

    If it returns any records, please run the Compile Security concurrent program from the System Administrator responsibility and let us know if it resolves the issue.

    If the Compile Security does not resolve it, please send us the output of the Blitz Report Assignments report, and let’s schedule a call to investigate.

    Regards,

    Andy

  • Avatar photoCustomer

    Hi Andy,

    I’m so sorry, totally my fault, I was in a rush and ran a script to share multiple reports with multiple responsibilities and did not run a commit at the end. The responsibilities simply did not have any reports assigned to it!

    All working fine now after the commit, such a stupid error, apologies for wasting your time!

  • You must be logged in to reply to this post.