Bursting to UCM not consistent

Sravanthi Kollapudu-Oracle

Hi,

I have a simple report that needs to burst the output to UCM. It is not working consistently. Can you please provide pointers as to what could be the issue.

I have few existing reports that are using the same server details and are working fine. This is a new report and I am unable to get what exactly is the issue.

Below is the bursting query-

select 'OPS' as "KEY"
, 'B2B' TEMPLATE
, 'en-US' LOCALE
, 'csv' OUTPUT_FORMAT
, 'WCC' DEL_CHANNEL
, 'ERP_FIN_INT_UCM' PARAMETER1
, 'FAFusionImportExport' PARAMETER2
, 'Integration_User' PARAMETER3
, '' PARAMETER4
, 'INT38_IC_B2B~'||TO_CHAR(SYSDATE, 'DDMMYYHH24MISS') PARAMETER5
, 'INT38_IC_B2B~'||TO_CHAR(SYSDATE, 'DDMMYYHH24MISS')||'.csv' PARAMETER6
, 'false' PARAMETER9
, '/Contribution Folders/Outbound Extract/INT37/' PARAMETER10
from dual

Regards,

Sravanthi

Mallikarjuna Kuppauru-Oracle

HI @Sravanthi Kollapudu-Oracle

Can you refer below MOS doc -

BIP Report Bursting Option to Deliver to UCM (Content Server) (Doc ID 2315095.1)

Regards,

Arjun