General Ledger - EBS (MOSC)

MOSC Banner

Pulling Account Entry Details from GL_JE_Lines

edited Mar 18, 2014 5:41PM in General Ledger - EBS (MOSC) 2 commentsAnswered


Hello,

Note: We are using 11i

I'm trying to pull account details of journal entries entered into the GL for specific business units.  In our structure, Segment 1 in the chart of accounts is a business unit identifier.  When I searched the GL_JE_Lines table, I could not find the account (segment) numbers.  Rather, the only field that I could link between the chart of accounts and GL_JE_Lines is the 'Code_Combination_ID' field.  I can join the tables, however I was wondering if there is another table I should be searching that would already have the account (segment) numbers.  Any help is greatly appreciated.  Thanks in advance!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center