Materialized View Job SCHEDULER

During cutover activity there should not be any Materialized View Job in running state to avoid the delay. Below are the scripts to check the running MV’s and to stop the Jobs. Please note Materialized View Job name will start with MV. 1. SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS; 2. BEGIN DBMS_SCHEDULER.STOP_JOB(job_name => 'MV_RF$J_0_S_116418', force => true); END; /

DB trigger Submit request mandatory initialization set_mode

retval boolean; req_id number begin retval := fnd_request.set_mode(db_trigger=>TRUE); --then call below req_id:=fnd_request.submit_request(....); end; --It can be use as without pragma autonomous and without commit

PLSQL debug seeded global variables for PLSQL unit and PLSQL Line Number

$$plsql_unit --package_name $$plsql_line

Correct way to read day from date in oracle

(TRIM ( TO_CHAR (p_date_end, 'DAY', 'NLS_DATE_LANGUAGE=English')) NOT IN ('FRIDAY', 'SATURDAY'))

query to get BI discoverer reports assigned to a user in R12

/* query to get BI discoverer reports assigned to a user in R12*/ SELECT distinct doc_name, folder_name, qs_doc_owner, owner_full_name, owner_email, report_user_name, report_user_email/*, MAX (qs_created_date)*//*,qs_created_by,user_id*/ FROM (SELECT doc.doc_name, obj.obj_name folder_name, bas.ba_name, qpp.qs_doc_owner, fu.description report_user_name, fu.email_address report_user_email, fu.user_name, /*MAX (qpp.qs_created_date) qs_created_date,*/ fu.end_date, (SELECT email_address FROM apps.fnd_user WHERE user_name = qpp.qs_doc_owner) owner_full_name, (SELECT description FROM apps.fnd_user WHERE user_name = qpp.qs_doc_owner) owner_email,qpp.qs_created_by,fu.user_id FROM eul4_us.eul5_documents doc, eul4_us.eul5_elem_xrefs xref, eul4_us.eul5_expressions EXP, eul4_us.eul5_objs obj, eul4_us.eul5_ba_obj_links bol, eul4_us.eul5_bas bas, eul4_us.eul5_qpp_stats qpp, apps.fnd_user fu WHERE xref.ex_from_id = doc.doc_id AND xref.ex_to_id = EXP.exp_id AND obj.obj_id = EXP.it_obj_id AND bol.bol_obj_id = obj.obj_id AND bas.ba_id = bol.bol_ba_id AND doc.doc_name = qpp.qs_doc_name AND TRUNC (SUBSTR (qpp.qs_created_by, 2)) * 1 = fu.user_id AND (upper(fu.email_address) like upper('%Pius.Piyush%%') OR qpp.qs_doc_owner like '%18032%' ) /*AND bas.ba_name NOT IN ('Purchasing', 'Items', 'Work In Process', 'Order Entry and Shipping', 'Cost Management', 'Planning') AND bas.ba_name NOT LIKE 'Bills%Of%'*/ GROUP BY doc.doc_name, obj.obj_name, bas.ba_name, qpp.qs_doc_owner, fu.user_name, fu.end_date, fu.description, fu.email_address,qpp.qs_created_by,fu.user_id) GROUP BY doc_name, folder_name, qs_doc_owner, report_user_name, report_user_email, owner_full_name, owner_email,qs_created_by,user_id

jpx import command in oaf in linux For VO extension

jpx import command in oaf in linux For VO extension java oracle.jrad.tools.xml.importer.JPXImporter $JAVA_TOP/xxeaa/xxVoExtnsnAppraisal0.jpx -username apps -password appspswd -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 10.999.51.999)(PORT=4444))(CONNECT_DATA=(SID=TSMOKE)))" ================== java oracle.jrad.tools.xml.importer.JPXImporter $JAVA_TOP/xxeaa/xxVoExtnsnAppraisal0.jpx -username apps -password appspswd -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 10.999.51.999)(PORT=4444))(CONNECT_DATA=(SID=STMOKE)))" Imported document : /oracle/apps/per/selfservice/appraisals/server/customizations/site/0/AppraisalVO Import completed successfully []$

RDF Paper Layout output showing different language(Greek) than required American English

Way-1 The charset property against the field was getting set to an erroneous value, it should have been 31, but was getting set to 371. Unfortunately you can’t see charset directly in Oracle Reports. The solution was to change the report to a REX format using rwcon60 alter the charset property of the offending fields and then convert it back to an RDF. I have searched on My Oracle Support but can’t find the article again (and Oracle blew away most of my favourites when we went across to MOS L. ). If it’s any help here’s the UNIX script we developed to fix the rdf our server. All references to ppsnli you will need change to your server. You need to put the file name as a parameter to the script name. e.g. if you save the script as FIXRDF run it as FIXRDF ================================================================================================================================================= #!/bin/sh ORACLE_HOME=/ppsnli/product/806 . $ORACLE_HOME/PPSNLI_auohspsnl08.env LD_LIBRARY_PATH=$ORACLE_HOME/jre11813/lib/i686/native_threads:$ORACLE_HOME/lib:$LD_LIBRARY_PATH REPORTS60_TMP=/tmp rwcon60 batch=yes stype=rdffile source=$1.rdf dtype=rexfile dest=$1.rex overwrite=yes rm -f dummy2.rex sed -e ‘s/CHARSET = 0/CHARSET = 31/’ -e ‘s/CHARSET = 781/CHARSET = 31/’ -e ‘s/CHARSET = 178/CHARSET = 31/’ -e ‘s/CHARSET = 871/CHARSET = 31/’ < $1.rex > dummy2.rex rwcon60 batch=yes overwrite=yes stype=rexfile source=dummy2.rex dtype=rdffile dest=$1.rdf rm dummy2.rex ================================================================================================================================================ Run the shell script by below command on linux ./FIXRDF.sh $MCLCUS_TOP/reports/US/MCCOSDMINV Run the shell script by below command on solaris sh FIXRDF.sh $MCLCUS_TOP/reports/US/MCCOSDMINV =======================Solari============Version================================================================================================ #!/bin/sh ORACLE_HOME=/oraapp/EBSSMOKE/apps/apps_st/appl . $ORACLE_HOME/APPSEBSSMOKE_ebststcm02.env # LD_LIBRARY_PATH=$ORACLE_HOME/jre11813/lib/i686/native_threads:$ORACLE_HOME/lib:$LD_LIBRARY_PATH REPORTS60_TMP=/tmp rwconverter batch=yes stype=rdffile source=$1.rdf dtype=rexfile dest=$1.rex overwrite=yes rm -f dummy2.rex sed -e 's/CHARSET = 0/CHARSET = 31/' -e 's/CHARSET = 781/CHARSET = 31/' -e 's/CHARSET = 178/CHARSET = 31/' -e 's/CHARSET = 871/CHARSET = 31/' < $1.rex > dummy2.rex rwconverter batch=yes overwrite=yes stype=rexfile source=dummy2.rex dtype=rdffile dest=$1.rdf rm dummy2.rex ============================================================================================================================================== Way-2 Certain fonts chosen in Report Builder on Windows have no mapping in UNIX and end up being set to 'Symbol' for whatever reason. Point in case is Fixedsys on Windows which maps to 'Symbol' on UNIX. The quick fix is to add the following section into uifont.ali file located: $ORACLE_HOME/guicommon/tk/admin/uifont.ali # Added PDF section below to cater for symbol fonts [ PDF ] Symbol = Arial This will ensure that any time a font is not mapped to anything in UNIX it will at least generate a legible font (Arial or whatever you choose). Note, only one mapping assignment should be declared. Ref: Symbol Characters ("Greek") Instead Of Expected Characters Are Displayed in Reports or Reports Parameter Form ( Doc ID 300416.1 ) PDF Concurrent Output Displays Unexpected Font After Upgrade To R12 from 11i ( Doc ID 1321874.1 ) ========================================================================================================================================