Oracle Inventory --- Purchasing Category:

Oracle Inventory – Purchasing Category: Purchasing category is nothing but an Oracle Inventory category which is attached to a category set mapped to Purchasing functional area. Following setup steps need to be performed to setup a Purchasing category.

Step-1: Define "Item Category" flexfield structure

Responsibility: "Inventory Superuser" or similar
Navigate to: Setup -> Flexfields -> Key -> Segments
Query for Application "Inventory" and Flexfield Title "Item Categories".

There is already one seeded structure for the purchasing category as "PO_ITEM_CATEGORY" but if you want to define a custom one for your business please create it by entering the Structure code, title and description. Add the required category segments to the structure.

Step-2: Define Item Categories

Navigate to: Setup -> Items -> Categories -> Category Codes.
Enter the structure name and click on the "Find" button.
Define the Item category codes and description in the "Categories" form.

Step-3: Define Category Set

Navigate to: Setup -> Items -> Categories -> Category Sets
Enter the category set name, description, flex structure (the one you have setup in the Step-1), Controlled at and Default Category values.
Add the category codes defined in the previous step to the details section of the "Category Sets" form.

Step-4: Assign the category set to the functional area

Navigate to: Setup -> Items -> Categories -> Default Category Sets
Assign the category set name defined in the Step-3 to the "Purchasing" functional area.

Now the purchasing category setup is complete.

--

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