General Ledger - EBS (MOSC)

MOSC Banner

Drill Down of Reversal transactions created in GL with out SLA Engine

edited Dec 15, 2016 4:00AM in General Ledger - EBS (MOSC) 2 commentsAnswered

Hi,

I am creating a custom report, which shows drill down of "Account Receivable" account at sub ledger level.

I can write a query which source "Receivables". The query displays the Customer name, Transaction no and Receipt no etc from XLA_AE_HEADERS and XLA_AE_LINES through GL_IMPORT_REFERENCES.

There are some Reversal transactions created in GL with out SLA Engine. These Reversals are not available in XLA_AE_HEADERS and XLA_AE_LINES.

How to include these transactions in the query?

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