Oracle apps Xml report Error while saving Report output-Authentication failed

Some times when we get error like "Authentication failed" when we try save or open concurrent program output which is type of xml publisher.
e.g. please see below given screenshot.

Solution :
If you face this kind of issue then kindly set below given profile options at user level.
Profile option name :-Applications Web Agent

Set its value at user level. If suppose you are working on development instance then you need to set its value as url of development instance as  e.g. http://oracleapps.oracle.com:8021/pls/ebzd

Once done this setup , then you can retest issue.

Query to get profile options details from backend

SELECT
  fpov.profile_option_name ,
  fpov.user_profile_option_name,
  DECODE (TO_CHAR (fpo.level_id), '10001', 'SITE', '10002', 'APP', '10003',
  'RESP', '10005', 'SERVER', '10006', 'ORG', '10004', 'USER', 'NA' )
  profile_Level,
  DECODE (TO_CHAR (fpo.level_id), '10001', '', '10002',
  fa.application_short_name, '10003', fr.responsibility_key, '10005',
  fn.node_name, '10006', hou.NAME, '10004', fu.user_name, 'NA' ) Context_value,
  fpo.profile_option_value value,
  fr.RESPONSIBILITY_KEY,
  fr.RESPONSIBILITY_NAME
FROM
  apps.fnd_profile_options_vl fpov,
  apps.fnd_profile_option_values fpo,
  apps.fnd_user fu,
  apps.fnd_application fa,
  apps.fnd_responsibility_vl fr,
  apps.fnd_nodes fn,
  apps.hr_operating_units hou
WHERE
  1                         = 1
AND fpo.application_id      = fpov.application_id
AND fpo.profile_option_id   = fpov.profile_option_id
AND fu.user_id(+)           = fpo.level_value
AND fr.application_id(+)    = fpo.level_value_application_id
AND fr.responsibility_id(+) = fpo.level_value
AND fa.application_id(+)    = fpo.level_value
AND fn.node_id(+)           = fpo.level_value
AND hou.organization_id(+)  = fpo.level_value
AND fpov.user_profile_option_name LIKE 'GL: Data Access Set%' ;

Query to fetch Concurrent Program and executables details

SELECT
  fcpv.user_concurrent_program_name program_name,
  fcpv.concurrent_program_name program_short_name,
  fat.application_name program_application_name,
  fcpv.description program_description,
  fe.executable_name ,
  fe.execution_file_name ,
  DECODE( fe.execution_method_code, 'I', 'PLSQL Stored Procedure', 'P',
  'Report', 'L', 'SQL Loader','Q','SQL*Plus', fe.execution_method_code)
  execution_method,
  fu.user_name created_by,
  fcpv.creation_date
FROM
  fnd_executables fe,
  fnd_application_tl fat,
  fnd_concurrent_programs_vl fcpv,
  fnd_user fu
WHERE
  1                   =1
AND fe.application_id = fat.application_id
AND fe.executable_id  = fcpv.executable_id
AND fat.language      ='US'
AND fu.user_id        = fcpv.created_by
AND fcpv.user_concurrent_program_name LIKE 'Trial Balance';

Query to get GL batch, Journal related important column details.

SELECT
GJH.name Journal_Name,
GJB.name Batch_name,
GJL.ACCOUNTED_CR,
GJL.ACCOUNTED_DR,
gcc.CONCATENATED_SEGMENTS,
GJH.CREATED_BY,
gjc.JE_CATEGORY_NAME,
gl.NAME,
GJH.CURRENCY_CODE,
GJL.DESCRIPTION,
GJB.STATUS
FROM apps.GL_JE_HEADERS GJH,
apps.GL_JE_LINES GJL,
apps.GL_JE_BATCHES GJB,
apps.GL_JE_CATEGORIES gjc,
apps.gl_ledgers gl,
apps.gl_code_combinations_kfv gcc
WHERE GJH.JE_HEADER_ID=GJL.JE_HEADER_ID
AND GJB.JE_BATCH_ID=GJH.JE_BATCH_ID
and gcc.CODE_COMBINATION_ID=GJL.CODE_COMBINATION_ID
and gjc.JE_CATEGORY_NAME=GJH.JE_CATEGORY
and gl.LEDGER_ID=GJH.LEDGER_ID
AND GJB.NAME LIKE 'GLbatchName%'
and gjh.name like 'JournalHeaderName';

Query to find GL Journal Batch Approval status with history

SELECT DISTINCT
  gjb.NAME batch,
  default_period_name period,
  wn.recipient_role approver,
  DECODE (gjb.approval_status_code, 'A', 'Approved', 'I', 'In Process', 'J',
  'Rejected', 'R', 'Required', 'V', 'Validation Failed', 'Z', 'N/A' ) status,
  wn.begin_date approval_start_date,
  wn.end_date approval_end_date,
  wn.due_date approval_due_date
FROM
  wf_notifications wn,
  wf_items wi,
  gl_je_batches gjb
WHERE
  wn.CONTEXT LIKE 'GLBATCH%'
  ||
  (
    SELECT
      item_key
    FROM
      wf_items a
    WHERE
      a.user_key    = wi.user_key
    AND a.item_type = 'GLBATCH'
    AND ROWNUM      = 1
  )
  || '%'
AND wi.item_type = wn.MESSAGE_TYPE
AND wi.user_key  = gjb.NAME
AND gjb.name LIKE 'BatchName%';

Query to get concurrent Manager status from backend

SELECT   t.user_concurrent_queue_name AS "Concurrent Manager Name",
         b.max_processes AS "Actual Processes",
         b.running_processes AS "Target Processes",
         b.concurrent_queue_name, b.cache_size,
         b.min_processes, b.target_processes, b.target_node, b.sleep_seconds,
         b.diagnostic_level, b.manager_type, b.enabled_flag, t.description
    FROM fnd_concurrent_queues_tl t, fnd_concurrent_queues b
   WHERE b.application_id = t.application_id
    AND b.concurrent_queue_id = t.concurrent_queue_id
    AND b.enabled_flag = 'Y'
    AND t.LANGUAGE = USERENV ('LANG')
    --and  t.user_concurrent_queue_name like 'Out%'
ORDER BY b.max_processes DESC;