Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
How to Create a Data Set using Content Server as Data Source in Oracle BI Publisher (Embedded within

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)
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
-
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.
0 -
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
0 -
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.
0 -
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
0 -
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
0 -
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.
0 -
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
0 -
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?0