Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DBMS_RANDOM package is invalid

edited Jan 30, 2021 8:33PM in Database 3 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!