Reset ORACLE_HOME in Windows

From command prompt: echo %ORACLE_HOME%
This should return %ORACLE_HOME%, meaning it's just echoing what you typed in and there is not set value for ORACLE_HOME. If there is a value for ORACLE_HOME, then: setx ORACLE_HOME ""
That will set ORACLE_HOME to nothing. Remember you need to close the command prompt and open a new one to have it read the change you just made.

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [

sqlplus
/ as sysdba
shutdown abort
startup mount;
recover database;
alter database open;
connect scott/tiger

Getting mailer service available in the instance

SELECT b.component_name,
       c.parameter_name,
       a.parameter_value
FROM fnd_svc_comp_param_vals a,
     fnd_svc_components b,
     fnd_svc_comp_params_b c
WHERE b.component_id = a.component_id
     AND b.component_type = c.component_type
     AND c.parameter_id = a.parameter_id
     AND c.encrypted_flag = 'N'
     AND b.component_name like '%Mailer%'
     AND c.parameter_name in ('OUTBOUND_SERVER', 'REPLYTO')
ORDER BY c.parameter_name;

select component_status
    from apps.fnd_svc_components
   where component_id =
        (select component_id
           From Apps.Fnd_Svc_Components
          where component_name = 'Workflow Notification Mailer');
         
select running_processes
    from apps.fnd_concurrent_queues
   Where Concurrent_Queue_Name = 'WFMLRSVC';



select message_type, mail_status, count(*) from wf_notifications
where status = 'OPEN'
Group By Message_Type, Mail_Status

Getting Trace File

SELECT 'Trace Name: '||dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc',
'File Name: '||execname.execution_file_name|| execname.subroutine_name
from fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog,
fnd_executables execname
where req.request_id = :Request_Id
and req.oracle_process_id=proc.spid(+)
and proc.addr = ses.paddr(+)
and dest.name='user_dump_dest'
and dbnm.name='db_name'
and req.concurrent_program_id = prog.concurrent_program_id
and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id
and prog.executable_id=execname.executable_id

Conditional Water Mark in RTF template

1. Use ifelse condition to decide.
xdoxslt:ifelse(.//CF_DUP_FLAG='Y','DUPLICATE','')
this condition specifies, if CF_DUP_FLAG is 'Y' then DUPLICATE else NULL
2. Assign to variable to wMark (this is seeded variable)
<xsl:variable name="wMark" select="xdoxslt:ifelse(.//CF_DUP_FLAG='Y','DUPLICATE','')"/>
3. Assign this variable to Water mark text field in RTF.

In Word 2007: Page Layout --> Watermark --> Custom Water Mark --> Text Watermark --> Text







Watermark Over the Text:
To get water mark over the text, follow the steps below:
1. Insert --> Header --> Edit Header
2. Select the watermark and double click. you will get word art options.
3. Use 'Bring to Front' option to get watermark on top of text.

Download sample RTF from here: Sample RTF
Reference:
http://forums.oracle.com/forums/thread.jspa?messageID=2183469

Import Sub template command

In RTF:


<?import:xdo://APPCODE.TEMPLATE_CODE.lang.TERR?>
example:
 <?import:xdo://XXR10.XXTWRAXINV_ORIGINAL.en.US?>


In  XSL file
< xsl:import href="xdo://(PRODUCT_SHORT_NAME).(SUBTEMPLATE_CODE).(LANG).(TERR)" >

One or more post-processing actions failed. Consult the OPP service log for details

check OOP file as follows: 
sysadmin -> Concurrent -> Manager -> administer -> Output Post Processor -> processes -> manager log