Oracle Report Builder Library Error: REP-0756 Warning Unable to find PLSQL library Solution

/*----------------------------------------------------------------
Error 1: REP-0756 Warning Unable to find PLSQL library 'fadolif'.

Error 2: REP-0756 Warning Unable to find PLSQL library 'inv'.
----------------------------------------------------------------*/



step 1: Check on Report Builder Setup Path:

C:\DevSuiteHome_2\reports\templates

Error Message PLL file available or not.


Step 2: If Error File not available than download specific required .PLL file from following FTP server path:

FTP Path: AU_TOP pl/sql

/u02/applvat/vat/apps/apps_st/appl/au/12.0.0/plsql


Then I transferred that file to C:\DevSuiteHome_2\reports\templates

It's Work Fine

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.