Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling BI Publisher report from 12c stucked in running mod.

usman_noshahiNov 23 2016 — edited Nov 24 2016

Hi,

I am on test environment, Using Oracle forms

Forms [64 Bit] Version 12.2.1.2.0 (Production)

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

 With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Oracle Toolkit Version 12.2.1.2.0 (Production)

PL/SQL Version 11.2.0.3.0 (Production)

And Oracle BI publisher 12c.

I am trying to run basic report built up in BI Publisher from Oracle forms button pressed trigger.

All the publisher services are running properly.

PublisherServices.PNG

Here I have setup the properties of reports

ReportProperties.PNG

Here is the code that I have on button pressed trigger.

DECLARE

   repid REPORT\_OBJECT;

   v\_rep      VARCHAR2(256);

   rep\_status VARCHAR2(256);      

   ex ora\_java.jobject;

   ex\_msg VARCHAR2(255);

BEGIN

   repid := find\_report\_object ('BIREP');

   SET\_REPORT\_OBJECT\_PROPERTY (repid, BIP\_USER, 'weblogic');

   SET\_REPORT\_OBJECT\_PROPERTY (repid, BIP\_PASSWORD, 'Usman786');

   v\_rep := RUN\_REPORT\_OBJECT(repid);

   rep\_status := report\_object\_status(v\_rep);      

EXCEPTION

WHEN ora_java.exception_thrown THEN

   ex := Exception\_.new(ora\_java.last\_exception);

   BEGIN

          ex\_msg := Exception\_.toString(ex);

          MESSAGE('Java Exception occurred: ' || ex\_msg);

          ora\_java.clear\_exception;

   EXCEPTION

   WHEN ora\_java.java\_error THEN

          MESSAGE('Unable to call out to Java, ' || ora\_java.last\_error);

   END;

END;

Report shows successfully running status but no output.

The report status is in running mode.

AllRunning.PNG

My question is.

Why this is in running mode for a long time, the code I got from an Oracle document, how can I run that out put directly in new tab of browser?

This post has been answered by Michael Ferrante-Oracle on Nov 23 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2016
Added on Nov 23 2016
1 comment
551 views