Issue with Custom Reports in IFS Applications: Data Discrepancies

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