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.
