General Ledger - EBS (MOSC)

MOSC Banner

Query to find the corresponding account of a Journal Line in R12

edited Jun 10, 2016 4:05AM in General Ledger - EBS (MOSC) 2 commentsAnswered

Hi All,

We have requirement from the client where we need to display the corresponding account of a journal line in a report.

i.e. While creating a Journal, if any account is entered as debit in the journal line then we need to pick up the  credit account from the same journal line and vice versa.

Can any one share the same query to build this logic .

Please find the attached file for further explanation.

Thank you.

Best Regards,

Muzaffar

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

EBS GL Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center