Sunday, 11 October 2015

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.




11 comments:

  1. It's interesting to read blog about punchout cxml.
    Punchout CXML

    ReplyDelete