Skip to main content
Question

IFS Report not showing in Order Reports


Forum|alt.badge.img+3

In Apps9 we have an IFS Report Designer report that shows within the ‘Reporting’ submenu for Financials, but does not show in Order Report.  

We can work around but the user wants it to show in Order Reports.

The report is granted to the correct permission set (hence shown in the Reporting menu), and is a standard IFS report.

Any ideas why it does not show up in Order Report?

9 replies

Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @NRTDENISEL 

Please check the value defined for the show_in_order_reports_ parameter in the report RDF file. It must be defined inside the method call Report_SYS.Define_Report_() and the value must be set toTRUE.

 

 


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • May 19, 2022

Hi,

It is true, but there is an Override which appears to be IFS standard code, so I wonder if there is an issue there - where are Overrides set?


Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @NRTDENISEL 

Was this report showing in Order Reports earlier?

Is it available in Report Definition screen (means Schema and Layout imported)?


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • May 19, 2022

I do not know if it was showing earlier, possibly not.  it is available - I’ve also run it via Report Designer, just not listed in the Order Reports dialogue window


Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @NRTDENISEL 

May I know the report name please? 


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • May 19, 2022

Customer Statement of Account


Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @NRTDENISEL 

Sorry for the delay in replying.

The override comes into play with below option hence should not have an impact to the visibility in Order Report dialog.

With this option application decides which report to be displayed - CUST_STMT_ACCT_REP or CUST_CONF_STMT_ACCT_REP.

However just go through the steps below.

  1. Check whether Report Definitions exist for both CUST_STMT_ACCT_REP and CUST_CONF_STMT_ACCT_REP.
  2. Check permissions of both CUST_STMT_ACCT_REP and CUST_CONF_STMT_ACCT_REP and grant if necessary.
  3. Refresh report cache and security cache then log off and log on again to the application.

Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • May 31, 2022

Hi, thanks but the issue is that the Order Report drop down does not include ‘Customer Statement of Account’ in the list of available reports.


Forum|alt.badge.img+8
  • Do Gooder (Customer)
  • 29 replies
  • April 10, 2024

@NRTDENISEL Hi, we are having a similar issue whenever we do a deployment. A temporary fix for us is to revoke the grant to the report in Permission Sets, and then re-grant it.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings