how to find out one organization using multi-org or single org?

Answer Posted / mstapps

Go to sql*plus and connected to apps user and

sql> select multi_org_flag from fnd_product_group;

If the value is 'y' then organazations using multi org
If the value is 'N' then org using single org

thanx
mst

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi I'm new in ERP - Oracle Application i appriciate if any one help me in this issue i need SQL to get badeget balance Acutal Balance Encumbrance Balance fund Avalable thanx ahmed

1895


what is the meaning of purchase default and what are the types

1908


I am created credit memo in at but while trying to complete it showing error message-hz_party_location

1210


What is the entry in oracle apps ap,ar,gl for following transations1.one pipe purchase at rs.1002.one pipe sales at rs.150

1362


What is gap analysis, how do you defined?

849


how to do customization while doing oracle implementation. what is the role of functional consultant in customization?

2439


Give examples & explain the below mentioned activity. "Analyzing the documents provided by the client and thereby identifying the test cases to be tested for the application assigned (FA, AP and GL)"

2026


1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?

3616


Difference between header level tax calculation and line level tax calculation

3307


How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?

1633


HI, once we create the standard invoice then we can get journal entry item expense a/c-dr to liability a.c then item it will reflect through inventory, but liability a/c . it will reflect from GL , it is possible .

1736


What is the use of gl set of books name, while configure multiorg?

866


What kind of necessary ap information you gather from the client?

880


What is the db number of a particular customer TCA?

1143


What is the use of hr: user type, while configure multiorg?

897