Wednesday 11 March 2020

Remove Large Spaces in Report Output :

We can find Long spaces in Invoice Description/Note To Vendor Etc. For avoiding column alignment in report we can remove spaces.

Example:




Solution :

Formula : regexp_replace(i.description,'[[:space:]]+',chr(32));

No comments:

Post a Comment

Calling Different Language Layout Based On Conditions :

API For Calling Layout : 1.fnd_request.add_layout CREATE OR REPLACE procedure APPSLSPO_Calling_Templates1(ERRBUFF OUT VARCHAR,RETCODE O...