Service Attributes: Error Calling PIM Procedure EGO_USER_ATTRS_DATA_PUB after SOA Upgrade to 12c

(Doc ID 2039159.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

It is possible to call CS_SERVICEREQUEST_PUB.create_servicerequest (Integrated SOA Gateway) for populating Extensible Attributes.
Extensible Attributes are available as a Public API since R12, so it can be converted to a Web Service using Integration Repository (iRep).

The Procedure/Function: Process SR Extensible Attributes (PROCESS_SR_EXT_ATTRS) is currently available in the Integration Repository responsibility.

References:
. Note 1908829.1: Oracle E-Business Suite Integrated SOA Gateway Release Notes for Release 12.2.4
. https://docs.oracle.com/cd/E26401_01/doc.122/e20925/T511175T511177.htm

 

After upgrading from 10g to 12c, BPEL calling a procedure on E-Business Suite (EBS) to delete rows in an Extensible Attribute group is not working anymore.
The error occurs in the API for deleting the Extensible Attribute row.

When tracing the API it seems that the error occurs for Package EGO_USER_ATTRS_DATA_PUB when retrieving a row from table EGO_DATA_LEVEL_B.
The issue is regarding using PL/SQL procedure to Access Data for User-Defined Attributes in EBS tables, nevertheless if it's performed using BPEL or other PLSQL client. The issue can be reproduced also using PLSQL client outside BPEL.

Error:

MSG-1 :: API Programming Error: Process SR Extensible Attributes API failure.

Package EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data

Data_level_name  = GENERIC_LEVEL

Failed Get_Data_Level_Id-ORA-01403: no data found
ORA-06553: PLS-:
ORA-06553: PLS-:
...
ORA-06553: PLS-:
ORA-06553: PLS-103: Encountered the symbol "IS" when expecting one of the following:

Changes

 Upgrade to 12c.

Cause

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