Thursday, March 24, 2016

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';  

Tuesday, March 1, 2016

R12 WEBADI ERROR: oracle.jbo.TooManyObjectsException: JBO-25013

I knew this error had to do with some kind of redundant Cache:

After several testing sessions and research i have compiled this list which will effectively help in cache related web adi errors:

-----------------------
  --  diagnostics --
-----------------------

1) clear bne cache
-------------------
http://<machine>:<port>/OA_HTML/BneAdminServlet


2) clear browser cache
----------------------
clear all the cache in the respective browser


3) clear core services cache
----------------------------------
functional administrator > core services > caching framework > global configuration


4) delete data from bne_tables
-------------------------------------
clear data from all bne% tables related to the integrator


5) run the wf backgroud process in deferred mode
------------------------------------------------
parameters: Null, Null, Null, No, Yes, No


6) Apache bounce
-----------------
cd $INST_TOP
cd admin/scripts
sh adapcctl.sh stop
sh adapcctl.sh start