I have a custom package that has 2 procedures in it.
1 of the procedures appears in the LOV to create a New Database Task Schedule but the 2nd one doesn’t appear.
If I run the procedure within PL/SQL Developer it runs without any issues.
Dictionary Cache and Security Cache have been refreshed.
I have check the permission set and it has been granted.
I have logged out and back in again.
Any ideas?
Best answer by RutJWhalen
View original
+15
Hi
By "custom package" are you referring to,
1. A package created for a custom logical unit? ex: <Custom_Logical_Unit>_CFP
2. A package created by a customized logical unit or a utility? ex: <C_New_Lu>_API or <C_New_Util>_API
3. A non-IFS package created in PL/SQL Developer and deployed directly in the Oracle database?
Further, could you try executing the below script and then logout and login back in again?
BEGIN
Installation_SYS.Grant_Privileged_Grantee('IFSSYS', TRUE);
END;
/Cheers !
Dhananjaya.
The issue was because although I had created the package and the procedure, I went straight to New Database Task Schedule and I had missed out the Create Database Task bit first.
All resolved.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.