Skip to main content

Barcode Report in XML Publisher

XML Publisher 5.6 has a new tab: Administration. This replaces the xdo.cfg configuration file. Now fonts can be uploaded and stored in the database instead of stored on the file system.

Under the Administration tab are sub tabs: Configuration, Font Mappings and Font Files and Currencies.


Download 3of9-barcode font.
To install a font requires only a few steps.

  • Font Family is the exact same name you see in Word under Fonts.
  • If you don't use the same name the font will not be picked up at run time.



Log in as XML Publisher Administrator.





Navigate to Administration->Font Files->Create Font File



Fields are Font Name and File.





Fields are Font Name and File.
For Font Name choose any descriptive name like below.






Navigate to Font Mappings->Create Font Mapping Set


Mapping name is the name you will give to a set of fonts.



Mapping code is the internal name you will give to this set.

Font Family is the exact same name you see in Word under Fonts.


Navigate to Configuration General-> FO Processing->Font Mapping Set. 


In RTF 

Select the font and upload your layout.



Comments

Post a Comment

Popular posts from this blog

LDT Commands in Oracle Apps

 Oracle Applications (Oracle E-Business Suite) use Loader Data files (LDT files) for migrating application configurations and data between instances. What are LDT Files? LDT files are plain text files used by the FNDLOAD utility in Oracle E-Business Suite to upload or download data from the database. They are commonly used for migrating setups, such as concurrent programs, value sets, and lookups, across different environments. LDT Commands: 1.        Download Data to LDT File FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct output_file.ldt FND_PROGRAM APPLICATION_SHORT_NAME="Application_Short_Name" CONCURRENT_PROGRAM_NAME="Program_Name" 2.        Upload Data from LDT File FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct input_file.ldt Key Parameters apps/apps_pwd : The username and password for the Oracle Apps database. 0 Y...
Post a Comment
Read more

API to Create & Update Price Adjustment and Order Lines

Important Tables: select header_id from oe_order_headers_all; select line_id from oe_order_lines_all; select list_header_id from qp_list_headers_all; select list_line_id from qp_list_lines; CREATE OR REPLACE PROCEDURE apps.xxapply_discount (p_header_id number) IS    v_api_version_number           number := 1;    v_return_status                varchar2 (2000);    v_msg_count                    number;    v_msg_data                     varchar2 (2000);    -- in variables --    v_header_rec                   oe_order_pub.header_rec_type;    v_line_tbl                     oe_order_pub.line_tbl_type;    v_action_request_tbl   ...
Post a Comment
Read more

Oracle BI Publisher - Leading zeros truncated for excel reports - format numbers as text

When you want to display some data which has leading zeros in EXCEL output you will not get the desired output. But in PDF it will come as what you are expecting. This is not with the issue of your data. This is due to the unique nature of EXCEL cell format. When you are trying to put a text data in a cell without making any change to cell format it will treat as number and it will truncate all leading zeros and all trailing zeros after ' . ' . So what you have to do is to convert that data into a format which EXCEL can treat as text.   1. In the rtf template, add two spaces before the column. 2. Use the following xml tag <fo:bidi-override direction=”ltr” unicode-bidi=”bidi-override”> <?format-number:INVOICE_NUMBER;’09999999′?> </fo:bidi-override>”   3. Instead of the using the tag < ? INVOICE_NUMBER? > use  =”<?INVOICE_NUMBER?>”.  Excel treat value as character and doesn’t trim the leading zeors of value....
2 comments
Read more