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.

Symptoms

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.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00904: "INV"."INVOICE_QTY": invalid identifier
 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms