I strongly support this idea

With the data source AuditViewDB I have created a query which can provide with the details of the Bursting delivery data and URL to download the output. This query may help some to get the information needed.

SELECT
reqid
, reppath
, SUBSTR(reppath, INSTR(reppath,'/',-1,1)+1) report_name
, start_time
, end_time
, deldest
, submitted_by
, job_name
, outputid
, deliveryid
, outputname
, reportsize
,
CASE
WHEN
INSTR(deldest, 'cc=',1,1) = 0
THEN
CAST(NULL AS VARCHAR2(200))
ELSE
CASE
WHEN
INSTR(SUBSTR(deldest,INSTR(deldest, 'cc=',1,1)+3),'=',1) = 0
THEN
SUBSTR(deldest,INSTR(deldest, 'cc=',1,1)+3)
ELSE
SUBSTR(SUBSTR(deldest,INSTR(deldest, 'cc=',1,1)+3),1, INSTR(SUBSTR(SUBSTR(deldest,INSTR(deldest, 'cc=',1,1)+3),1,INSTR(SUBSTR(deldest,INSTR(deldest, 'cc=',1,1)+3),'=',1)),',',-1,1)-1)
END
END ccaddres
,
CASE
WHEN
INSTR(deldest, 'to=',1,1) = 0
THEN
CAST(NULL AS VARCHAR2(200))
ELSE
CASE
WHEN
INSTR(SUBSTR(deldest,INSTR(deldest, 'to=',1,1)+3),'=',1) = 0
THEN
SUBSTR(deldest,INSTR(deldest, 'to=',1,1)+3)
ELSE
SUBSTR(SUBSTR(deldest,INSTR(deldest, 'to=',1,1)+3),1, INSTR(SUBSTR(SUBSTR(deldest,INSTR(deldest, 'to=',1,1)+3),1,INSTR(SUBSTR(deldest,INSTR(deldest, 'to=',1,1)+3),'=',1)),',',-1,1)-1)
END
END toaddres
,
CASE
WHEN
INSTR(deldest, 'content_type=',1,1) = 0
THEN
CAST(NULL AS VARCHAR2(200))
ELSE
CASE
WHEN
INSTR(SUBSTR(deldest,INSTR(deldest, 'content_type=',1,1)+13),'=',1,
CASE
WHEN
INSTR(SUBSTR(deldest,INSTR(deldest, 'content_type=',1,1)+13),';charset=',1,1) = 0
THEN
1
ELSE
2
END ) = 0
THEN
SUBSTR(deldest,INSTR(deldest, 'content_type=',1,1)+13)
ELSE
SUBSTR(SUBSTR(deldest,INSTR(deldest, 'content_type=',1,1)+13),1, INSTR(SUBSTR(SUBSTR(deldest,INSTR(deldest, 'content_type=',1,1)+13),1,INSTR(SUBSTR(deldest,INSTR(deldest, 'content_type=',1,1)+13),'=',1,
CASE
WHEN
INSTR(SUBSTR(deldest,INSTR(deldest, 'content_type=',1,1)+13),';charset=',1,1) = 0
THEN
1
ELSE
2
END )),',',-1,1)-1)
END
END ctyp
,
CASE
WHEN
INSTR(deldest, 'subject=',1,1) = 0
THEN
CAST (NULL AS VARCHAR2(200))
ELSE
CASE
WHEN
INSTR(SUBSTR(deldest,INSTR(deldest, 'subject=',1,1)+8),'=',1) = 0
THEN
SUBSTR(deldest,INSTR(deldest, 'subject=',1,1)+8)
ELSE
SUBSTR(SUBSTR(deldest,INSTR(deldest, 'subject=',1,1)+8),1, INSTR(SUBSTR(SUBSTR(deldest,INSTR(deldest, 'subject=',1,1)+8),1,INSTR(SUBSTR(deldest,INSTR(deldest, 'subject=',1,1)+8),'=',1)),',',-1,1)-1)
END
END subj
,
CASE
WHEN
INSTR(deldest, 'from=',1,1) = 0
THEN
CAST (NULL AS VARCHAR2(200))
ELSE
CASE
WHEN
INSTR(SUBSTR(deldest,INSTR(deldest, 'from=',1,1)+5),'=',1) = 0
THEN
SUBSTR(deldest,INSTR(deldest, 'from=',1,1)+5)
ELSE
SUBSTR(SUBSTR(deldest,INSTR(deldest, 'from=',1,1)+5),1, INSTR(SUBSTR(SUBSTR(deldest,INSTR(deldest, 'from=',1,1)+5),1,INSTR(SUBSTR(deldest,INSTR(deldest, 'from=',1,1)+5),'=',1)),',',-1,1)-1)
END
END fromaddress
FROM
(
SELECT
sjob.requestid reqid
, sjob.iau_resource reppath
, (
SELECT
MIN(startdate)
FROM
fusion_iau_viewer.bipublisher_v stim
WHERE
stim.startdate IS NOT NULL
AND sjob.requestid = stim.requestid) start_time
, (
SELECT
MAX(enddate)
FROM
fusion_iau_viewer.bipublisher_v etim
WHERE
etim.enddate IS NOT NULL
AND sjob.requestid = etim.requestid) end_time
, REPLACE(CAST(deljob.deliveryproperties AS VARCHAR2(1000)),CHR(10),'') deldest
, sjob.iau_initiator submitted_by
, sjob.userjobname job_name
, deljob.outputid
, deljob.deliveryid
, deljob.outputname
, deljob.reportsize
, 'https://'
|| 'Your Fusion ERP pod'
|| '/xmlpserver/servlet/outputDocument?outputid='
|| deljob.outputid
|| '&outputname='
|| deljob.outputname url_for_output
FROM
fusion_iau_viewer.bipublisher_v sjob
, fusion_iau_viewer.bipublisher_v ejob
, fusion_iau_viewer.bipublisher_v deljob
WHERE
sjob.iau_eventtype = 'ReportJobStart'
AND sjob.iau_componenttype = 'bipublisher'
AND sjob.bursting = 1
AND ejob.iau_eventtype = 'ReportJobEnd'
AND deljob.iau_eventtype = 'ReportDelivery'
AND deljob.deliverymethod = 'EMAIL'
AND UPPER(sjob.iau_resource) LIKE UPPER('%'
|| :P_REPORT_PATH
|| '%')
AND sjob.requestid = ejob.requestid
AND deljob.requestid = sjob.requestid)
ORDER BY
start_time

I have not enabled the data source myself. May be done by the oracle consultant while implementation of Fusion ERP. A link to the documentation:

Specify the Data Source Connection for Publisher Audit Data

may help to enable the data source.

Further information on BIP Audit reports can be found following the links:

wp-fusionbipaudit-5459609.pdf

Using BI Publisher to Create Audit Reports

Regards,

Nitin.

Yes. You are right. You cannot join it with other data source.