Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Subledger query - Receivables (journal source) Receipts (Category)

Summary:I am trying to construct a query against the XLA sub-ledger tables for Receivables (source) / Receipts (category) which includes the customer site detail.



Content (required):

I am trying to construct a query against the XLA sub-ledger tables for Receivables (source) / Receipts (category) which includes the customer site detail.

I tried utilising the PARTY_SITE_ID from the table XLA_AE_LINES, but this proved to not join to sites at all. (Note party_id works fine to get me a party, but the number stored in party_site_id seems to join to ar_distributions_all third_party_sub_id - which does not help me in this respect.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!