Technology Stack - EBS (MOSC)

MOSC Banner

sqlplus -s

edited Aug 20, 2021 11:35AM in Technology Stack - EBS (MOSC) 3 commentsAnswered


Hello All

sqlplus -s &un_apps/***** @/u01/app/hlrdv1/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE
Connected.
  declare
*
ERROR at line 1:
ORA-20000: ORA-24033: no recipients for message Failed to call the procedure
fnd_apps_mode_util.set_to_maintenance_mode while enabling
maintenance mode.
ORA-06512: at line 38

Tried following these

1. "Step 5: Record Advanced Queue settings" of "Section 1: Prepare the source system". Perform on the source instance.
2. "Step 1: Reset Advanced Queues" of "Section 5: Update the imported Release 12 database instance". Perform on the target instance.
3. Restart (bounce) the database

Once all Advanced Queues are created successfully, users will be able to enable/disable Maintenance Mode from adadmin.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center