Oracle Aps Technical

Issue: "The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. -------------------------------------------------------------------------------- An invalid character was found in text content. Error processing resource 'http://4i.test.com:8000/OA_CGI/FNDWRR..." In the source code of the XML (View > Source) for the Arabic characters you found the following junk characters : "<FILE_DATA>¿¿¿ ¿¿ ¿¿ ¿¿ ¿¿ ¿¿¿¿¿·¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿¿¿ ¿¿¿¿ ¿¿¿¿ ¿¿¿¿¿ ¿¿¿¿ </FILE_DATA>" which can not be interpreted by XML parser. Solution: The issue will be resolved with the following settings: 1. Uncheck the "Allow Native Client Encoding" from the System Administrator > Install > Viewer Options  for the XML text/xml mime type 2. Set the profile option  "FND:Native Client Encoding" to WE8MSWIN1252. 3. Change the prolog value to <?xml ...

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   ...

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....

There are two options for adding translated templates to your report definition: ·          Create a separate RTF template that is translated (a localized template) ·          Generate an XLIFF file from the original template (at runtime the original template is applied for the layout and the XLIFF file is applied for the translation) Use the first option if the translated template requires a different layout from the original template. XLIFF (XML Localisation Interchange File Format) is an XML - based format created to standardize the way localizable data are passed between tools during a localization process. Generate an XLIFF file from the original template (at runtime the original template is applied for the layout and the XLIFF file is applied for the translation) Each <source> element contains a translatable string from the template in the source language of the...