AR Open Items Revaluation issue

Hello,

Apologies, I was reviewing the change history for this report, and the reason we unlinked from the XML Publisher is that we have clients that want to be able to run the report across multiple Operating Units. If it is linked to the XML Publisher Report (which is OU specific) then the OU context is restricted to a single OU.

So with that in mind I took another look at the query and there is indeed a missing join that meant transactions that use a transaction type which is common across the accessible OUs within the responsibility would be repeated for each accessible OU.

The same join is missing in the standard code, but as the standard report runs within the context of a single OU, it is not an issue,

I have fixed the underlying issue, and retained the ability for the Blitz Report to be run across multiple Operating Units.

Please find attached the amended version of the report (also available for download from the Enginatics Library https://www.enginatics.com/reports/ar-open-items-revaluation/).

Hello,

Just to clarify, I see from the install logs we have for you, you are running EBS 12.2.6 and Blitz Report v3.3.0. Is this correct?

From the error screenshot you sent that the LOV is referring to a view ‘XXEN_GL_LEDGERS_V’ which would not exist in your instance as this is only created for clients installing Blitz into an 11i environment. Which means you have some incorrect LOV definitions referring to the 11i views. These are not included in the downloads from our library so I am not sure how they would have been imported into your instance.

Please import the attached report definition. This one contains the LOV definitions for Blitz running in an R12 instance.

Kind Regards,

Eric

Hi Peter,

There was a difference in how the accounted amounts are rounded between the standard oracle report and the Blitz report. This has now been resolved. Please find attached the amended version of the Blitz AR Open Items Revaluation report.