My Oracle Support Banner

Rest API is Also not Working Correctly for PL/SQL Table Output Types (Doc ID 2531412.1)

Last updated on JULY 17, 2022

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Performance

When attempting to invoke a custom service which uses a table type,
the following error occurs.

ERROR
-----------------------
ISG_SERVICE_EXECUTION_ERROR


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Invoke custom service with following payload
{"InputParameters":
{"P_ACCOUNT_NUMBER":"1234",
"P_TRX_NUMBER":"",
"P_FROM_DATE":"",
"P_TO_DATE":"",
"P_TRXN_STATUS":"",
"P_INCLD_TRANX_DET":"Y",
"P_INCL_REL_ACCT":"N"}}

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
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.