Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Fusion Cloud - Where do Fusion BI Publisher report outputs get saved to by default?

Question
238
Views
0
Comments

Summary

Fusion Cloud - Where do Fusion BI Publisher report outputs get saved to by default?

Content

Hi All,

My client is a Fusion Applications Cloud R12 customer. What I am trying to get to the bottom of is... where do Fusion BI Publisher report outputs get saved to by default?

In EBS we ran Concurrent Jobs that generated an output, which would result in a record being created in the FND_CONC_REQ_OUTPUTS table. I also believe the actual output file was stored in a directory on the Oracle Server?

What is confusing me slightly is that with Fusion BI Publisher, a connection to an Oracle provisioned UCM server has already been configured by default: FA_UCM_PROVISIONED. Early in the project we were experiencing issues with running some BI Publisher reports from ESS Jobs (we were seeing Remote Region Errors), which was resolved by virtue of Oracle bouncing the UCM server.

So, when we run a BI Publisher report in Fusion Cloud, does the resulting output get stored in:

  • A directory on the Oracle Fusion Cloud server?
  • As a record in the Fusion database?
  • Or routed directly for storage on the UCM server?

Wise words greatly appreciated!

Thanks,

Richard