Dynamic Logo Chaining in BI Publisher Report

Dynamic Logo
Chaining in BI Publisher Report
Need to Created a Lookup where we can map the required Logo image names

 Need to create a
formula column in report builder for getting the Logo image name for
appropriate name based on your condition.  
——————————————————————-
function
CF_LOGO return Char is
L_logo
varchar2(30);
begin
               
 SELECT Tag
    into L_logo
  FROM FND_LOOKUP_VALUES
 WHERE    
1 = 1
       AND lookup_type = ‘XXX_PAYGROUP_LOGO_MAP’
       and nvl(ENABLED_FLAG,’N’) = ‘Y’
       AND TRUNC (SYSDATE) BETWEEN TRUNC
(START_DATE_ACTIVE) AND TRUNC (NVL (END_DATE_ACTIVE,SYSDATE))
       AND upper(MEANING) = :P_ORG_ID || ‘-‘ ||
upper(:PAY_GROUP_LOOKUP_CODE);
      
       return (L_logo);
     EXCEPTION
                WHEN NO_DATA_FOUND THEN
                 
L_logo := ‘LOGO-XXX.gif’;
                 
RETURN (L_logo);          
end;
——————————————————————-
Need to place a Dummy
image in the rtf template.  Give the
Formula column name in the below mentioned navigation
Navigation : Right Click
on the Dummy Image — Size — Alt Text
Place the
following Text :  “url:{concat(‘${OA_MEDIA}’,’/’,CF_LOGO)}”

Need to place the the
Logo files in the OA_MEDIA top before running the Report.

  • October 12, 2015 | 22 views