My Oracle Support Banner

Error While Opening Retail Invoice Matching (ReIM) Invoice Report (Doc ID 2284703.1)

Last updated on JULY 15, 2017

Applies to:

Oracle Retail Invoice Matching - Version 15.0.1 and later
Information in this document applies to any platform.


When trying to open Reim invoice report from BIP but its throwing below error:

Steps To Recreate:
1. Log into Reim BI Publisher reports section.
2. Try to open "invreport".
3. Enter the invoice id and click on Apply.
4. Following error is shown:

oracle.xdo.servlet.ReportException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00904: "INV"."INVOICE_QTY": invalid identifier


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.