OAUG BI Publisher SIG

First off, if you are not familiar with the term SIG, it stands for Special Interest Group.  OAUG facilitates a number of SIGs to bring users together that share common or industries concerning certain Oracle products.

Unfortunately, the BI Publisher SIG has been offline for a number of years and has not been given the attention it needs to be a useful resource for members of OAUG.  Well… I’m getting the band back together and (more...)

My lucky find for ORA-01720: Grant Option Does Not Exist.

Strangest thing happened the other day during a customer upgrade.  Our automated scripts were in the process of creating a view and I received the error:

ORA-01720: Grant Option Does Not Exist.

OK…..  I get it…  BUT…. I didn’t even execute a GRANT statement!?  I was just executing a CREATE OR REPLACE VIEW…. what gives?

Doing some searching online, I didn’t find too much that fit my issue.  Everyone was getting (more...)

Printing Attachments in Oracle 12.2: How does it Stack Up?

With the release of EBS 12.2, Oracle is making the claim that they have improved the attachment printing process. After reviewing the integration, I completely disagree; they have not given users a better solution.  No matter how you slice it, Oracle EBS customers are no further ahead with (more...)

Forms Personalization: Calculating an Item Value

I received the following comment recently on an older Forms Personalization post:

how can i get result from the following equation through personalization

i want to know what is the syntax and what is the required steps to get the result automatically



Error! FRM-92095: Oracle JInitiator version too low. Please install version or higher

Brought a couple new PCs up recently and ran into the subject nasty error when attempting to access EBS.  We’ve run into this before and we usually get it worked out one way or another.  This time proved to be a bit challenging for some reason…  Thought I (more...)

Bursting EBS Documents in a Single Step Available in R12.2?

I came across Bug 12927519 on Metalink today that suggests that EBS R12.2 may include an enhancement to allow for bursting of BI Publisher/XML Publisher documents in one step (it says it was ‘fixed in product version’)!  I do not see anything about in the 12.2 Release Content Documents, but that’s nothing new.

Currently, to burst you have to run 2 concurrent requests.  The actual concurrent request to generate your output and then a second concurrent request to actually do the bursting (XML Publisher Report Bursting Program).  This is not (more...)

BI Publisher 11g Trial Edition – Really Easy Installation!

It’s been around for a month or so, but I just got around to checking out the new BI Publisher Enterprise 11g Trial Edition that the BIP folks posted about in May.

When BIP 11g hit the streets the installation was huge.  Unlike the small and easy to install BIP Enterprise 10g, 11g was quite a chore to install.  Sure it was prettier than 11g and gave a lot more functionality as it’s now integrated with OBIEE, but it wasn’t very practical if you just wanted to run it on your laptop or desktop for development or demo (but (more...)

Show Report: 6th Annual Oracle Maintenance Summit

I spent last week in Nashville at the 6th Annual Maintenance Summit hosted by VIZIYA.  A really well done conference supporting Oracle EBS, JD Edwards and PeopleSoft customers that have implemented or are implementing the various maintenance modules of their respective applications.  I spent the majority of my time in our booth demonstrating the latest and greatest features of the AventX Attachment Printer (luckily I was able to spend some time in the (more...)

True Excel Templates for EBS – An Introduction

Excel based output from BI Publisher has been around for some time, however it wasn’t really Excel data (essentially XHTML that Excel knows how to read) and was created with a RTF template.  Mid-2011, Oracle released a patch for EBS that would allow what they labeled as ‘True’ Excel output.  It is considered ‘True’ in that it creates a binary Excel file and allows you to create the template in Excel.

As an (more...)