SQL To check Bundle Status

I am currently updating the Software Configuration Management series of documents for the latest practices and facilities in the product. One of the features getting attention is the Bundling facility provided for the Advanced Configuration Objects.

Without going into too much detail, the Bundling facility allows "solutions" based upon Advanced Configuration Objects to be exported into an XML file so that they can be transported from site to site easily.

To sum it up, say you are a develoepr who develops a whole solution using the Advanced Configuuration Objects features and would like to share it with others (including a number of sites). You can attach the relevant Advanced Configuration Objects that make up your solution (Portals, Zones, Messages, Business Objects, Business Services, UI maps etc) and then export the definitions in XML format. That XML file can be then imported in the target environment and that installs the solution.

One of the things that is possible is to assess the status of a particular bundle that is being exported and imported using a query against the database (the online displays this information within the zones but you have to log online to see this information). I have compiled a query that will report basic status information.

Here is the SQL:

SELECT b.bndl_id AS "Bundle Id",
b.ext_reference_id AS "External Reference",
t.descr AS "Bundle Type",
s.descr AS "Status"
FROM F1_BNDL B,
F1_BUS_OBJ_STATUS_L S,
CI_LOOKUP_VAL_L T
WHERE t.field_name = 'BNDL_TYPE_FLG'
AND t.field_value = b.bndl_type_flg
AND t.language_cd = 'ENG'
AND s.language_cd = t.language_cd
AND s.bo_status_cd = b.bo_status_cd
AND TRIM(S.bus_obj_cd) = DECODE ( b.bus_obj_cd, 'F1IM', 'F1-BundleImport', 'F1-BundleExport')
ORDER BY 2;

You can add columns to make the query display more information as needed.

Comments:

At last, I found your article again. You have few useful tips for my school project. Now, I won't forget to bookmark it. :)

Posted by useful tips on January 19, 2010 at 11:04 AM EST #

finally, I could find this article once again. You have few useful tips for my school project. This time, I won't forget to bookmark it. :)

Posted by get tips on January 19, 2010 at 12:32 PM EST #

this table dose not exist F1_BUS_OBJ_STATUS_L S

Posted by Rami on April 19, 2010 at 11:39 AM EST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Anthony Shorten
Hi, I am Anthony Shorten, I am the Principal Product Manager for the Oracle Utilities Application Framework. I have been working for over 20+ years in the IT Business and am the author of many a technical whitepaper, manual and training material. I am one of the product managers working on strategy and designs for the next generation of the technology used for the Utilities and Tax markets. This blog is provided to announce new features, document tips and techniques and also outline features of the Oracle Utilities Application Framework based products. These products include Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management, Oracle Utilities Mobile Workforce Management and Oracle Enterprise Taxation and Policy Management. I am the product manager for the Management Pack for these products.

Search

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