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

Answer Posted / avinash tyagi

select count(*) from hr_organization_information where
org_information1 = 'OPERATING_UNIT'

if this query retuns value 1 means Single org
or for more then one means multi org

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.

1140


Re: what are the Issue that we face in Gl,PO and AP while Supporting

1849


please explain with examples the below mentioned "Creating the end to end business scenarios and executing the scenarios to perform the regression testing".

1752


Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?

1968


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

2574






How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.

2076


We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?

1567


difference between 11i&r12

1463


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

649


Please post the setups required to approve the payable invoice in AP.

1850


What is meant RD020

487


What do you mean by controlling buyers workload?

8947


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

3417


How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?

2326


I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.

4588