Service Attributes: Error Calling PIM Procedure EGO_USER_ATTRS_DATA_PUB after SOA Upgrade to 12c
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.
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.
. Note 1908829.1: Oracle E-Business Suite Integrated SOA Gateway Release Notes for Release 12.2.4
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.
MSG-1 :: API Programming Error: Process SR Extensible Attributes API failure.
Data_level_name = GENERIC_LEVEL
Failed Get_Data_Level_Id-ORA-01403: no data found
ORA-06553: PLS-103: Encountered the symbol "IS" when expecting one of the following:
Upgrade to 12c.
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