My Oracle Support Banner

ISG_SERVICE_EXECUTION_ERROR When Executing Process Order API Webservice To Load Sales Orders In EBS (Doc ID 2585719.1)

Last updated on MAY 06, 2024

Applies to:

Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.

Goal

Customer is trying to integrate Oracle ERP Cloud and EBS using web services for the first time.
They want to use EBS Adapter's Process Order API to load Sales Order from OIC (Oracle Integration Cloud) to EBS.

OIC – Oracle Integration Cloud is a cloud based Integration tool. It seamlessly integrates on-prem applications with Oracle Cloud (SaaS) or other Cloud Apps to other Cloud Apps.


When invoking Process Order REST webservice, the tables are not updated
They tested with other API FND_USER_PKG and it worked fine.

Error message while running the Process Order API:

Error while trying to prepare and execute the APPS. ISG_OE_ORDER_PUB_PROCESS_ORDER. OE_ORDER_PUB$PROCESS_ORDER API.
An error occurred while preparing and executing the APPS. ISG_OE_ORDER_PUB_PROCESS_ORDER. OE_ORDER_PUB$PROCESS_ORDER API. Cause: java.sql.SQLException: ORA-06531: Reference to uninitialized collection
ORA-06512: at "APPS.ISG_OE_ORDER_PUB_PROCESS_ORDER", line 649
ORA-06512: at "APPS.ISG_OE_ORDER_PUB_PROCESS_ORDER", line 5287
ORA-06512: at line 1

Solution

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
Goal
Solution


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