How to determine Oracle Database And OS version

You can use following two queries to find out the Apps/Database/OS version

select * from v$version;

select * from product_component_version;

Thanks
Mandeep

Read More»

Session Timeout in Oracle Apps

This post is about how to increase your session time out for oracle application. Sometime its very annoying that session time out is set at very low value. You can increase it for your login by setting profile option "ICX: Session Timeout" from sysadmin responsibility

Please navigate to Sysadmin > Profile > System and query for "ICX: Session Timeout" after checking both at Site and User checkbox and increase the value of User.

Thanks
Mandeep

Read More»

Concurrent Program or User Priority

Sometime it happens in our support environment that end users complain about request taking time to execute or concurrent program performance is slow.

Here are two methods by which you can resolve such issues

Method 1 : Suppose a program taking time and all users complain about it. To resolve such issue you can use priority field concurrent program definition form.

The default priority of each concurrent program is 50. So if you want some program to be executed on priority then you can enter Priority (1 to 99) in concurrent program form.

Navigate to Sysadmin>Program>Concurrent>Program>Define and query for the Concurrent program

Concurrent Program Priority

Method 2: Suppose only a single user complains about that when he or she submit request it take more time.

In that case you can increase the priority of that user. Navigate to System profile options and query for "Concurrent:Request Priority" Profile option at user level.

User Priority

The default value is 50. Set this profile option between 1 to 99 based on your requirement.

Thanks
Mandeep

Read More»

How To Login in Multiple Accounts Of Same Oracle Instance Simultaneously

Sometimes you want to open multiple login of same Instance. For example suppose you are testing a PO approvals cycle. Its really frustrating to first open buyer login to create & submit PO for approval and then again logout/login with supervisor account to approve the PO.

There can be multiple thing for which you want to open multiple login accounts of same instance.

I will show you how you can achieve the same. This is valid only for internet explorer

Step 1) Navigate to Internet Explorer on Desktop

Step 2) Right Click and Select Properties.

Step 3) Select Shortcut tab and in Target add space –nomerge after iexplore.exe" as shown below

"C:\Program Files\Internet Explorer\iexplore.exe" -nomerge

Please note even with -nomerge option, you still have to open new IE8 window (not a new tab in the same browser window) to access different account.

Thanks
Mandeep

Read More»

Sql query for relation between Business Group, Legal Entity, Operating Unit and Balancing segment

select HRL.COUNTRY,
  HROUTL_BG.name BG,
  HROUTL_BG.ORGANIZATION_ID,
  LEP.LEGAL_ENTITY_ID,
  LEP.name LEGAL_ENTITY,
  HROUTL_OU.name OU_NAME,
  HROUTL_OU.ORGANIZATION_ID ORG_ID,
  HRL.LOCATION_ID,
  HRL.LOCATION_CODE,
  GLEV.FLEX_SEGMENT_VALUE
from XLE_ENTITY_PROFILES LEP,
  XLE_REGISTRATIONS REG,
  HR_LOCATIONS_ALL HRL,
  HZ_PARTIES HZP,
  FND_TERRITORIES_VL TER,
  HR_OPERATING_UNITS HRO,
  HR_ALL_ORGANIZATION_UNITS_TL HROUTL_BG,
  HR_ALL_ORGANIZATION_UNITS_TL HROUTL_OU,
  HR_ORGANIZATION_UNITS GLOPERATINGUNITSEO,
  GL_LEGAL_ENTITIES_BSVS GLEV
where LEP.TRANSACTING_ENTITY_FLAG      = 'Y'
and LEP.PARTY_ID                       = HZP.PARTY_ID
and LEP.LEGAL_ENTITY_ID                = REG.SOURCE_ID
and REG.SOURCE_TABLE                   = 'XLE_ENTITY_PROFILES'
and HRL.LOCATION_ID                    = REG.LOCATION_ID
and REG.IDENTIFYING_FLAG               = 'Y'
and TER.TERRITORY_CODE                 = HRL.COUNTRY
and LEP.LEGAL_ENTITY_ID                = HRO.DEFAULT_LEGAL_CONTEXT_ID
and GLOPERATINGUNITSEO.ORGANIZATION_ID = HRO.ORGANIZATION_ID
and HROUTL_BG.ORGANIZATION_ID          = HRO.BUSINESS_GROUP_ID
and HROUTL_OU.ORGANIZATION_ID          = HRO.ORGANIZATION_ID
and GLEV.LEGAL_ENTITY_ID               = LEP.LEGAL_ENTITY_ID;

Read More»

Multi Org Access Control (MOAC)

There is a lot of hype on MOAC. What is MOAC. MOAC stands for Multi Org Access Control. It is simply access control where user can access multiple operating units from a single responsibility. Before R12, each responsibility can have access to one operating unit. if user need to do transaction in other operating unit, he or she needs to change the responsibility and then do the transactions.

Profile options around MOAC

There are three profile options around MOAC

• MO: Security Profile
• MO: Operating Unit
• MO: Default Operating Unit

MO Security Profile : If you are using the MOAC, Assign this profile option at responsibility level. When you uses this profile option, MO: Operating Unit profile option is ignored.

MO: Operating Unit: This profile option works same as it is in 11i.

MO: Default Operating Unit: If you are using MO Security Profile and have multiple operating units then this profile option defaults a operating unit on forms. you can manually change the operating unit.

Steps Involved

1. Create Security Profile
2. Run Security List Maintenance program
3. Setup profile option MO: Security Profile
4. Setup profile option MO: Default Operating Unit

Step 1) Navigate to Global HRMS > Security>Profile

By default Oracle provides a security profile named, Setup Business Group.

# Enter a Unique name for Security Profile
# Enter a Business Group for this Security Profile. If you have multiple business Groups then you can also select Global Security Profile Form. Global security profile is not Business Group Specific.
# Select Security type you want to use. Here we want to Secure Organizations by Operating units. You can also select NO security and can view all organization or View only single operating unit
# Select the Operating Units name under this Business Group which you want to access.

Save your changes

Step 2) Run Security List Maintenance Program

Make sure request completes successfully

Step 3) Create a custom Responsibility

And assign MO: Security Profile to it

Step 4) MO: Default Operating Unit

Now assign MO: Default Operating Unit

This Complete the setup Part

Test Case

Open "Test Security Profile for Purchasing" responsibility and Open new PO Form

You can see the operating unit field is defaulted to "Singapore Distribution Center" same as in our setup

Thanks
Mandeep

------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please share this knowledge with your friends and subscribe at our blog for more updates. If you have any queries, please participate in our Forum or by leaving your comments below.
------------------------------------------------------------------------------------------------------------------------------------------------------------------

Read More»

Vacation Rules

Vacation Rules in Oracle R12

In this post we will see how to create vacation rules when you want to transfer notifications meant for you to your colleague.

The First Step is to login in Oracle and click on Notification summary

Navigate to Suppose Purchasing Super user > Notifications Summary

 Click in Vacation Rules at the bottom of the page

Select Item type for which you want to create Vacation rules. We will take "ALL" for our example. Click Next.

#Enter Start Date from which you want to transfer notifications
#Optionally enter End Date
#Optionally Enter a message which will be displayed with routed notifications.
#In Reassign, select the user name whom you want to transfer the notification
# Select "Delegate Your Response" if you want to delegate all notification approvals to an assistant.
# Select "Transfer notification ownership" if you want to transfer notifications for a specific project to the new manager of that project.

Click Apply

Table Involved : WF_ROUTING_RULES

Note: The key to setting-up a valid Vacation Rule is to ensure the rule is tied to a Username rather then the Full Name of the desired user.  The reason for this is that the Worklist and Notification Summary for the user is linked to their username and not full name record (Reference Metalink)

Suppose a person forgot to create vacation rules then in that case we can also use Management >Forward Documents  or you can reassign it using workflow monitor.

Thanks

Mandeep 

------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please share this knowledge with your friends and subscribe at our blog for more updates. If you have any queries, please participate in our Forum or by leaving your comments below.
------------------------------------------------------------------------------------------------------------------------------------------------------------------

Read More»

XXX is not a valid responsibility for the current user. Please contact your System Administrator.

How to Resolved XXX  is not a valid responsibility for the current user. Please contact your System Administrator.

Some time it happens that we assign a new web based responsibility like isupplier or iprocurement but when opening it display following screenshot.

This is happening because middle tiers has yet to pick the change in assigned responsibility. To resolve this issue we need to clear the middle tier cache.

Navigate to Functional administrator>Core Service >Caching Framework > Global Configuration

Click on Clear All Cache

A warning message will displayed. Click Yes

Confirmation will be displayed. Now if you navigate to iProcurement responsibility.

It will open without error

Thanks
Mandeep
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please share this knowledge with your friends and subscribe at our blog for more updates. If you have any queries, please participate in our Forum or by leaving your comments below.
------------------------------------------------------------------------------------------------------------------------------------------------------------------

Read More»

How to Launch Change Organization form before Running the Request/Reports

How to Launch Change Organization form before Running the Request/Reports

Sometime it happens we directly run a request going in Requests without selecting any Organization (not through View>requests but in the Menu> Request form). This request either error out or give you an error before running to select a org parameters

The issue occurs because report parameters has an organization id parameter but its not displayed and it refer PO: MFG Organization ID profile option.

Lets take an example of "Item Statuses Report" of inventory

When you try to run this report you will find that its giving an error to select a org before running it.

Now if you run same report after selecting an Org from change org form you will not get any error

This is happening because providing Organization is mandatory before running such reports. If you check concurrent program's parameter, you will find that Organization is a required parameter but its not displayed.

One solution is to make it displayed and you need to find out and perform same action for all the other similar reports.

Second solution is whenever we run the requests Change Organization form automatically displayed and ask us to select an Org.

To achieve the same, we need to assign parameter USE_ORG="Y"  to function assigned to report submission

Please follow below steps

Step 1) Navigate to sysadmin and query for the responsibility from which you are submitting the report

Note down the MENU name : INV_NAVIGATE

Step 2) Now navigate to Application>Menu and query for above Menu name

Note down the Function name : View All Concurrent Requests for Inventory

Step 3) Navigate to Application> Functions and query for above function

In the Form Tab, in Parameters add USE_ORG="Y"

Save your work

Now whenever you run the request from Inventory>Requests it will first pop up the change organization window and you will not face the problem while running the requests.

Thanks
Mandeep

Read More»

How to Assign a Concurrent Program to a Responsibility

Suppose you want to run a Program, lets take an example of  "Autoinvoice Import Program" from Order Management Super User, Vision Operations (USA)

Navigate to this responsibility > View> Requests>Submit a new request>single Request

and enter "Autoinvoice Import Program"

You will not able to find that concurrent program in the list of value as this program is not yet attached to the Request Group of the responsibility "Order Management Super User, Vision Operations (USA)".

To Achieve the same follow below steps

Step 1) Find out the request Group attached to a responsibility

Using sysadmin navigate to Security>Responsibility> Define and query for "Order Management Super User, Vision Operations (USA)"

Note the request group Name: OM Concurrent Programs

Step 2) Now Navigate to Responsibility> Request

Query for OM Concurrent Programs

Step 3) Insert a new line and add Program "Autoinvoice Import Program" in it

Save your Work

Now go to "Order Management Super User, Vision Operations (USA)" and try running Autoinvoice Import Program. You will find the request in the List of values

Thanks
Mandeep

------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please share this knowledge with your friends and subscribe at our blog for more updates. If you have any queries, please participate in our Forum or by leaving your comments below.
------------------------------------------------------------------------------------------------------------------------------------------------------------------

Read More»