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 Mande...

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...

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...

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...

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, ...

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...

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...

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...

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...

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>...

Read More»