Unable To View Tables From MERCH_READ_ONLY/MERCH_READ_WRITE Workspaces In Apex Data Viewer
(Doc ID 2884521.1)
Last updated on JULY 27, 2022
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