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