My Oracle Support Banner

Complex PLSQL Webservices Not Working Post Upgrade fails with error "no data found " at APPS.ISG_BPEL_CTX_PKG (Doc ID 2881033.1)

Last updated on JANUARY 13, 2024

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.10 and later
Information in this document applies to any platform.
Before Upgrade:
DB: 12.1.0.2 RAC on 2 Exadata nodes
EBS: 12.2.4 on 1 Linux node
SOA SUITE: 11.1.1.7 on 1 Linux node

After Upgrade:
DB: 19.13 RAC on 2 Exadata nodes
EBS: 12.2.10 on 1 Linux node
SOA SUITE: 12.2.1.4 on 1 Linux node

Issue with only complex plsql based SOAP webservices

Symptoms

On : 12.2.10 version, Installation Issues

When attempting to test  complex API webservice
the following error occurs in soapui
ERROR
-----------------------




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Login to SOAPUI
2.Correct XML data
3.Test SOAP Webservice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot consume SOAP webservice

Changes

 Database,E-business suite and SOA suite Upgrade

Cause

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
Symptoms
Changes
Cause
Solution
References


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