Oracle Report using profile security Apps r12

To Initialize Apps in Oracle Report: BELOW 3 steps mandatory(3.1 to 3.3) and use the secured tables in query.
3.1. Before report trigger
 
  srw.USER_EXIT ('FND SRWINIT');
fnd_global.apps_initialize(FND_PROFILE.VALUE('USER_ID'),FND_PROFILE.VALUE('RESP_ID'),FND_PROFILE.VALUE('RESP_APPL_ID'));
  mo_global.init ('S');

3.2. After Report Trigger

SRW.USER_EXIT('FND SRWEXIT');

3.3 Add user parameter

P_CONC_REQUEST_ID  datatype - Number, Width - 200

Checkbox in xml publisher report in Oracle Apps R12

Open your BI Publisher folder its 32 or 64 bit, check both if available.

C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config

C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config

Copy, paste and  rename file xdo example.cfg as xdo.cfg in the same folder.

do below 2 modifications for xdo.cfg file .

1. Add/update property under <properties>

<property name="rtf-checkbox-glyph">Wingdings;254;168</property>

<!--254 for checked box, 168 unchecked empty, google it for Wingdings 254 253 168 -->

2. check the fonts path

by default it was c:/WINT… change it to ur pc correct ex: C:\Windows\Fonts\wingding.ttf

3.

Enable Developer ribbon tab in Word.

Right click ribbon tab🡪 Customize 🡪 Enable the checkbox for Developer.

Insert checkbox from the Legacy Forms 🡪 Checkbox.

Add Condition in the checkbox as per your requirement ex:☐

It will work only on pdf as per oracle document.

Run the xml report output in pdf and check.

If condition true it will be checked, else empty.

4.

Deploying to Server:

Download file from https://github.com/IamDH4/ttf-wps-fonts/blob/master/wingding.ttf

Check in the Word template also having same font 🡪 optional.

Under Administration 🡪 configuration

Text: Wingdings;0254;0168