Exception Creating Order in MetaSolv Solution Using Custom XML API Application (JPD); javax.ejb.EJBException: SQLException on insert: java.sql.SQLException: ORA-00942: table or view does not exist

(Doc ID 1075956.1)

Last updated on NOVEMBER 22, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.16 and later
Information in this document applies to any platform.
*** Checked for relevance on 13-Jan-2015 ***
*** Currency Checked on 23-Nov-2017 ***

Goal

The exception below was observed in the PRODUCTION server's ${SERVER}.mss.log while attempting to create an order in MetaSolv Solution via integration of a 3rd party upstream ordering system using custom jpd.  The XML API application jpd worked in the DEV environment, but failed after migrating it to PRODUCTION.  How can it be resolved? 

 

Solution

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