BI Publisher Bursting Query - File Not Loading to UCM Server and How to Check Delivery Status

Hi Experts,

I am using a BI Publisher bursting query to deliver output files to a UCM (WebCenter Content) server. However, although the bursting process completes, the file is not getting uploaded to the UCM server.

Below is my bursting query:

SELECT

:TABLE_NAME KEY,
'UserdTableDelete' TEMPLATE,
'en-US' LOCALE,
'TEXT' OUTPUT_FORMAT,
'true' SAVE_OUTPUT,
'WCC' DEL_CHANNEL,
REPLACE(:TABLE_NAME,' ','') || '' ||TO_CHAR(SYSDATE,'YYYYMMDD') || '.dat' AS OUTPUT_NAME,
'FA_UCM_PROVISIONED' PARAMETER1,
'FAFusionImportExport' PARAMETER2,

REPLACE(:TABLE_NAME,' ','') || '' ||TO_CHAR(SYSDATE, 'DDMMYYHH24MISS') PARAMETER5,
REPLACE(:TABLE_NAME,' ','') || '