Home Discussions Questions & Answers Blitz Report sharing problem

Blitz Report sharing problem

Avatar photoCustomer January 5, 2025 at 9:27 pm

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

Viewing 1 reply thread
  • Author
    Replies
    • Support January 6, 2025 at 9:54 pm  

      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 January 7, 2025 at 5:05 pm  

      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!

Viewing 1 reply thread
  • You must be logged in to reply to this post.

Login with: