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...
Posted under Oracle on Tuesday, 13 April 2010 by admin
IBY_FD_EXTRACT_EXT_PUB is a standard PL/SQL package that is used to extend (i.e. add additional tags to) the XML file generated during a R12 Oracle Payments ‘Payment Process Request’:This XML file is then used as the data source for the XML Publisher cheque or electronic file...
Posted under Oracle on Saturday, 10 April 2010 by admin
Here’s a quick reminder of the steps required to setup GL ledger and segment value security for the seeded Discoverer General Ledger Business Area:Set the profile option ‘FII: GL BIS Discoverer access’ for all GL responsibilities that will run Discoverer workbooks.Ensure that the...
Posted under Oracle on Saturday, 3 April 2010 by admin
As we move forward with our 'adoption' of BI / XML Publisher here, I've been thinking more about what we really need to get up and running quickly.It is simple really ;-) At the top of our 'wish list' is:- A comprehensive library of reusable templatesForget about those pesky XSL-FO ones, we need...
Posted under Oracle on Friday, 2 April 2010 by admin
As we move forward with our 'adoption' of BI / XML Publisher here, I've been thinking more about what we really need to get up and running quickly.It is simple really ;-) At the top of our 'wish list' is:- A comprehensive library of reusable templatesForget about those pesky XSL-FO ones, we need...
Posted under Oracle on Wednesday, 31 March 2010 by admin
OBI EE 10.1.3.4 has been released today on OTN.One of the areas of new functionality that I am very interested in is the ability to migrate certain components of Discoverer metadata to BI Server / Answers. The New Features documentation states:Release 10.1.3.4 includes a utility to accelerate the...