top of page

After cloning in Oracle EBS R12.2, the SESSION_COOKIE_NAME resulted in Forms being unable to open.

Forms were failing with the below error after cloning


Cannot complete application logon. You may have entered an invalid application password, or there may have been a database connect error

Upon investigation, the problem was traced to the SESSION_COOKIE_NAME stored in the ICX_PARAMETERS table.

Executing the query below should provide the EBS DB name as the output, but in our situation, it returns an empty result:

select FND_SESSION_MANAGEMENT.getsessioncookiename() from dual;

The function `FND_SESSION_MANAGEMENT.getsessioncookiename()` retrieves the value from the ICX_PARAMETERS table.

Upon inspecting the ICX_PARAMETERS table, it was found that the SESSION_COOKIE_NAME column is null.

To address the issue with ICX_PARAMETERS having no rows, the following steps were taken to resolve the problem:

1. Before inserting rows into any table, it is crucial to check the dependencies on that table.

2. In our specific scenario, the table had no dependencies and only had an editioning view, so the act of inserting rows did not cause any issues.

3. No other package is updating the ICX table.

 SQL> select * from dba_dependencies where owner='ICX' and REFERENCED_NAME like 'ICX_PARAM%';
 ---------- -------------------- ------------------- ----- -------------------- -------------------- -------------------- ----
 ICX       ICX_PARAMETERS#     VIEW               ICX  ICX_PARAMETERS      TABLE                                    HARD

 SQL> select count(*) from DBA_SOURCE where text like '%UPDATE%ICX_PARAMETERS%';

 SQL> select count(*) from DBA_SOURCE where text like '%INSERT%ICX_PARAMETERS%';

Since the ICX_PARAMETERS table had no rows, we resolved the issue by inserting the required rows based on a reference from a functioning instance. The columns in the table were populated according to the configuration of the working instance.

 SQL> insert into icx.icx_parameters (HOME_URL,QUERY_SET,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) Values ('&EBS_URL',25,1, TO_DATE('12-08-2001', 'dd-mm-yyyy'),1, TO_DATE('12-08-2001', 'dd-mm-yyyy'));
 1 row created.
 SQL> update icx.icx_parameters set SESSION_COOKIE_NAME='&DBNAME' where HOME_URL='&EBS_URL';
 1 row updated.
 SQL> commit;
 Commit complete.

Synonym and editioning views are working fine after inserting rows into the base table.

 SQL> select count(*) from apps.icx_parameters;
 SQL> select count(*) from icx.icx_parameters#;
31 views0 comments

Recent Posts

See All

Find a patch that modified a file in EBS R12.2

Retrieve the file details from the apps.ad_files table SELECT file_id, filename, subdir FROM apps.ad_files WHERE filename LIKE '%afcpprog%' FETCH FIRST 1 ROWS ONLY; Get the patch_run_bug_id using the


Contact Me

Tel: 7989359581

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon

Thanks for submitting!

© 2023 by Phil Steer . Proudly created with

bottom of page