My Oracle Support Banner

Unable To View Tables From MERCH_READ_ONLY/MERCH_READ_WRITE Workspaces In Apex Data Viewer (Doc ID 2884521.1)

Last updated on MARCH 20, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.


Unable to query/view tables such as item_loc and item_loc_soh from MERCH_READ_ONLY/MERCH_READ_WRITE workspaces in Apex data viewer. This is happening only for some of the tables.

1. Login to environment and go to data viewer.
2. Select the "MERCH_READ_WRITE" workspace.
3. Query the below:

select * from item_loc_soh;
select * from item_loc;

4. In both the above mentioned queries, below error is seen:

ORA-00942: table or view does not exist

5. The same error is seen even under "MERCH_READ_ONLY" workspace.


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.