Issue Summary
While executing the ADOP Prepare phase in Oracle E-Business Suite, the process fails because the Internal Concurrent Manager (ICM) status cannot be determined.
Error Message
[STATEMENT] ICM status cannot be determined.
[STATEMENT] .. Check if ICM is running
[UNEXPECTED] Error determining status of Internal Concurrent Manager
[UNEXPECTED] Error calling runConcurrentProgram subroutine.
[ERROR] Prepare phase has failed.
Root Cause
The issue was caused by the APPLSYSPUB database account being expired. When APPLSYSPUB is expired or locked, ADOP is unable to complete the applications logon required to check the Internal Concurrent Manager status, which causes the Prepare phase to fail with the error above.
Resolution
Validate APPLSYSPUB Account
Step 1: Check APPLSYSPUB Account Status
Connect as SYSDBA and execute:
SELECT username,
account_status,
profile
FROM dba_users
WHERE username LIKE ‘APP%’;
Example Output:
USERNAME ACCOUNT_STATUS PROFILE
————- —————— ——–
APPLSYSPUB EXPIRED(GRACE) DEFAULT
Step 2: Ensure APPLSYSPUB is OPEN
If the account is locked or expired:
- Reset the APPLSYSPUB password.
- Unlock the account if necessary.
Verify connectivity:
sqlplus applsyspub/<password>
The connection should complete successfully.
Validation
After completing the corrective actions, execute the ADOP Prepare phase again:
adop phase=prepare
The Prepare phase should complete successfully without reporting the ICM status error.
Conclusion
The “ICM status cannot be determined” error during the ADOP Prepare phase was caused by the APPLSYSPUB database account being expired. Resetting/unlocking the APPLSYSPUB account and confirming connectivity resolves the issue.
