Oracle Blogs

Use This XDOFX function in Loyout template to solve the Issue <?xdofx:replace(replace(field_name, CHR(13), ' '), CHR(10), ' ')?> example : <?xdofx:replace(replace(po_description , CHR(13), ' '), CHR(10), ' ')?>

-- APPS SCHEMA --DROP PACKAGE get_pwd; only use if some different object exist with same CREATE OR REPLACE PACKAGE get_pwd AUTHID CURRENT_USER IS FUNCTION decrypt(key IN VARCHAR2, value IN VARCHAR2 ) return VARCHAR2; end get_pwd; / CREATE OR REPLACE PACKAGE BODY get_pwd AS FUNCTION decrypt_java(key IN VARCHAR2, value IN VARCHAR2 ) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt (java.lang.String,java.lang.String) return java.lang.String'; FUNCTION decrypt(key IN VARCHAR2, value IN VARCHAR2 ) return VARCHAR2 AS BEGIN IF user = 'APPSVIEWER' -- Schema from where password should not be shown THEN RETURN NULL; ELSE RETURN (decrypt_java(KEY,VALUE)); END IF; END; END get_pwd; / --GET username...

  AIM customer transaction Creation  Inbound Using OIC deployment Instructions   Integration Required Files Link Author: MD Abdul Rehman Creation Date: JUNE 05, 2025 Last Updated: Version: 1.0 Title, Subject, Last Updated Date, Reference Number , and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents.  When you change any of these values, be careful not to accidentally delete the bookmark.  You can make bookmarks visible by selecting Tools->Options…View and checking the Bookmarks option in the Show region. Approvals: <Approver 1> <Approver 2> To add additional approval lines, press [Tab] from the last cell in the table above. Copy Number _____ You can delete any elements of this cover page that you do not need for your document.  For example, Copy Number is only required if this is a controlled document and you need to track each copy that you distribute. Document Con...