{"id":813,"date":"2015-10-28T13:51:34","date_gmt":"2015-10-28T12:51:34","guid":{"rendered":"http:\/\/danielsitblog.wordpress.com\/?p=77"},"modified":"2017-09-11T15:12:51","modified_gmt":"2017-09-11T13:12:51","slug":"oracle-forms-12c-bi-publisher-integration-2","status":"publish","type":"post","link":"https:\/\/pitss.org\/de\/oracle-forms-12c-bi-publisher-integration-2\/","title":{"rendered":"Oracle Forms 12c BI Publisher Integration"},"content":{"rendered":"<p>Today I started to have a look at the possibilities of integrating the BI Publisher in Forms 12c.<\/p>\n<p><a href=\"https:\/\/danielsitblog.files.wordpress.com\/2015\/10\/21.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-82\" src=\"https:\/\/danielsitblog.files.wordpress.com\/2015\/10\/21.png?w=676\" alt=\"2\" \/><\/a><\/p>\n<p>Sadly I didn&#8217;t find anything regarding this topic in the online documentation &#8211; so I created a report object and had a look at the properties.<\/p>\n<p>We found out, that there are several new properties in the report object. So I created a forms module with a simple button and tried to call a BI-Publisher Server. As expected, my first try was not successful &#8211; I got an &#8220;FRM-41223: BI Publisher integration error&#8221;. So I had a look at the online help under &#8220;SET_REPORT_OBJECT_PROPERTY&#8221; to see if there are any new properties &#8211; and yes there are quite a lot new BI-Properties:<\/p>\n<ul>\n<li>BIP_SSL_CONNECTION: Indicates whether or not SSL is mandatory or optional.<\/li>\n<li>BIP_SERVICE_LOCATION: The URL to the Oracle BI_Publisher server Web Services WSDL for ScheduleServices.<\/li>\n<li>BIP_REPORT_PATH: The absolute path to the report to be run (on the BI_Publisher server).<\/li>\n<li>BIP_REPORT_LOCALE: Preferred report locale.<\/li>\n<li>BIP_REPORT_FORMAT: Desired report output format.<\/li>\n<li>BIP_REPORT_TEMPLATE: A template registered with the report specified in BIP_REPORT_PATH. It is common practice to provide this property along with report name\/path but BI-Publisher gives the option of setting a default value when creating\/editing a report, therefore this is an optional property in Forms. Value is used and validated by BI-Publisher.<\/li>\n<li>BIP_REPORT_PARAMETERS: A list of name\/value pairs separated by a space.<\/li>\n<li>BIP_USER: The BI-Publisher username required to access the Web Service. This value cannot be set in the Property Palette.<\/li>\n<li>BIP_PASSWORD: The BI-Publisher user password required to access the Web Service. This value cannot be set in the Property Palette.<\/li>\n<li>FTP_SERVER: FTP server name as configured in BI-Publisher.<\/li>\n<li>FTP_SECURED: Determine if FTP will be secured (i.e. SFTP) or unsecure.<\/li>\n<li>FTP_USER: FTP server username.<\/li>\n<li>FTP_PASSWORD: FTP server user password.<\/li>\n<li>FTP_FILE_NAME: Output file name to be stored on FTP server.<\/li>\n<li>FAX_NUMBER: Fax number. Format as required by your server configuration.<\/li>\n<li>FAX_SERVER: Name of Fax server as configured in BI-Publisher.<\/li>\n<li>MAIL_TO: The mailto email address.<\/li>\n<li>MAIL_FROM: The mailfrom email address.<\/li>\n<li>MAIL_CC: The mailcc email address.<\/li>\n<li>MAIL_BCC: The mailbcc email address.<\/li>\n<li>MAIL_REPLYTO: The replyto email address.<\/li>\n<li>MAIL_SUBJECT: The email subject string.<\/li>\n<li>MAIL_BODY: The email body string.<\/li>\n<li>MAIL_SERVER: Name of the email server (SMTP) configured in BI-Publsher.<\/li>\n<li>LOCAL_FILE_NAME: Absolute path and filename of the output file.<\/li>\n<li>PRINT_COPIES: Number of copies to print.<\/li>\n<li>PRINT_ORIENTATION: Page orientation.<\/li>\n<li>PRINT_RANGE: Page range to print.<\/li>\n<li>PRINT_SIDE: Enable two-sided printing. This setting will be ignored if the target printer does not support two-sided printing<\/li>\n<li>PRINT_TRAY: The tray number. If you do not specify this option, the default media of the target printer will be used. It will be ignored if the target printer doesn&#8217;t support the media option.<\/li>\n<li>PRINTER_NAME: Printer name on the BI-Publisher host to send the documents to.<\/li>\n<li>WEBDAV_AUTH_TYPE: The authentication type.<\/li>\n<li>WEBDAV_USER: The WebDAV username.<\/li>\n<li>WEBDAV_PASSWORD: The WebDAV user password.<\/li>\n<li>WEBDAV_FILE_NAME: The remote filename.<\/li>\n<li>WEBDAV_SERVER: The WebDAV server name.<\/li>\n<\/ul>\n<p>After setting the properties BIP_USER &amp; BIP_PASSWORD I was able to run the BI-Report:<a href=\"https:\/\/danielsitblog.files.wordpress.com\/2015\/10\/31.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-84\" src=\"https:\/\/danielsitblog.files.wordpress.com\/2015\/10\/31.png?w=676\" alt=\"3\" \/><\/a><\/p>\n<p>  <a rel=\"nofollow\" href=\"http:\/\/feeds.wordpress.com\/1.0\/gocomments\/danielsitblog.wordpress.com\/77\/\"><img decoding=\"async\" alt=\"\" border=\"0\" src=\"http:\/\/feeds.wordpress.com\/1.0\/comments\/danielsitblog.wordpress.com\/77\/\" \/><\/a> <img loading=\"lazy\" decoding=\"async\" alt=\"\" border=\"0\" src=\"https:\/\/pixel.wp.com\/b.gif?host=danielsitblog.wordpress.com&#038;blog=92824060&#038;post=77&#038;subd=danielsitblog&#038;ref=&#038;feed=1\" width=\"1\" height=\"1\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today I started to have a look at the possibilities of integrating the BI Publisher in Forms 12c. Sadly I didn&rsquo;t find anything regarding this topic in the online documentation &ndash; so I created a report object and had a look at the properties. We found out, that there are several new properties in the [&hellip;]<img loading=\"lazy\" decoding=\"async\" alt=\"\" border=\"0\" src=\"https:\/\/pixel.wp.com\/b.gif?host=danielsitblog.wordpress.com&amp;blog=92824060&amp;post=77&amp;subd=danielsitblog&amp;ref=&amp;feed=1\" width=\"1\" height=\"1\" \/><\/p>\n","protected":false},"author":47,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[147,153,154,98,139,155,81],"tags":[],"class_list":["post-813","post","type-post","status-publish","format-standard","hentry","category-12c","category-bi-publisher","category-frm-41223","category-oracle-forms","category-oracle-forms-12c","category-oracle-reports","category-tech-blog"],"_links":{"self":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/comments?post=813"}],"version-history":[{"count":1,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/813\/revisions"}],"predecessor-version":[{"id":16774,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/813\/revisions\/16774"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/media?parent=813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/categories?post=813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/tags?post=813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}