Skip to main content

Dynamic Number Format in BI Publisher




Requirement:
Display different locale number format in same report.
For Example I need to display a Price column in different number format. For English it should display 1,234.00, for German 1.234,56 and for Italian it should display 1'234.56

Solution:
English:
<?xdoxslt:xdo_format_number_l(PRICE,’999G999D99’,'EN-us')?>

German:
<?xdoxslt:xdo_format_number_l(PRICE,’999G999D99’,'DE-de')?>

Italian:
<?xdoxslt:xdo_format_number_l(PRICE,’999G999D99’,'IT-ch')?>

Output:



Comments

Post a Comment

Popular posts from this blog

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

Uninvoiced Receipts Query Oracle r12

Uninvoiced Receipts: SELECT   pha.segment1 po_number,          TO_CHAR (pha.creation_date, 'DD-MON-RRRR') po_date,          (SELECT   vendor_name             FROM   ap_suppliers ap            WHERE   ap.vendor_id = pha.vendor_id)             supplier_name,          pla.quantity,          pla.unit_price,          pla.quantity * pla.unit_price AS line_amount,          (SELECT   concatenated_segments             FROM   gl_code_combinations_kfv gcc            WHERE   gcc.code_combination_id = pda.code_combination_id)             charge_account,          rsh...
Post a Comment
Read more