Where are all these reports coming from?
By Tim Dexter-Oracle on Mar 14, 2008
Last time I wrote I was getting numbers on layout templates, I have now been looking at concurrent programs, my alarm at there being 9631 programs was realized - there really are that many in R12. What are they all? In Fusion BIP is going to be responsible for the 'reporting' programs, the concurrent manager, the 'processing' program. To you dear user, from a UI persepective no changes - a common, if dynamic interface to submit jobs. The need to try and characterize the programs is therefore important.
Here's how they break out:
Still more than 3000 Oracle Reports based programs? I checked our 11i instance (numbers to the right) the numbers of OReports had risen in R12?
I then checked the enabled flag was set to 'Y' - that Concurrent Program form will not let you delete a CP only disable it. Running again with the flag set.
Ahhh thats better ... I thought we had removed some reports, nearly 200 is not bad. Come Fusion they will have all been converted!
So far I have been referring to Oracle Reports because I know that nearly all of them will produce some humanly readable output. But Im after the total number and type of 'reports' versus 'processes' e.g. invoice import. I guess I can lump the SQL*Plus CPs in with the reports. The big question is how many of those PLSQL procedures are generating report output - not that many Ill be bound. RXi reports use PLSQL to create the query but there is a 'Spawned' C program that actually generates the output but the plsql is related to reporting. Its tough to tell exactly, there are no nice flags saying 'Process' rather than 'Report' - thats gonna change in Fusion. Of those 3783 PLSQL objects lets guess at 300 ish. So of the 7855 CPs around 3000 are Report related thats about 38% of the total. I could be way off on the reporting plsql but there is no way to tell for sure without opening the plsql.
That's 3000 seeded objects we have to migrate to the Fusion BIP stack, of which, whenever I poll you folks out there on how many of them you use I get answers ranging from none to 100 - of course, you all use a different set of 100 so we need to support the migration for all of them anyway ... joy!