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 Type Total
FlexRpt 13
Host 21
Immediate 37
Java Concurrent Program 455
Java Stored Procedure 5
Multi Language Function 1
Oracle Reports 3060
PL/SQL Stored Procedure 4552
Perl Concurrent Program 1
Request Set Stage Function 1
SQL*Loader 69
SQL*Plus 421
SQL*Report 26
Spawned 969
 
         














































11i Executable Type Total
FlexRpt 13
Host 16
Immediate 36
Java Concurrent Program 141
Java Stored Procedure 5
Multi Language Function 1
Oracle Reports 2874
PL/SQL Stored Procedure 3404
Perl Concurrent Program 1
Request Set Stage Function 1
SQL*Loader 57
SQL*Plus 388
SQL*Report 26
Spawned 807

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 Type Total
FlexRpt 5
Host 21
Immediate 34
Java Concurrent Program 423
Java Stored Procedure 3
Multi Language Function 1
Oracle Reports 2371
PL/SQL Stored Procedure 3783
Perl Concurrent Program 1
Request Set Stage Function 1
SQL*Loader 62
SQL*Plus 298
Spawned 852
        











































11i Executable Type Total
FlexRpt 5
Host 16
Immediate 33
Java Concurrent Program 124
Java Stored Procedure 3
Multi Language Function 1
Oracle Reports 2574
PL/SQL Stored Procedure 2911
Perl Concurrent Program 1
Request Set Stage Function 1
SQL*Loader 51
SQL*Plus 335
Spawned 748

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!


 

Comments:

for it to be safe to tell Im not really that sure if you will like it

Posted by all lymph nodes on October 12, 2010 at 08:25 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today