Oracle Transactional Business Intelligence

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

How to Create a Data Set using Content Server as Data Source in Oracle BI Publisher (Embedded within

Received Response
290
Views
8
Comments

Summary

How to Create a Data Set using Content Server as Data Source in Oracle BI Publisher (Embedded within Oracle HCM Cloud Release 12/13)

Content

Hi Experts,

Has anyone of you created a data set using Content Server as a Data Source yet.

I have gone through the documentation and it refers to creating a Data Source Connection using Reports and Analytics -> BI Catalog -> Administration -> Manage BI Publisher -> Content Server(Add).

What should be the Web Center Content Connection string used. (Refer screenshot below)

 

CSConnectionString.JPG

 

Any help/pointers/step-by-step doc would help.

Note: Maybe I am raising this on a different forum but could not find "Submit a Topic" on Report forums. if there exists one please do let-me know

Thanks in advance

Kind Regards

Ashish

Answers

  • Abhijit.Desai
    Abhijit.Desai Rank 1 - Community Starter

    The connection string should be:

     http://fs-internal.oracleoutsourcing.com:10613/idcnativews

    Please see note "How To Use UCM Server As A Delivery Channel for BI Publisher Report In Fusion Applications Release 12 ? (Doc ID 2319967.1)" which has this connection string when using UCM as a delivery channel. The connection string works when using UCM as a data source too.

     

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    Thanks Abhijit for the response.

    But shouldn't the connection string be environment (pod / instance ) specific.
    Each environment should have it's own content server (or else otherwise one can have access to the files of any environment which I assume would be a security breach).

    Ki

  • Abhijit.Desai
    Abhijit.Desai Rank 1 - Community Starter

    The URL "http://fs-internal.oracleoutsourcing.com:10613/idcnativews" is not accessible over the internet. It is only accessible to the BI server within the fusion instance.

    The URL is from the Oracle Support note that I mentioned. The UCM server is now provisioned out of the box as a delivery destination "FA_UCM_PROVISIONED" using the URL "http://fs-internal.oracleoutsourcing.com:10613/idcnativews". The same URL can be used to setup UCM as a data source.

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    So does this means that the link "https://fs-internal.oracleoutsourcing.com:10613/idcnativews'; would always internally redirect to the UCM Server for the pod.

    If yes, then everything falls in place.

    Kind Regards

    Ashish

  • Senthilrajan V
    Senthilrajan V Rank 5 - Community Champion

    Hi Ashish,

    Were you able to create BI Publisher Datamodel/Report using the files in UCM? Let me know if there are any documents for the same.

    We want to source some external data for our Fusion BI Publisher reports, want to check if the files can be uploaded/refreshed in UCM using FBDI that can act as a source for Fusion BI Publisher Reports.

    Regards

    Senthil

  • Cristian Betancur
    Cristian Betancur Rank 2 - Community Beginner

    Hi

    I have a report where I use Content Server Data Set.

    With a user, I can see UCM document into report without problem.

    But when I executed it with other user, report shows an error:

    "oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: No such data source found in the data source config. Or you do not have access permission. Could not get data source connection for: FA_UCM_PROVISIONED"

    Do you know what is the issue? Any suggest?

    Thanks.

    Cristian.

  • Senthilrajan V
    Senthilrajan V Rank 5 - Community Champion

    Hi Cristian,

    Make sure the other user also have same access, especially roles specific to UCM.

    Custom UCM Role that shall have some of these Role Hierarchies

    AttachmentsRead, AttachmentsUser, AttachmentsWrite, CRMStageWrite, HCM_DATALOADER_EXPORT_RWD, UCM_SpacesAuthenUser, UCM_SpacesUser, HCM_DATALOADER_IMPORT_RWD, Content Administration

    -Senthil

  • SGFT4
    SGFT4 Rank 1 - Community Starter

    Hi @Abhijit.Desai ,
    For the out of box UCM Server "FA_UCM_PROVISIONED" - how do we configure the users, roles, security groups, and accounts? Do you have any idea about the Weblogic Server URL for this UCM server?