ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE - Oracle EBS R12

https://cashmanagementcm.blogspot.com/2018/06/ora-08004-sequence-fndconcurrentprocess.html

ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE

ERROR

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.

SOLUTION

The max value for the sequence FND_CONCURRENT_PROCESSES_S has been reached and we need to increase the max value.

For Checking Run the below query

SQL> select FND_CONCURRENT_PROCESSES_S.nextval from dual;

select FND_CONCURRENT_PROCESSES_S.nextval from dual
*
ERROR at line 1:
ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and
cannot be instantiated

Increase max value Of APPLSYS.FND_CONCURRENT_PROCESSES_S
SQL> ALTER SEQUENCE APPLSYS.FND_CONCURRENT_PROCESSES_S MAXVALUE 99999999;

Sequence altered.

Not showing Open Interface Tab in Cash Management Form For Matching Open interface transactions for reconciliation.

https://cashmanagementcm.blogspot.com/2018/06/not-showing-open-interface-tab-in-cash.html

SOLUTION

Enable  “Use Reconciliation Open Interfaces” check box under “Open Interface Controls” in Bank Account Control screen.

Step 1. Navigate to Bank account Inquiry screen : Setup -> Bank -> Bank Account

Step 2. Find your bank and select for Update option.

Step 3. Click on “Account Control” 

Step 4. Enable the “Use Reconciliation Open Interfaces” check box.

Step 5. Click on Finish Button

Now You can to get the Open Interface Option enabled available in Form Window.