SQL To check Bundle Status
By Acshorten-Oracle on Nov 23, 2009
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,
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.