Posted under Oracle on Thursday, 17 February 2011 by admin
MikeM asked:"How to pad an eText template with blank lines so the text file entries end up on the correct position on the stationary?e.g. There are 25 lines available on the stationary for invoices but only 5 invoices to be paid on this payment - what steps should be taken to insert 20 blank lines...
Posted under Oracle on Monday, 13 December 2010 by admin
Does this sound familiar?Connecting to Discoverer Administrator or Desktop as an apps user for the first time on a a project and you get the error message:"Invalid Username and Password"You have the oracle apps user checkbox ticked and have validated that both the username and password are correct...
Posted under Oracle on Sunday, 29 August 2010 by admin
It surprises me how few people are aware of the generic loader (XDOLoader) for XML / BI Publisher (BIP) files.Like FNDLOAD for AOL / XML Publisher metadata and WFLOAD for Workflow Item Types, XDOLoader is is a command line utility that allows you to migrate the BIP files between environments. The...
Posted under Oracle on Sunday, 29 August 2010 by admin
As promised to Chetan... I stumbled across a frustrating incompatibility whilst installing OBI EE 10.1.3.3.3 on a Windows machine earlier.OBI EE requires Version 2 of MS .NET Framework.During OBI EE installation, it also launches the installer for Microsoft .NET Framework V2.However, if you...
Posted under Oracle on Tuesday, 3 August 2010 by admin
I read today that Error correction support ended for Oracle Workflow last week. (http://www.oracle.com/technology/products/ias/workflow/workflow_sod.html)I've been on a number of projects that attempted to use workflow technology in unique ways.I remember 7 or 8 years ago and before the Oracle...
Posted under Oracle on Saturday, 26 June 2010 by admin
In the first 2 blogs in this series, we completed:Point 1)- Define the fixed position Check file required by the third party software ANDPoint 2)- Map our required text file against the standard Oracle Payments Disbursement XML file.OK - let's get to the meat of the solution.... building the...
Posted under Oracle on Tuesday, 22 June 2010 by admin
Not much changes in Birmingham.It seems like an eternity ago that I was at university there - but after only a couple of hours and a fine Balti in a BYOB restaurant, I felt like I'd never left.Anyway, enough of my weekend! Let's get back to XSL-TEXT templates.Excluding XSL-FO, there are 3...
Posted under Oracle on Monday, 19 April 2010 by admin
Just a quick post today.I've had a few emails asking how we test eText templates.Rather than using the Word Plug in to preview the result, you test eText templates using the 'Template Viewer' included with the BIP desktop toolkit.From the Windows Start menu, click on : All Programs, Oracle BI...
Posted under Oracle on Thursday, 15 April 2010 by admin
Spent an interesting day at a potential customer recently discussing: - The lessons that I've learnt on recent Oracle BI projects- How we could apply these lessons to develop an optimum OBIEE rollout strategy. In no particular order, some of the key lessons that I highlighted and discussed in...
Posted under Oracle on Wednesday, 14 April 2010 by admin
Spent an interesting day at a potential customer recently discussing: - The lessons that I've learnt on recent Oracle BI projects- How we could apply these lessons to develop an optimum OBIEE rollout strategy. In no particular order, some of the key lessons that I highlighted and discussed in...