DBMS_RANDOM package is invalid
Summary
DBMS_RANDOM package is invalid and due to which our EBS url is not working.Content
DBMS_RANDOM package is Invalid in our EBS R12.1.3 environment. This is causing issues as EBS is not able to create session due to Invalid state of this package.
We have tried to compile but it errors out
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> alter package SYS.DBMS_RANDOM compile;
Warning: Package altered with compilation errors.
SQL> show err
No errors.
SQL> select message_number, text from dba_errors where owner='SYS' and name='DBMS_RANDOM';
MESSAGE_NUMBER
--------------
0