Unix Command to send mail with attachment

$ echo "something"|mailx -s "subject" recipient@somewhere.com

WITH ATTACHMENT
--------------------------

$ uuencode   |mailx -s "subject" recipient@somewhere.com

Oracle Apps -Concurrent program schedule details

https://forums.oracle.com/forums/thread.jspa?messageID=6500691&tstart=0#6500691

SQL Queries for checking Profile Option Values

SELECT

substr(pro1.user_profile_option_name,1,35) Profile,

decode(pov.level_id,

10001,'Site',

10002,'Application',

10003,'Resp',

10004,'User') Option_Level,

decode(pov.level_id,

10001,'Site',

10002,appl.application_short_name,

10003,resp.responsibility_name,

10004,u.user_name) Level_Value,

nvl(pov.profile_option_value,'Is Null') Profile_option_Value

FROM

fnd_profile_option_values pov,

fnd_responsibility_tl resp,

fnd_application appl,

fnd_user u,

fnd_profile_options pro,

fnd_profile_options_tl pro1

WHERE

pro1.user_profile_option_name like ('%Ledger%')

and pro.profile_option_name = pro1.profile_option_name

and pro.profile_option_id = pov.profile_option_id

and resp.responsibility_name like '%General%Ledger%' /* comment this line if you need to check profiles for all responsibilities */

and pov.level_value = resp.responsibility_id (+)

and pov.level_value = appl.application_id (+)

and pov.level_value = u.user_id (+)

order by 1,2;

Function is not available for this responsibility.Contact your system Administrator or change the responsibility

Function is not available for this responsibility.Contact your system Administrator or change the responsibility


Solution:
======


Put entry of the custom top in the default.env file under $INST_TOP/ora/10.1.2/forms/server.

eg:XXXX_TOP=$APPL_TOP/xxxx/12.0.0 (better write full path of $APPL_TOP insted of writing $APPL_TOP)

Program - Publish FSG Report custom template will not show after R12 upgrade from 11i

Solution:The data definition in 11i is FSG Program and where as in R12.1.3 it is FSGXML Program.Please change all your custom template definition to New R12 data definition FSGXML Programs.

Record has been updated. Requery block to see change

"Record has been updated. Requery block to see change" error while trying to process MTI records from front end.

Reason:There could be possiblity of trailing and leading spaces in the field values...
Eg.Transaction_SOurce_name field has value of ' TEST' after removing the Trailing spaces in the field 'TEST'.The records are processing without any issues.

SQL to find special character records in a table

select city from hz_locations where regexp_like(city,chr(15712189));