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

It took me hours to figure this out.

BNE_ATTRIBUTES need to be correctly updated for resolving the same
following are the import attributes.

when i created the importer the attribute1 had a default value of FUNCTION, which had to be updated to a PROCEDURE.

Also Make sure to update the Reference Fields while creating the importer, else you will have to manually update from the database as below.



UPDATE BNE_ATTRIBUTES
   SET ATTRIBUTE1 = 'PROCEDURE'
 WHERE ATTRIBUTE_CODE = 'XXPDH_CST_UPLOAD_INTG_XA1';

UPDATE BNE_ATTRIBUTES
   SET ATTRIBUTE1 = 'P_GROUP_ID'
     , ATTRIBUTE2 =  'NUMBER'
 WHERE ATTRIBUTE_CODE = 'XXPDH_CST_UPLOAD_INTG_XA2';

UPDATE BNE_ATTRIBUTES
   SET ATTRIBUTE1 =  'X_RETURN_STATUS'
 WHERE ATTRIBUTE_cODE = 'XXPDH_CST_UPLOAD_INTG_XA3';  

UPDATE BNE_ATTRIBUTES
   SET ATTRIBUTE1 =  'X_MSG_DATA'
 WHERE ATTRIBUTE_cODE = 'XXPDH_CST_UPLOAD_INTG_XA4';