Error While Opening Retail Invoice Matching (ReIM) Invoice Report
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.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00904: "INV"."INVOICE_QTY": invalid identifier
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