Dynamic Logo
Chaining in BI Publisher Report
Chaining in BI Publisher Report
Need to create a
formula column in report builder for getting the Logo image name for
appropriate name based on your condition.
formula column in report builder for getting the Logo image name for
appropriate name based on your condition.
——————————————————————-
function
CF_LOGO return Char is
CF_LOGO return Char is
L_logo
varchar2(30);
varchar2(30);
begin
SELECT Tag
into L_logo
FROM FND_LOOKUP_VALUES
WHERE
1 = 1
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))
(START_DATE_ACTIVE) AND TRUNC (NVL (END_DATE_ACTIVE,SYSDATE))
AND upper(MEANING) = :P_ORG_ID || ‘-‘ ||
upper(:PAY_GROUP_LOOKUP_CODE);
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
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
on the Dummy Image — Size — Alt Text
Place the
following Text : “url:{concat(‘${OA_MEDIA}’,’/’,CF_LOGO)}”
following Text : “url:{concat(‘${OA_MEDIA}’,’/’,CF_LOGO)}”
Need to place the the
Logo files in the OA_MEDIA top before running the Report.
Recommended Posts
