Oracle Apps Technical and Oracle Fusion Technical Real Time Training

Dear  "Friend",

Thank you for showing interest in the "Oracle Apps Technical with Oracle Fusion Tools" conducted by Orafusion Technologies.

We believe that you would like to evaluate the program rigorously before joining. We are starting Regular and Corporate session on "Oracle Apps Technical with Oracle Fusion Tools "with 100% Placement Assistance. It will be held at the Orafusion Technologies centre in Hyderabad.

The details of the session are as follows

Demo Date: 6^th  May

Time: 7:00 Am – 8:30 Am

Regular Session: 8^th  May 2013.

Real Time Training: 10 ^Th   May 2013.

            Prerequisite: Graduation

          Highlights: Oracle Apps Technical with Oracle Fusion Tools Regular and Real Time Training, Experience, Interview Support, Certification & Daily Job updates till Placement & Chapter wise Presentations (PPTs) & Chapter wise Hands On (MS Word Docs) & Exams on FAQs & Job Placement mainly in USA and rest of the world.

Founded and Conducting by Real Time Faculty having Experience in a CMMI Level 5 Company, Hyderabad.

This special session will give you a chance to interact with the faculty and also experience the technology first hand.

There are limited seats (10) available for the program. If you wish to register for the session please contact on " Mob: 9502657526".

Venue: "Suit #7-1-3961 Beside Venkateshwara Swami Temple, Community Hall Road, B.K.Guda Park Lane .S.R.Nagar, Hyderabad)

Fwd: Ugadi Greetings...

To Dear & Near...

With A Hope That You Attain Success And Bliss with Every flavour On the Day Of Ugadi!

With delicious teepi, chedu, karam, pulupu & uppu ugadi pachadi....

Wishing You A Happy And Prosperous Ugadi…!

Cheers

--

Excel Output From BI Publisher or XML Publisher is Trimming Leading Zeros in Excel Template

To implement the solution, execute the following steps:

1. In the rtf template, use the "Insert -> Symbol" function to insert a very small
0xA0 (NO-BREAK SPACE) character (font size 1 or 2pt) in front of the number string field.

2. One can also try:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?format-number:INVOICE_NUMBER;'09999999'?> </fo:bidi-override>"

3. Another option:
During XML template design, Instead of the using the tag < ?TAG_NAME ? >
use  ="<?TAG_NAME?>". It wraps the value with double quotes. Now Excel treat value as character and doesn't trim the leading zeors of value.
Note: space between < and ? and tag name is not requried.

4. Retest for the issue 

For more information search in metalink [ID 417811.1]

--

How to get Trace File path in backend in oracle apps

How to get Trace File
When you enable SQL trace in a session for the first time, the Oracle server process handling that session will create a trace file in the directory on the database server designated by the user_dump_dest initialization parameter. As the server is called by the application to perform database operations, the server process will append to the trace file. 

Query:

------------

select name,value from V$PARAMETER where name = 'user_dump_dest';

--

How to find Trace File Names in Oracle apps based on request id

SELECT 'Request id: '||request_id 

,  'Trace id: '||oracle_Process_id

,  'Trace Flag: '||req.enable_trace, 

'Trace Name:  '||dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc', 

'Prog. Name: '||prog.user_concurrent_program_name, 

'File Name: '||execname.execution_file_name|| execname.subroutine_name , 

'Status : '||decode(phase_code,'R','Running')  ||'-'||decode(status_code,'R','Normal'),

'SID Serial: '||ses.sid||','|| ses.serial#,  

'Module : '||ses.module  

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 = req.request_id ---&request  

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; 

 

--

Delete Cache memory in Oracle Apps R12

Here is the Navigation for the same

1)Go to Functional Administrator
2)Click on Core Services Tab
3)Click on Caching Framework Tab
4)Within Caching framework click on Global configuration
5)Under Cache policy click on "Clear ALL Cache" Button
5) Click on Apply

Escalation Process for Oracle Premier Support

Customer Quick Reference Guide

Escalation Process for Oracle Premier

Support

Oracle resolves problems according to the priority or severity

of an issue. The ability to assess the severity of an issue and

assign a rating that drives the appropriate response is the

cornerstone of the problem resolution process. Customers

should escalate an issue when they:

• encounter a critical roadblock or showstopper to

implementation or upgrade plans

• urgently need to communicate important business

issues to managers in Oracle Support

• are dissatisfied with the resolution or response to a

Service Request

Oracle Premier Support provides 24X7 support for missioncritical

issues. Anywhere or anytime, our support specialists

around the world are available to help resolve your critical

technical issues.

Escalating an issue brings a heightened level of awareness

to management and, when appropriate, more resources. It

does not automatically change the severity rating of an issue.

Therefore, clear communication is essential to bringing about

a successful and timely resolution. If the business impact has

changed, or was incorrectly set, customers should request a

change of severity rather than escalation of the Service

Request (SR). If heightened attention is required for a

product defect, customers should request a bug escalation

through the support engineer assigned to the Service

Request.

In situations where a heightened level of support for a

Service Request is essential, Oracle has designed a phased

escalation process. This process is the same regardless of

the Oracle product family.

Initiating an Escalation

• Step 1: Start the escalation process by updating the SR.

Provide a thorough explanation about why you are escalating.

Take a moment to complete the following template and enter

it in the SR:

****************Escalation Request **************

Reason for escalation, including business impact of the

problem that requires escalation

Business or implementation milestone, critical date(s)

(milestone date or resolve by date), along with the type of

business or implementation milestone

Name of the person requesting the escalation, contact

information: phone number, pager, email address

****************Escalation Request**************

• Step 2: Call the Oracle Premier Support number and select

the menu option for an existing SR. After entering your SR

number, follow the phone menu to the option to escalate your

SR. Inform the answering support engineer that you would

like to escalate your SR and speak with an escalation

manager.

• The engineer will page the appropriate escalation manager,

who will call you within approximately 30 minutes of the

request. (It is important that you telephone us to ensure that

an escalation manager is paged. Updating the SR via the

web alone does not guarantee that you will receive a call from

the escalation manager within approximately 30 minutes.)

• The manager will work with you to create an acceptable

action plan.

• The manager will document the conversation and the action

plan in the SR.

• The manager will follow up to ensure that the action plan is

followed or reset expectations if necessary.

• The escalation manager owns the escalation until the issue

is resolved or escalated to a higher management level. If a

customer is dissatisfied with the progress made by the

escalation manager, the SR can be escalated to a Senior

Director followed by the Oracle Support Vice President, if

necessary. As issues are escalated within Oracle’s support

management, a Director or VP from your company may be

asked to be available for the discussions.

Working Effectively with Support

Severity levels describe the impact a SR has on the

customer’s business and defines the resources to be

engaged by both parties, as well as the rules of engagement

for the resolution of the SR.

• Severity 1: Problem or product defect causes complete

loss of service, regardless of the customer environment,

and/or work cannot reasonably continue.

• Severity 2: Severe loss of service; no acceptable

workaround; however, operations can continue in a

restricted fashion.

• Severity 3: Minor loss of service; impact is an

inconvenience that may require a workaround to restore

functionality.

• Severity 4: No loss of service; minor error that does not

impede operations or an enhancement request.

Oracle Premier Support Phone Numbers

Oracle...…1.800.223.1711 CRM On Demand….1.866.853.8521

On Demand Service Desk ……1.800.376.9079

Link to all Support Phone #s:

http://www.oracle.com/support/contact.html

Useful Oracle Websites

My Oracle Support (MOS):

https://support.oracle.com/

Acquired Product Support:

http://www.oracle.com/us/support/supportintegration/

index.html

Additional Resources and Documentation

For complete definitions of severity levels, download

the PDF titled Oracle’s Technical Support Policies at:

http://www.oracle.com/support/policies.html.

Link to My Oracle Support (MOS) - Escalation Process Speed

Training: Doc id=603505.1