My Oracle Support Banner

Scheduled Analytics Publisher Jobs fails intermittently with Error "ApplSession returned from ATG API is null" (Doc ID 2957553.1)

Last updated on JUNE 26, 2023

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.23.04.0 and later
Oracle Fusion Financials Common Module Cloud Service - Version 11.13.23.04.0 and later
Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.23.04.0 and later
Information in this document applies to any platform.

Symptoms

Analytics Publisher Scheduled Jobs fails intermittently with the below error. This issue can occur after receiving 23B Quarterly update. As a result the failed job related report output will not be available.

Steps

  1. Login to Fusion cloud service
  2. Navigate to Tools > Report & Analytics
  3. Click Browse Catalog
  4. Navigate to the shared folder of the Analytics Publisher report to be scheduled
  5. Click on More > Schedule to submit a Job
  6. Click on Home
  7. Navigate to Report Job History Page and verify the Status details
  8. Few Jobs may fail due to the below error

Error

[INSTANCE_ID=bip.bi_serverHA] DataException:[INSTANCE_JOB_ID=xxxxxx] oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: ApplSession returned from ATG API is null:API is called with sessionId:******7A983Exxxxxxx3310A6xxxx
Could not get data source connection for: ApplicationDB_FSCM oracle.xdo.servlet.data.DataException: oracle

 

 

Cause

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
Symptoms
Cause
Solution
References

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