Anil R Patil's Oracle Applications Blog

An Oracle Applications Knowledge Repository and Solution Center

Archive for November, 2009

How to Implement Oracle Receivables Lockbox Functionality

Posted by anilrpatil on November 28, 2009

The following document gives you a step by step guide for implementing Oracle Receivables Lockbox functionality.

Click here to download the document

[Keywords: AutoLockbox, Lockbox, Receipt Class, Receipt Method, Receipt Source, UMX Security Wizard, Transmission Format, AutoCash Rule Sets, MICR]

Posted in Receivables | Tagged: , , , , , , , , , , , , | 7 Comments »

Code Snippets: Various Queries on Customer Data (HZ Tables)

Posted by anilrpatil on November 18, 2009

There have been many instances where I have been asked by the Business Users to provide Customer Listing reports based on different parameters. The different requests typically are as follows

  1. Customer listing with all Sites for a specific Org
  2. A listing of only those Customer with whom we have had transactions in the last ‘x’ years
  3. A listing of all Customer Sites that do not have any Business purpose associated with it
  4. Customer Listing By Collector
  5. Customer Listing along with Profile Class names and Collector names
  6. And so on …

We have the Standard Customer Listing Reports in the application. However these reports are not org stripped because the HZ_CUST_ACCOUNTS data is not org stripped plus the standard reports could not be used for all different flavors of the Business requests. In these cases, I used the following queries

Click here to read the queries

[Keywords: hz_parties, hz_cust_accounts, hz_cust_site_uses_all, hz_party_sites, hz_cust_acct_sites_all, hz_locations]

Posted in Receivables | Tagged: , , , , , , , , , | 1 Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 37 other followers