Oracle Communities

Oracle Analytics and AI

Child Item

How to burst the BI Report result file to particular UCM account through BI Report bursting ?

Hi All,

We are trying to place the BI Report result file to below mentioned UCM account using BI Report bursting but its not getting placed to the mentioned account. Bursting details are mentioned below for reference.

UCM Account : fin/receivables/import

Bursting Query :

SELECT 'X' AS "KEY",

'XXXX_AR_INV_PRT_CSV' TEMPLATE,

'en-US' LOCALE,

'csv' OUTPUT_FORMAT,

'WCC' DEL_CHANNEL,

'FA_UCM_PROVISIONED' PARAMETER1,

'FAFusionImportExport' PARAMETER2,

'FUSION_APPS_OBIA_BIEE_APPID' PARAMETER3,

'fin/receivables/import' PARAMETER4,

'XXXX_AR_INV_PRT_CSV' PARAMETER5,

'XXXX_AR_INV_PRT_CSV.txt' PARAMETER6,

'AD1' PARAMETER7,

'FALSE' PARAMETER9

FROM dual

Can you please provide your suggestions to place the file in particular UCM Account.

Thanks,

Palukuri Jambulaiah

Find more posts tagged with

Accepted answers

All comments

Porfirio Benjamín Rodríguez Miguens

If the bursting works but it just doesn't complete the account to be filtered later, you can change this:

'fin$/receivables$/import$' PARAMETER4,

Kind regards,

Porfirio Benjamín Rodríguez Miguens