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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

FRM-41223 BI Publisher Integration Error (forms 12.2.1.4 Analytics Publisher 6.4)

George_sApr 14 2022

Hi all,
I have a 'clean' install of weblogic 12.2.1.4 + Forms-Reports 12.2.1.4 and Publisher from analytics 6.4)
I have configured Forms-Reports and all works as expected. I have tied for the First time to install and use (or lets say, learn to use) BI Publisher as well.
Installation and configuration seems to be ok to me, as i can access Publisher and create a simple report based on a select on a simple table.
I am trying to integrate and call BIP reports from oracle forms. I have followed a few examples, but found the most useful to be from Doc ID 2235962.1
( https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=339443367985634&parent=EXTERNAL_SEARCH&sourceId=BULLETIN&id=2235962.1&_afrWindowMode=0&_adf.ctrl-state=1cq64j9hwa_441#aref_section34 )
Of course i set up the parameters to my scenario and whatever i do, when i issue
v_rep := RUN_REPORT_OBJECT(repid);
it always returns back with v_rep being NULL and of course execution stops.
I can call the report using http://server:9502/xmlpserver/~weblogic/Drafts/client_info_report.xdo
so at least i know my simple test report works (and i see the results - a simple 2 column table with data)
one thing i noticed is that i cannot see an entry for it being run in the job history of Publisher
I have searched the net for answers and i have gone down the document Doc ID 2228686.1 rabbit hole, which of course sent me to Doc ID 1463096.1 and i have stoped there.
So...i have tried to also create a new JVM configuration and add it to my named config i call forms with. I don't know if this what i am not doing right, or where i am failing.
Please note that my Publisher knowledge is at its infant stage ;)
Can you give any ideas ?
Thank you ,
George

Comments
Post Details
Added on Apr 14 2022
2 comments
398 views