Dharmesh Shah

• Nov 11th, 2005

 

HR data is at business group level.

GL Data is differentiated based on set of books id.

AP and AR data is mostly at operating unit level.

Inventory, BOM, WIP data is at inventory organizaiton level.

Srikanth

• Nov 28th, 2005

 

In the gl_sets_of_books we have the set_of_books_id column.This column is enough to differentiate between one operating unit with the other.

PRATIK GHOSHAL

• Jan 8th, 2006

 

Hi,

If you see the multiorg structure of Oracle Apps modules, we'll see that GL is setup at set of books level. Now you generally won't get data at OU level.OU data sums up at a higher SOB level.

Please follow the below structure if you want more clarification

top->bottom

HR org->SOB->OU->inventory org

parleg

• Jul 18th, 2006

 

so AR, AP etc will have different SOB?

what is operating unit?

oraconsultant

 Profile Answers by oraconsultant 

• Jul 24th, 2008

 

Hi,

As per the standard oracle functionality only one operating unit is assigned to GL responsibility. You need to create different GL responsibilities for different operationg UNits If there are multiple operating units sharing same SOB.

This appplies only to 11i release and NOT R12.

ref : Profile option : MO Operating Unit

Thanks

tonyj666

 Profile Answers by tonyj666 

• Mar 29th, 2010

 

Some background, assume Org id = Operational Unit
A GL set of Books may consist of entries from many different Org Id's.

Within the AR & AP (the sub-ledgers) the org id and set of books id are stored with the data (i.e Invoices/payments). They are derived from the profile options assigned to the Responsibilty you access AR/AP with. i.e Set of Books and MO: Org Id.

If you have ten Org Ids for a set of books it follows you will need ten AR and ten AP responsibilities to maintain each Org Id's data.

The Org id recorded with the data in the sub-ledger is not transferred to the GL when you upload to the GL - it is not in the table.

There are a number of possibilities

1) Your balancing segment (Company ?) is normally unique to an Org Id so you could derive it this way. This is not particularily future proofed unless new Balancing Segment values fall into convenient ranges that you can allow for

2) When data is transferred to the GL there is a table maintained that links the subledger journal entries to the gl transaction line entries as used by the drilldown process - you could make use this to determine the relevant Org Id

Also  I cannot remember if the Sub Ledger GL Journal name includes the Operating Unit name or Org Id  as that would be another possibility

I have used 1) in the past when asked to report GL balances/transactions relating to a specific Org Id.