Receivables - EBS (MOSC)

MOSC Banner

Line ID for Cash Application

Trying to build a query that shows cash application by revenue account. I need the line ID or dist line ID since we have more than one line on an invoice. I see an APPLIED_CUSTOMER_TRX_LINE_ID field in the ar_receivable_applications_all table, which would be PERFECT, but it's not populated.

Anyone know why that field isn't populated? Has anyone found a method to link the transaction lines to the application lines (other than by dollar amount)?

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