Lease and Finance Management - EBS (MOSC)

MOSC Banner

Develop a report issue, extract data from OKL and AR using AR invoice number

edited May 21, 2019 6:44PM in Lease and Finance Management - EBS (MOSC) 8 commentsAnswered ✓

I’m developing a report to get all contracts (Booked and terminated), rents (From OKL Streams) with its due dates. And the associated AR invoices with its status if it have a remaining amounts.

My issue here I can’t find an invoice number or ID any OKL Stream table to have a connection between OKL and AR Invoices by invoice ID or Number. Now i can connect the OKL with AR by the Rent date and the associated AR invoice date but this is not accurate.

Can you please help me, which OKL table i can get an Invoice Id or Number to connect it with AR invoice number from AR tables?

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