BOM Xploder - "ORA-00942 table or view does not exist" for non-SYSADM users

If you refresh BOM Xploder with your connection configured to an Oracle Visual database for a user other than SYSADM, you may receive the following error:

There are two steps required to fix this. First, make sure that BOM Xploder is updated to at least v1000.1102, which fully qualifies the schema for the PART_SITE_VIEW view in the Visual database.

Second, you will need to grant SELECT permissions to the user for the view. That can be done by running this SQL command: GRANT SELECT ON PART_SITE_VIEW TO PUBLIC

The first command grants SELECT permission for PART_SITE_VIEW to all users in the database, which is typically recommended. However, if you only want to grant certain users permission, replace PUBLIC with the user's name in the database.

Once the version is up to date and the permission is granted, users should be able to run BOM Xploder without issue.

• Related Articles

• SmartViews - Error “The specified table does not exist [sv_Users]” - Azure Cloud Database

  Depending on the version of SmartViews a customer is on, they may experience this error after updating to later versions: “The specified table does not exist [sv_Users]” The following steps should be tried in order to solve the issue. Try logging in ...

• BOMXploder - Installation and Guide

  Client Setup The details below will step you through installing Synergy’s BOM Xploder application locally on your clients PC or Terminal Server. The setup whether for PC or a Terminal Server is the same. Prerequisites:  .Net 4.5 Framework, Visual Mfg ...

• Bom Xploder Network Requirements

• SmartViews Error “The specified table does not exist [sv_Users]” - On Premise Installations

  SmartViews has an "On Premise" type of installation that allows customers to use a local SQL Server instead of the Azure cloud database.   Depending on the version they are on, they may experience this error after updating to later versions: “The ...

• "The LicenseCode property is null or empty"

  Customers may try using an out-of-date installer and get the following error: For BOM Xploder, an updated installer can be downloaded at the following URL: https://svc.synergyresources.net/Uploads/SDSProducts/TrialKit/Setup/BOMXploderSetup.exe