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