Skip to main content

I’m working on creating custom reports in IFS Applications and have encountered some issues with data discrepancies. Specifically:

  • Data Mismatch: The data displayed in my custom report does not align with what is shown in the standard IFS reports.
  • Filter Settings: I’ve double-checked my filter settings, but the discrepancies persist.
  • Data Source: I suspect the issue might be related to how the data sources are configured or updated.

Has anyone experienced similar issues or can provide guidance on how to troubleshoot data discrepancies in custom reports? Any tips on common pitfalls or best practices for ensuring data accuracy would be greatly appreciated.

Thank you in advance for your help!

Could this be an issue with user account access permissions?

The account your using to develop your report might have access to all group companies, sites etc. while the user testing the report might be limited to only specific companies or sites?

Also, some IFS data can only be viewed by users who are specified within applicable basic data lists (I think that's true of GL vouchers and posting proposals for example).

If that's not the issue, could you give more details on your report, and the IFS standard report your comparing it to?

 

  • Robin

Hi,
did you came across the idea exporting “raw” data from ORACLE into a MS SQL DWH and
make your own reports (or even MS cubes) there?

We documented tons of ORACLE - Views (found in the system info) below IFS masks and learned that IFS uses different Views (based on same tables) for different masks.

So it all depends to what you want to see/show.

By the way I agree with Robin: most of the views have the following part at the end:
AND    EXISTS (SELECT 1 FROM user_allowed_site_pub WHERE col.contract = site)

All the best

Michael

 

Reply


Terms & ConditionsCookie settings