NOT ABLE TO CREATE LEGALE ENTITY ADDRESS IN INDIA

During creation of Legal Entity Address field Territory shown in India. If we are not choose the Territory field from LOV then CITY field shown as a mandatory.
If CITY field shown as a mandatory then we are unable to create Legal Entity address.
If we choose the Territory field from LOV then CITY field shown non mandatory field.
Before that set one profile option “HZ: DQM Synchronization Method” “N”

hi

Unable to See Move Orders Created by Other Users When Search on Find Move Orders?

To implement the solution, execute the following steps to enable the INV_INVTOMAI_CREATOR function:

A. Define the INV_INVTOMAI_CREATOR function if is does not already exist:

1. Navigate: System Administrator > Application > Function
2. Enter Function Name: INV_INVTOMAI_CREATOR
3. Enter User Function Name: 'Move Orders Creator'
4. Under the Properties tab, enter Type: Subfunction
5. Enter Maintenance Mode support: None
6. Enter Context Dependence: Responsibility
7. Save

B. Assign the function to the Menu you are using:

1. Navigate System Administrator > Application > Menu
2. Query for menu 'INV_MOVE_ORDER'
3. Add a new line to the menu:
   Prompt: 'Move Order Creator'
   Function: select 'Move Orders Creator' from the LOV
   Description: 'Move Orders Creator'
4. Save

  You may need to sign out and back in for the change to take affect.

IO Load In Database

Please Visit http://www.conacent.com/?page_id=218

This query will so you the IO Load in the database.
====================================

select
sid,
username,
round(100 * total_user_io/total_io,2) tot_io_pct
from
(select
b.sid sid,
nvl(b.username,p.name) username,
sum(value) total_user_io
from
sys.v_$statname c,
sys.v_$sesstat a,
sys.v_$session b,
sys.v_$bgprocess p
where
a.statistic#=c.statistic# and
p.paddr (+) = b.paddr and
b.sid=a.sid and
c.name in ('physical reads',
'physical writes',
'physical writes direct',
'physical reads direct',
'physical writes direct (lob)',
'physical reads direct (lob)')
group by
b.sid, nvl(b.username,p.name)),
(select
sum(value) total_io
from
sys.v_$statname c,
sys.v_$sesstat a
where
a.statistic#=c.statistic# and
c.name in ('physical reads',
'physical writes',
'physical writes direct',
'physical reads direct',
'physical writes direct (lob)',
'physical reads direct (lob)'))
order by 3 desc;

Root user password is missing or forgot for LINUX

Please Visit http://www.conacent.com/?page_id=218

Step 1-Restart the System
Step 2-While System is rebooting press down arrow key. To enter to Grub.
Step 3-Press e to edit mode.
Step 4-Select the Kernel option means the second option from your menu.
Step 5-Press 'e' to enter into edit mode.
Step 6-Type 'INIT 1' at the end of the line and press enter.
Step 7-It will return to the parent menu and press 'b' to reboot the system.
Step 8-It will boot to a prompt where your can change the password of the root.
Step 9-Reboot the system using init 6.


Note:- If you want to edit some file then please run the following command before Reboot
mount -o remount,rw /

Expense Allocation based on multiple allocation codes to get allocation code wise break-ups in Item cost as well as effect in Final accounting

Prerequisites

1. Two or more expense accounts need to populate for expense allocation for Items.

2. Items need to be produced through batch on the particular period.

Step 1 First you need to set up two allocation code and two cost component class. Cost component class should have ‘Expense Allocation’ as Usage, and naming should be same as the allocation code to simplify the breakup in item cost view.

Step 2 Then you need to set up two Expense Allocation Basis (Allocation Definitions). Allocation code will be above two and Allocation Basis will be ‘fixed %’. Now you set same item or items in same organization with required percentage (in case of more than one item) for prepared Allocation definitions.

Step 3 Now need to set Expense to allocate. Prepare that twice with two allocation code and put the above populated accounts on ‘From Account’ and ‘To Account’. Balance type will be ‘Actual’.

Step 4 Run a request from OPM Financial responsibility named ‘OPM Cost Allocation Process’ with respective parameters (here in parameter, Allocation from and Allocation to will be two allocation codes)

Step 5 Now see Item Cost, two expense lines has been generated with the above cost component classes.

EFFECT IN FINAL ACCOUNTING

To have effect in accounting, in Account Derivation rule (Rule Code: ALC) put the above populated accounts in two lines (at the ‘priorities’ tab).

And in ‘Conditions’ add another line i.e. ‘Cost component class = Constant ‘above cost component classes’)

Now run the cost processes and create accounting in final mode.

NAVIGATIONS:

Cost component class: OPM Financial-Set up

Allocation code: OPM Financial-Set up-Actual costs-Expense Allocations

Allocation Basis: OPM Financial-Set up-Actual costs-Expense Allocations

Expense to Allocate: OPM Financial-Set up-Actual costs-Expense Allocations

Item Cost: OPM Financial

Account Derivation Rule: OPM Financials-Set up-Subledger Accounting Setups-Accounting Methods Builder.

How to trace user sessions from User Monitor Screen in Oracle Application (R12)and kill the session

Navigate to System Administrator-->  Security --> User --> Monitor

Note the User Name and Oracle Process ID

Now run this sql as 

&PID=Oracle Process ID

&USER_NAME=User Name

SELECT SUBSTR(d.user_name,1,30) "User Name"
             ,      a.pid
             ,      b.sid
             ,      b.serial#
             FROM   v$process a, v$session b, fnd_logins c, fnd_user d
             WHERE  a.pid = c.pid
             AND    c.pid = &PID
             AND    d.user_name = UPPER('&USER_NAME')
             AND    d.user_id = c.user_id
             AND    a.addr = b.paddr
             AND    c.end_time IS NULL

  Note the SID and SERIAL#     and pass the SID and SERIAL# in next sql within single quote.   
            
ALTER SYSTEM KILL SESSION '123, 1234';       --   <'SID, SERIAL#'>

How to know the Table name of OAF pages

Please Visit http://www.conacent.com/?page_id=218

How to know the Table name of OAF (Oracle Application Framework)

Step 1. Set the profile option "FND: Diagnostics" at UserLevel to "Yes".
Step 2. Go to the respective OAF form page.
Step 3. Click on "About this Page" link will appear on Left bottom corner of the OAF Page.
Step 4. Either View Object or Flexfield Name will contain the table name.

LogFile Location in R12

Finding Oracle Concurrent Request Log Files:
Concurrent Requests Log And Out Files
$LOG_HOME/APPL/CONC/log
$LOG_HOME/APPL/CONC/out

Mid Tier Startup Scripts Log Files
$LOG_HOME/APPL/ADMIN

Startup/Shutdown error message text files
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log



Finding Oracle Apache Log Files:
Apache Error and Access log files
$LOG_HOME/ora/10.1.3/apache

J2EE related log files
$LOG_HOME/ora/10.1.3/j2ee

OPMN related log files
$LOG_HOME/ora/10.1.3/opmn


Finding Forms & Reports Log Files:
Forms related log files
$LOG_HOME/ora/10.1.2/forms

Reports related log files
$LOG_HOME/ora/10.1.2/reports


Finding Oracle Alert Log Files:
$ORACLE_HOME/admin/$CONTEXT_NAME/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace

Finding Oracle Cloning Related Log Files:
These are pre-cloned log files in source instance
Database Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(STAGEDBTIER_MMDDHHMM.log)
Application Tier
$INST_TOP/apps/$CONTEXT_NAME/admin/log/(STAGEAPPSTIER_MMDDHHMM.log)

These are cloned log files in target instance
Database Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/APPLDBTIER_ .log
Application Tier
$INST_TOP/apps/$CONTEXT_NAME/admin/log/APPLYAPPSTIER_ .log



find *.xml -mtime +100 -print -exec rm {} \;

Note that there are spaces between rm, {}, and \;
Explanation

• The first argument is the path to the files. This can be a path, a directory, or a wildcard as in the example above. I would recommend using the full path, and make sure that you run the command without the exec rm to make sure you are getting the right results.
• The second argument, -mtime, is used to specify the number of days old that the file is. If you enter +5, it will find files older than 5 days.
•  The third argument, -print, will print the file which are been deleted.
• The fourth argument, -exec, allows you to pass in a command such as rm. The {} \; at the end is required to end the command.

How to Assign all the items from Item Master to a diffrent Organization

Prerequisite:- Organization Hierarchy need to setup

Need to run a request :- Item Organization Assignment from Inventory responsibility.
Parameter:- Source Organization as Item Master or any other organization(From where you want to assign)
Hierarchy Origin:- Destination Organization(Where you want to assign all the item)
Hierarchy:- Organization Hierarchy Name
Request Count:-1
Submit the request