My Oracle Support Banner

HR Integrators: Web Adi Create Document Expires Current Session When Opening the Excel Session (Doc ID 1319354.1)

Last updated on NOVEMBER 23, 2020

Applies to:

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


On PROD:  12.0.4 version, Application Desktop Integrator

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

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

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

The issue can be reproduced at will with the following steps:
1. Subscription 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 

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.