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: Anil Patil, anilrpatil, AutoCash Rule Sets, AutoLockbox, Lockbox, MICR, Oracle Applications, Oracle Financials, Receipt Class, Receipt Method, Receipt Source, Transmission Format, UMX Security Wizard | 2 Comments »
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
- Customer listing with all Sites for a specific Org
- A listing of only those Customer with whom we have had transactions in the last ‘x’ years
- A listing of all Customer Sites that do not have any Business purpose associated with it
- Customer Listing By Collector
- Customer Listing along with Profile Class names and Collector names
- 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: Anil Patil, anilrpatil, hz_cust_accounts, hz_cust_acct_sites_all, hz_cust_site_uses_all, hz_locations, hz_parties, hz_party_sites, Oracle Applications, Oracle Financials | Leave a Comment »