General Ledger - EBS (MOSC)

MOSC Banner

Need to query the GL between two accounts between min and max

Oracle Apps R12

hi,

I need to query the GL between two accounts between min and max accounts, but the data is giving wrong account numbers, for example:

0.0000.000.512010116002.0000.0000.0000 and 9.9999.999.512010116002.9999.0000.0000

its also return other accounts for example:


1.0001.000.115010106002.0001.0000.0000


I expect only the account no 512010116002 ( segment4)


I am using GL_SRS_LEDGER_FLEXFIELD flexfield.


Please guide.

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