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...)

Oracle EBS 12.2 Online Patching – First Glance

Anyone that’s been following the release of 12.2 knows that Online Patching is the BIG feature that everyone is talking about.  I’ve had the opportunity to utilize this new functionality and it’s been quite interesting.  Online Patching is based on the Oracle Database 11.2 feature called (more...)

Bursting in One Step from R12.2: Users in the Dark on Request Status

In the latest release of EBS R12.2, Oracle has introduced the ability to burst in a single concurrent request. Although we predicted this was coming, we weren’t sure what it would mean for users and support admins. What we have found is that the new feature actually creates (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
K_LINES.LINE_VALUE = K_HEADER.K_VALUE/K_HEADER.PRIME_K_NUMBER

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

thanx

(more...)

Error! FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 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 12.2.0.20X’)!  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...)