Not Able To Create A New Database Connection: FNDSECURITY_APPL_SERVER_ID with Instance Mapping For iSetup

ISSUE:

On Oracle Applications 12.1.3 version,
when attempt to register the target instance on a central instance,getting following error:

Message not found. Application: AZ, Message Name: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID.

The issue can be reproduced at will with the following steps:
1.Register the target instance on a central instance.

The issue has the following business impact:
Unable to register the target instance.

CAUSE:

The required correct DBC file was not in place / corrupted.

SOLUTION:

1. Please confirm whether the DBC (Database Connectivity) File created for instance that you want to map to.

2. Check the path $FND_SECURE. of central instance to check and confirm the DBC file of each remote instance.

3. Run Autoconfig to regenerate DBC file in the required instance and copy the file to the path $FND_SECURE.

4. Re-test.

REFERENCE:

Not Able To Create A New Database Connection: FNDSECURITY_APPL_SERVER_ID with Instance Mapping For iSetup (Doc ID 1627952.1)

  • June 28, 2019 | 21 views
  • Comments