Custom PL/SQL Procedure Not Appearing in “Select Method” for Database Task (IFS Apps 8)

Hi ​@sahango 

Did you try refreshing the Dictionary cache?

Thanks & Regards,
Asanka.

Thank you for your quick response!
Refreshing the Dictionary cache solved the issue. Now I can see my custom procedure in the method list.
Much appreciated!

As ​@asanka1055 mentioned, try refreshing the cache.

If that doesn’t work either, you can manually enter this just for testing, etc. using the following script.

DECLARE
   lu_name_ VARCHAR2(100) := 'XxxXxxXxx';
   module_  VARCHAR2(100) := 'XXXXXX';
   api_     VARCHAR2(100) := 'XXXXXXX_API';
   proc_    VARCHAR2(100) := 'XxxXxxXxxxx';

BEGIN

   IF NOT Dictionary_sys.Logical_Unit_Is_Installed(lu_name_) THEN
      INSERT INTO dictionary_sys_tab(lu_name, module, lu_prompt, lu_type, rowversion)
           VALUES(lu_name_, module_, lu_name_, 'L', SYSDATE);
   END IF;

   IF NOT Dictionary_SYS.Package_Is_Installed(api_) THEN
      INSERT INTO dictionary_sys_package_tab(lu_name, package_name, package_index, package_type, rowversion) 
           VALUES(lu_name_, api_, 1, 'N', SYSDATE);
   END IF;

   IF NOT Dictionary_sys.Method_Is_Installed(api_, proc_) THEN
      INSERT INTO dictionary_sys_method_tab(lu_name, package_name, method_name, method_type, rowversion) 
           VALUES(lu_name_, api_, proc_, 'N', SYSDATE);
   END IF;

   COMMIT;
END;