Web ADI Error: An error has occurred while running an API import. No return type specified in PL/SQL parameter list 222:MWANIFARET6_PLS attribute 3

Web ADI Error:

·         Out of he 1row(s) successfully uploaded to the staging tables, 1 row(s) failed validation.

·         An error has occurred while running an API import. No return type specified in PL/SQL parameter list 222:MWANIFARET6_PLS attribute 3

\

Please check you defined integrator definition by using this script.

Script:

select *from BNE_ATTRIBUTES where ATTRIBUTE_CODE like '%MWANIFARET6_XA1%';

If you check Attrubite1=’Function’ , In our package we have defined procedure not function.

Required to update the Attribute1='PROCEDURE' and Attribute4=NULL

Script:

update BNE_ATTRIBUTES

set attribute1 = 'PROCEDURE', attribute4 = null 

where application_id = 222 and attribute_code like 'MWANIFARET6_XA1';

Now restart the system and use Web ADI template again. Issue will be Resolved.