Org ID and Set of Books ID in Oracle Finance


Kishur's Weblog

In Oracle Finance Org ID and Set of Books ID stored in two different place. You may select the below table record to find the Org ID and SOB ID.

Org ID – select * from hr_all_organization_units

Set of Books ID – select * from gl_sets_of_books

In certain situation Oracle Finance developer find difficulty to join this tables. Instead of writing a new join query you may select this ID’s from the hr_operating_units. This tables stored the Org ID and SOB ID in the same table.

View original post

About pacesettergraam

A good and realistic person

Posted on March 22, 2016, in Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: