My Oracle Support Banner

Error in Oracle SIM - Shelf Replenishment Report (Doc ID 2803666.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Retail Store Inventory Management - Version 16.0.3 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.

Symptoms

While accessing in BIP the ShelfReplenishmentReport, the error is faced:

"oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00904: "RPRT_SHELF_REPLENISH_V", "SELLING_UNIT_OF_MEASURE": invalid identifier."

 

The issue can be reproduced with the following steps:
1. In BI Publisher, navigate to the ShelfReplenishmentReport
2. Notice the error

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.