Query to get/find the Package/Procedure/Content View associated with a WebADI Integrator

 

--Query to get Package/procedure used with WebADI Interface

SELECT ba.attribute2 interface_pkg_proc
      ,bit.user_name
      ,ba.*
 FROM apps.bne_attributes ba,
      apps.bne_param_lists_b bplb,
      apps.bne_interfaces_b bib,
      apps.bne_integrators_tl bit
WHERE bib.upload_param_list_code = bplb.param_list_code
  AND bib.integrator_code = bit.integrator_code
  AND ba.attribute_code = bplb.attribute_code
  AND bit.user_name = <integrator_name>; 

 
--Query to get the Content/View Name for the WebADI
SELECT bct.*
  FROM apps.bne_contents_tl bct,
       apps.bne_contents_b bcb,
       apps.bne_integrators_tl bit
 WHERE bit.integrator_code = bcb.integrator_code
   AND bcb.content_code = bct.content_code
   AND bit.user_name = <integrator_name>; 

 

 

How to check if a patch is applied in Oracle E Business Suite.

How to check if a patch is applied in Oracle E Business Suite.

For R12.2.X eBS version use the below query/script to get the patch information:

SELECT AD_PATCH.IS_PATCH_APPLIED('$release’,'$appltop_id','$patch_no','$language') patch_info
FROM dual;

Below example for single app tier installations:-

SELECT ad_patch.is_patch_applied ('R12', -1,8246403) patch_info
FROM dual;

Expected results as follows:
EXPLICIT = Applied
NOT APPLIED = Not applied Or Aborted.

For 11i or R12.1.X eBS version use the below query/script to get the patch information:-

SELECT *
  FROM ad_bugs
 WHERE bug_number = '<patch_number>'; --8246403

SELECT *
  FROM ad_applied_patches
 WHERE patch_name= '<patch_number>'; --8246403

SELECT aap.applied_patch_id,
       aap.patch_name,
       aap.patch_type,
       apd.driver_file_name,
       apd.orig_patch_name,
       apd.creation_date,
       apd.platform,
       apd.source_code,
       apd.creation_date,
       apd.file_size,
       apd.merged_driver_flag,
       apd.merge_date
  FROM AD_APPLIED_PATCHES aap
      ,AD_PATCH_DRIVERS apd
 WHERE aap.APPLIED_PATCH_ID = apd.APPLIED_PATCH_ID
   AND aap.PATCH_NAME = '<patch_number>'; --8246403