1 Reply Latest reply: Feb 2, 2014 8:21 AM by Sachin Gupta RSS

I get an error when trying to execute a P6 report in BI Publisher

1239469 Newbie
Currently Being Moderated

Hi all,

My configuration is:

BI Publisher 11g

P6 EPPM 8.3 SP1

oracle linux 5

database oracle 11G

note: data in my database are imported in my current database and are from another P6 EPPM database (in fact i do an expdp and in my current database, i do a delete P6 schemas (all P6 users) then impdp for all schemas, it's ok but may be some scripts to run for apply role  ??  for example i 'm not sure for re execute orpm_secpac.sql ???

setup configuration connection BI Pub with P6 according to the Oracle doc: connecting_bi_publisher_to_p6.pdf

In BI Publisher, i get error issue when open a report (P6 sample report)


Problem Description


P6 publication is ok, with the sample projects for now ... for example report named "activiy Look Ahead" setup (in BI) with the right data model is ok

from P6 web, i can see only the list of shared folder --> it's mean that P6 is connected good to BI web service

but no reports under each sub folder... strange ?


When opening the report (in BI Publisher with admin credential)  an error message is displayed

JDBC data source is named P6RPT and connecting ok , pre-action is set with secpac.SET_BIP_USER(:xdo_user_name)


Error message


Parameter name: p_project_id ORA-06550: line 4, column 18: PLS-00302: component 'SET_BI_USER' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored


Anyone have an idea ?


Thanks in advance



  • Correct Answers - 10 points
  • Helpful Answers - 5 points