HR Integrators: Web Adi Create Document Expires Current Session When Opening the Excel Session

(Doc ID 1319354.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

On PROD:  12.0.4 version, Application Desktop Integrator

ACTUAL BEHAVIOR  
---------------
When trying to create a custom integrator (use the BEE Spreadsheet interface) using seeded 'HR Integrator Setup'  (the Create Document function from Desktop Integrator responsibility), Web ADI logs out the user and unable to proceed. The moment web adi generates the document (xls), session terminates.
Note: Using single session per user by setting business event oracle.apps.icx.security.session.created.

Issue persists for a seeded integrator as well -> HR Update Salary Proposals - session terminates while the web adi document starts creating.

EXPECTED BEHAVIOR
-----------------------
Expect to complete the integrator setup w/o logging out and asking for login details

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Subscription oracle.apps.icx.security.session.created exists to restrict single session per user.
2. Desktop Integrator responsibility > Create Document function
3. Web ADI logs out
4. Follow <Note 344870.1> and do the workaround steps but issue still exists 

Note:
The issue did not happen when the same setup of integrator was done in test and development where the event mentioned has not been registered.

Seems like Webadi expires the current session of the user when opening the excel session. According to Note 344870.1 sometimes Web ADI requires multiple sessions so followed the steps as mentioned in the document by creating a new profile - BNE_NEW_SESSION and set the value to 'No' at site level. But that did not resolve the issue.

GL team uses Web ADI for the standard Journal Import and Currency and Payroll team uses BEE spreadsheet interface, both of which works fine. However, seeded 'Salary Management' under People in Global HRMS Manager responsibility gives the same issue.

File Versions:
-----------
AFICXSMB.pls 120.19.12000000.10
AFICXSMS.pls 120.5.12000000.2
AFSCJAV8.pls 120.0.12000000.11
AFSCJAVS.pls 120.6.12000000.6

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms