Sunday, 8 July 2018

Oracle Web ADI Integrator - Layout - Mapping - Content Query

-----------Integrtor-----------
select integrator_code, application_short_name
  from apps.bne_integrators_vl  bnv
      ,apps.fnd_application_vl  fav
 where bnv.user_name like 'XX Patty Cash AP Invoice%'
   and fav.application_id = bnv.application_id;


---------layout------------
select layout_code,user_name
  from apps.bne_layouts_vl
 where user_name like 'XX Patty Cash AP Invoice%'
 ;   -- XXPATTYCASHAPINVOICELAYOUT


---------Mapping---------
 select mapping_code
  from apps.bne_mappings_vl
 where integrator_code = 'XXAPINV4_XINTG';

-----------Content -------------
 select content_code
   from apps.bne_contents_vl
  where integrator_code = 'XXAPINV4_XINTG';

Oracle Web ADI Interface Column Datatype Update Query


After Web ADI Interface has been defined we can not change Attribute datatype which is extracted from PLSQL procedure. Sometime required to update Interface attribute datatype from backend. Following Query is useful.

-----Data Type----------
Number - 1,
varchar - 2,
date   - 3

-------Query 1----------

update bne_interface_cols_b
set
data_type=3
where
interface_col_name like 'P_ATTRIBUTE_LINE4' and INTERFACE_CODE='XXAPINVCREATE_XINTG_INTF1';


--------Query2---------------

update bne_attributes
set ATTRIBUTE2='VARCHAR2'
where
ATTRIBUTE1 like 'P_SEGMENT%' and
ATTRIBUTE_CODE like 'XXAPINV3_XINTG_UPL1%'
;




Many case following solution not work, so you have to find another workaround.

Oracle Web ADI Error: Web ADI Invalid Integrator Key

Error: Web ADi Invalid Integrator Key


For Specific user level, we have to set the following profile option 'YES', If user not having System Administrator Responsibility

Solution: 'BNE Allow No Security Rule' as Yes at the User level