ODI-1551: The dbms_lock acquisition failed with a sql exception 'ORA-06550:

ODI-1551: The dbms_lock acquisition failed with a sql exception 'ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_LOCK' must be declared.

This issue you will get while running load plans.

Solution:
-----------
Grant  execute privileges on dbms_lock to ur schema( DB user for your work repository).


ex:

my schema name is :  ODI. (My Work Repository db user)


GRANT EXECUTE ON DBMS_LOCK  TO ODI;