Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure:
fnd_user_pkg.addresp(username => Application User Name
,resp_app => Responsiblity_Application_Short_Name
,resp_key => Responsibility_Key
,security_group => Security_Group ‘Mostly it is ‘STANDARD’ so it can be hard coded it’
,description => Any comments you want
,start_date => Sysdate From Today
,end_date => Sysdate + any number of days which is required);
BEGIN
fnd_user_pkg.addresp (‘SYEDSAADALI‘,’SYSADMIN‘,’SYSTEM_ADMINISTRATOR‘,’STANDARD‘,
‘Add Sysadmin Responsibility to SYEDSAADALI‘, SYSDATE, SYSDATE + 100);
COMMIT;
DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( ‘ Responsibility is not added due to ‘ || SQLCODE || SUBSTR (SQLERRM, 1, 100));
ROLLBACK;
END;
Routine AFPGCP cannot create a process ID for your concurrent manager process ORACLE error 8004 in FDUUID
Cause: FDUUID failed due to ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated.
TheCall to establish_icm failed
The Internal Concurrent Manager has encountered an error.
Disabled – Program to run request is not enabled. We need to Contact System Administrator.
On Hold – Pending request is placed on hold forcefully by choosing the Hold Request button in the Concurrent Requests window.
No Manager – No manager is defined to run the request or the manager needed to run the request is down. We need to Contact System Administrator. A status of No Manager is also given when all managers are locked by run-alone requests.
All Rights Reserved