Integration Failing When Calling EBS Service GET ORDER After EBS Upgrade (Doc ID 2479845.1)

Last updated on APRIL 07, 2023

Applies to:

Symptoms

Our Integration Calls back to EBS OE_ORDER_PUB.GET_ORDER to get order information.  This API is failing with the following error from OAFM Server out After EBS upgrade to 12.2.5:



ERROR
ISG_IREP_ACCESS_ERROR Incorrect Class Id

Exception
 'Error occurred while generating the web service' occurred when
attempting to perform 'generate'. Please view Log/Error details for more
 information
Error encountered in remote
method.oracle.apps.fnd.isg.common.error.ISGException : Error in the
generating PLSQL package oracle.apps.fnd.isg.common.error.ISGException :
 Error in generating function artifacts
oracle.tip.adapter.db.exceptions.DBResourceException : Database type not
 supported. Encountered a database type APPS.OE_ORDER_xxxx that is
either not supported or is not implemented. Parameter
P_HEADER_PAYMENT_TBL is of type APPS.OE_ORDER_xxxxxxxx which is either
not supported or is not an implemented datatype. Check to ensure that
the type of the parameter is one of the supported datatypes or that
there is a collection or user defined type definition representing this
type defined in the database.



STEPS
The issue can be reproduced at will with the following steps:
1. Using Oracle Integration Repository
2. Navigate to Integration Repository in EBS >
Searched for the following:
Internal Name OE_ORDER_PUB
Type PL/SQL
Product Oracle Order Management
Status Active

Go to REST Web Service Tab provide processOrder as the Service Alias >
Select all >
Then Click on Deploy >

Getting the following:
Exception
 'Error occurred while generating the web service' occurred when
attempting to perform 'generate'. Please view Log/Error details for more
 information
Error encountered in remote
method.oracle.apps.fnd.isg.common.error.ISGException : Error in the
generating PLSQL package oracle.apps.fnd.isg.common.error.ISGException :
 Error in generating function artifacts
oracle.tip.adapter.db.exceptions.DBResourceException : Database type not
 supported. Encountered a database type APPS.OE_ORDER_xxxx that is
either not supported or is not implemented. Parameter
P_HEADER_PAYMENT_TBL is of type APPS.OE_ORDER_xxxxxxxx which is either
not supported or is not an implemented datatype. Check to ensure that
the type of the parameter is one of the supported datatypes or that
there is a collection or user defined type definition representing this
type defined in the database.


3. Checked the OE_INBOUND_INT and I do not see the GET_ORDER service available.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.