BI报表Bursting调度无输出文件且未发送邮件求助

• 作为Bursting报表领域新手，已基于Bursting创建自定义贷项通知单报表，模板、文件名及路径均通过Bursting配置获取
• 立即调度报表时，任务显示成功完成，但未收到邮件（即使在Bursting SQL中硬编码了个人邮箱）；BI报表作业历史中进程状态为成功，但未生成任何输出文件
• 切换至临时/分析模式运行报表，选择相同参数时，可正常生成PDF格式的输出文件
• 报表属性已启用Bursting，手动传入参数测试Bursting查询时，查询可正常返回参数详情

Bursting查询语句 #

SELECT 
 DISTINCT HP.PARTY_NAME AS KEY
,'Layout' AS TEMPLATE
,'en-US' AS LOCALE
,'PDF' AS OUTPUT_FORMAT
,'EMAIL' AS DEL_CHANNEL
,'Aggregated_Credit_Memo' OUTPUT_NAME
,'my email address' AS PARAMETER1
,'my email address' AS PARAMETER2
,'sender@oracle.com' AS PARAMETER3
,'Credit Memo Print' AS PARAMETER4
,'Please see the attached' AS PARAMETER5
,'true' AS PARAMETER6
,'donotreply@oracle.com' AS PARAMETER7
FROM
HZ_PARTIES HP
,HZ_CONTACT_POINTS HCP
,HZ_CUST_ACCOUNTS CUST
,HZ_CUSTOMER_PROFILES_F HCPF
,RA_CUSTOMER_TRX_ALL RCTA
,HR_OPERATING_UNITS HOU
WHERE 1 = 1
AND CUST.ACCOUNT_NUMBER BETWEEN NVL(:p_Account_Num_From,CUST.ACCOUNT_NUMBER) AND NVL(:p_Account_Num_To,CUST.ACCOUNT_NUMBER)
AND HCP.OWNER_TABLE_ID = HP.PREFERRED_CONTACT_PERSON_ID
AND CUST.PARTY_ID = HP.PARTY_ID
AND HCPF.CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID
AND HCPF.STMT_DELIVERY_METHOD = 'EMAIL'
AND :P_PRINT_OPTION = 'EMAIL'
AND RCTA.ORG_ID = HOU.ORGANIZATION_ID
AND RCTA.BILL_TO_CUSTOMER_ID = CUST.CUST_ACCOUNT_ID
AND HOU.ORGANIZATION_ID = :P_ORG_ID

UNION

SELECT 
 DISTINCT HP.PARTY_NAME AS KEY
,'Layout' AS TEMPLATE
,'en-US' AS LOCALE
,'PDF' AS OUTPUT_FORMAT
,'EMAIL' AS DEL_CHANNEL
,'Aggregated_Credit_Memo' OUTPUT_NAME
,' ' AS PARAMETER1
,' ' AS PARAMETER2
,'sender@oracle.com' AS PARAMETER3
,'Credit Memo Print' AS PARAMETER4
,'Please see the attached' AS PARAMETER5
,'true' AS PARAMETER6
,'donotreply@oracle.com' AS PARAMETER7
FROM
HZ_PARTIES HP
,HZ_CONTACT_POINTS HCP
,HZ_CUST_ACCOUNTS CUST
,HZ_CUSTOMER_PROFILES_F HCPF
,RA_CUSTOMER_TRX_ALL RCTA
,HR_OPERATING_UNITS HOU
WHERE 1 = 1
AND CUST.ACCOUNT_NUMBER BETWEEN NVL(:p_Account_Num_From,CUST.ACCOUNT_NUMBER) AND NVL(:p_Account_Num_To,CUST.ACCOUNT_NUMBER)
AND HCP.OWNER_TABLE_ID = HP.PREFERRED_CONTACT_PERSON_ID
AND CUST.PARTY_ID = HP.PARTY_ID
AND HCPF.CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID
AND HCPF.STMT_DELIVERY_METHOD = 'EMAIL'
AND :P_PRINT_OPTION = 'PRINT OUT'
AND RCTA.ORG_ID = HOU.ORGANIZATION_ID
AND RCTA.BILL_TO_CUSTOMER_ID = CUST.CUST_ACCOUNT_ID
AND HOU.ORGANIZATION_ID = :P_ORG_ID

预期结果 #

原本预期会收到包含PDF输出文件的邮件。

内容的提问来源于stack exchange，提问作者Joji