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.