Receivables - EBS (MOSC)

MOSC Banner

AR Transactions from SLA

edited Mar 28, 2018 10:14PM in Receivables - EBS (MOSC) 2 commentsAnswered ✓

Hi,

I am trying to derive the list of AR Transactions accounted by either "Create Accounting" or "Submit Accounting"Process.

From the Workflow Business Events, I am able to derive the Accounting Batch ID.

Is there a way to derive the list of AR Transactions using this Accounting batch id?

I see that it is a column in the XLA_AE_HEADERS_ALL table..

How do I drill down to get the customer trx id?

I wrote a query as below...

SELECT *

  FROM XLA.XLA_TRANSACTION_ENTITIES xte

  WHERE 1=1

  AND xte.application_id  =222

  --AND xte.entity_code     = 'TRANSACTIONS'

  AND xte.entity_id IN ( SELECT entity_id

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