Q
Problem solve Get help with specific problems with your technologies, process and projects.

Account queries in Oracle AR Receivables

We need to generate the below three queries to develop a marketing campaign. All these queries are based on Oracle AR Receivables.

This is in regards to account queries in Oracle AR Receivables. We need to generate the below three queries to develop a marketing campaign. All these queries are based on Oracle AR Receivables.
  1. Amount overdue at bill-to at bill-to level is greater than on-account (on-account credit + on account cash) at the bill-to level.
  2. Amount overdue at bill-to at bill-to level is equal to on-account (on-account credit + on account cash) at the bill-to level.
  3. There is no amount overdue at bill-to level is equal and on-account (on-account credit + on account cash) is more than 0 at the bill-to level.

Any advice would be helpful.

Hi,

ar_invoice_commitment_info_v will give you commitment balances for deposits. This is a view, so you will need to source your environment to view the data. ar_payment_schedules_all will give you the due amounts.

What you are asking for sounds rather complex for a single query and possibly slow for a set of views. In the past when I needed to generate custom dunning letters and reports of this nature, I would create a package that contained a series of functions, then write a query to call the functions. You will find this approach easier to tune, maintain and add future reporting requirements to.

Enjoy,
Russell

Dig Deeper on Oracle E-Business Suite

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close