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

Regards

Legend

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