X

An Oracle blog about BI Publisher

Where are all these reports coming from?

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:



 











































































































R12 Executable TypeTotal
FlexRpt13
Host21
Immediate37
Java Concurrent Program455
Java Stored Procedure5
Multi Language Function1
Oracle Reports3060
PL/SQL Stored Procedure4552
Perl Concurrent Program1
Request Set Stage Function1
SQL*Loader69
SQL*Plus421
SQL*Report26
Spawned969
 
         





























































































11i Executable TypeTotal
FlexRpt13
Host16
Immediate36
Java Concurrent Program141
Java Stored Procedure5
Multi Language Function1
Oracle Reports2874
PL/SQL Stored Procedure3404
Perl Concurrent Program1
Request Set Stage Function1
SQL*Loader57
SQL*Plus388
SQL*Report26
Spawned807


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.





































































































R12 Executable TypeTotal
FlexRpt5
Host21
Immediate34
Java Concurrent Program423
Java Stored Procedure3
Multi Language Function1
Oracle Reports2371
PL/SQL Stored Procedure3783
Perl Concurrent Program1
Request Set Stage Function1
SQL*Loader62
SQL*Plus298
Spawned852
        























































































11i Executable TypeTotal
FlexRpt5
Host16
Immediate33
Java Concurrent Program124
Java Stored Procedure3
Multi Language Function1
Oracle Reports2574
PL/SQL Stored Procedure2911
Perl Concurrent Program1
Request Set Stage Function1
SQL*Loader51
SQL*Plus335
Spawned748


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!



 

Join the discussion

Comments ( 1 )
  • all lymph nodes Tuesday, October 12, 2010
    for it to be safe to tell Im not really that sure if you will like it
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.