Saturday, June 13, 2009

R12 Mutli Org and MOAC

What is Multi-Org:
--------------------
•Multi-Org is a server-side (applications and database) enhancement that enables single installation of Oracle Applications.
•Multi-Org keeps transaction data and some setup data separate and secure by different lines of business.

Business needs:
-----------------
The Multi-Org enhancement provides features that enable you to:
•Support multiple business units even if they use different ledgers
•Secure access to data on a single instance by line of business
•Define different organizational models
•Sell and ship from different legal entities
•Procure and receive from different legal entities
•Produce reports across entities or within a single entity



Types of Organizations supported in Multi-Org Model:
---------------------------------------------------------
Business Group :
- HR

Leger:
- GL, FA

GRE/Legal Entity:

Operating Unit:
- AR, OM, AP, PO etc

Inventory Oranziation:
- INV, MFG Ship

Naming Considerations:
------------------------
Ledger:
Ledger_ ; COB_, ROB_, BG_, HR_, LE_, OU_,

Inventory Organization:
IO_

Organziation:
GM_


Mutlti-Org Access Control (MOAC):
------------------------------------------
User Access to Multiple operating units is called Multi-Org Access Control.

Multi-Org Access Control enables companies that have implemented a shared services operating model to efficiently process business transactions by allowing them to access, process, and report on data for an unlimited number of operating units within a single applications responsibility. This increases the productivity of shared service centers, as users no longer have to switch responsibilities when processing transactions for multiple operating units at a time. Data security and access privileges are still maintained using security profiles that now support a list of operating units.

•Access one or more operating units using single responsibility.
•Enhanced reporting capability using:
–Reporting level parameter
–Reporting context

Benefits:
----------
Using MOAC, a user can perform tasks for multiple operating units (OU) without changing their responsibilities.

Tasks users can perform using MOAC in multiple OUs:
•Enter Payables Invoices
•View Consolidated Requisitions
•Perform Collections
•Process Receiving and Drop Shipments
•Customer Data Management
•Accounting Setup

MOAC Setups and Process:
-----------------------------
Setup:
1. Define Operating Unit
2. Create Security Profile
3. Run Security List Maintenance
4. Setup Profile Options.

Process:
1. Login and select a responsibility
2. Launch a Form
3. Application Checks Users Access Privileges
4. Process data for Operating Unit.


Leveraging Multi-Org Access Control feature:

Accounting Setup Manager :
Create ledgers and operating units through the Accounting Setup Manager.

Payables:
Reduce processing time with the ability to enter invoices for multiple operating units without switching responsibilities. Reduce processing cost with the ability to pay invoices for multiple operating units in a single pay run.

Receivables:
Provide global information for decision making purposes with new cross organization reports

Purchasing:
Ability to negotiate discounts armed with consolidated requisition demands

Collections:
Global collections agency with consolidated view of customer accounts and collection tasks for multiple operating units

R12.1.x Features and New Modules in R12.1.x

New Modules in R12.1.x
===================
-Oracle Landed Cost Management
-Oracle Site Hub
-Oracle Price Protection
-Oracle Manufacturing Operations Center
-Oracle Supplier Ship and Debit
-Oracle Advanced Planning Command Center
-Oracle Demand Signal Repository
-Oracle Manufacturing Operations Center
-Oracle Service Parts Planning.

Oracle Landed Cost Managment:
=========================
Oracle’s Landed Cost Management application is a new product released on EBS R.12.1.Landed Cost Management enables organizations to gain insight into all of the “real”costs associated with acquiring products including broker, terminal, insurance, and transportation fees as well as duties and taxes. These costs are initially estimated andupdated with actual amounts as they become known allocating them to shipments,orders, and products. Cost methods and inventory valuations are accurately maintained providing better visibility into an individual product’s profitability and an organization’soutstanding exposure. This data provides better insight for product forecasting andbudgeting and provides clear evidence of the detailed accumulation of expenses for regulatory requirements and reporting. Oracle Landed Cost Management (LCM) gives organizations financial visibility into their extended supply chain costs, including transportation and handling fees, insurance, duties, and taxes. Since these types of charges can compose a significant portion (upwards of 40%) of an items' cost, it is important to accurately incorporate them into overall financial processes and decision making activities. Oracle LCM initially estimates these costs and later updates them with actual amounts as they become known, allocating them to shipments, orders, and products. This allows companies to maximize profits, improve visibility into outstanding liabilities, enhance competitiveness, and ensure that complex trade activities are compliant with regulatory mandates

Oracle Site Hub:
=============
Oracle Site Hub is a location mastering solution that enables organizations to centralize site and location specific information from heterogeneous systems, creating a single view of site information that can be leveraged across all functional departments and analytical systems. Oracle Site Hub helps organizations eliminate the problem of distributed, fragmented, incomplete and inconsistent site data resulting from isolated silos of data, lack of centralized data repository, rapid business expansion or mergers and acquisitions. Oracle Site Hub is an enterprise site lifecycle management solution that enablescustomers to consolidate all site-specific information from heterogeneous systems,creating a single source of truth of site information that can be leveraged across allfunctional departments. Oracle Site Hub leverages web services and integration withother Oracle E-Business Suite applications to provide a holistic data hub for site data.



Oracle Site Hub delivers:
--------------------------
1.A prebuilt extensible data model for mastering site information both internal and external such as competitor, supplier, customer sites
2.A single enterprisewide 360-degree view of the sites
3.Unlimited number of predefined and user-defined attributes for consolidating site-specific information
4.Mass maintenance capabilities to manage updates to multiple sites
5.Site mapping and view using Google Maps®
6.Prebuilt integration with Oracle Inventory, Oracle Property Manager, and Oracle Enterprise Asset Management to manage site-specific inventory, property lease, and assets
7.Web services to consolidate and share site data across disparate systems and processes

R12 Oracle Application Footprint

Release 12 is defined as “The Global Business Release.” Global is
not just a geographic perspective, but also a comprehensive
perspective; release 12 functionality spans across both industries
and business functions.

R12 Foot Print:
============






Key Business Flows :
---------------------
Oracle business flows are a collection of application components

designed for end-to-end business processes. They identify the
critical business processes an organization utilizes to support a
complete business strategy for managing operations, customers,
suppliers, partners, and employees.


Oracle business flows map business processes across multiple
organizations and many applications to represent a streamlined,
efficiently integrated information flow throughout business
organizations and across geographies.



R12 Architecture:
----------------------
Business Architecture: The R12 EBS has 5 principles that drives its business architecture:
-Modern Foundation
-Complete
-End to end Intergration
-Global
-Rapid Implementation.

1. Oracle has embedded all of its new R12 development into open,
scalable standards. These standards include using Java/J2EE,
HTML, JavaScript (JSP), Internet-accessibility, and centralized
management.

2. R12 E-Business Suite is accessible via global networks. It
accommodates multiple languages and currencies; supports
international features, such as flexible date formats and multiple
radix support; supports data in the Unicode Character Set (UTF-8)
and has accounting and business localizations built into it.

Technical Architecture:
PHP (Personal Home Page) or Portal becomes the gateway through
which the user has rights to access all the information to which they
have been granted access. Thus, R12 administrative tasks are
simplified while operations costs are reduced.

- Form based: Forms-based users are typically people involved
in the transactional operations of an organization.
- HTML/JSP's (Self Service): Self-service users are infrequent
users who want their interface with R12 to be as simple and as quick
as possible.
- Business Intelligence: Business intelligence users are senior
executives and managers who want an easy-to-use interface that
can be used to reveal critical business information and reports.
- Mobile: users whose jobs are likely to keep them away from a
readily available, network-connected computer. example : sales
representatives, field representative. By utilizing the mobile
interface, they are able to send and receive information at points
where it is important and convenient for them.

Saturday, May 30, 2009

AutoLockbox:

Overview of AutoLockbox:
•Process where customers mail payments to a post office box near
your remittance bank and the bank deposits the payments in your
account at regular intervals.
•Bank provides you with computer files detailing about the receipts
and their application. •Receivables uses Auto Lockbox to import
details about receipts directly into the system.
What is AutoLockbox:
Auto Lockbox is a service that commercial banks offer corporate
customers to enable them to outsource their accounts receivable
payment processing. Auto Lockbox eliminates manual data entry
by automatically processing receipts that are sent directly to
your bank.

Benefits of AutoLockbox:
•Eliminates manual data entry.
•Streamlines the application of receipts to outstanding transactions.
•Effectively manages cash flow by reducing turnover for converting
checks into cash.
•Apply receipts to outstanding invoices
•Import historical receipt data
•Autolockbox reports, such as the Post Quikcash Execution Report,
are a good tool to reconcile autolockbox receipts with the bank
transmission reports.




AutoLockbox is 3 Step Process:

1. Import :During this step, Lockbox reads and formats the data from
your bank file into interface table AR_PAYMENTS_INTERFACE_ALL
using a SQL *Loader.

•Data is imported into interface tables •Imported data does not affect accounts receivables balances
•Import automatically generates the Lockbox Execution Import report
•Use report to check the imported data

2.Validation: The validation program checks data in this
interface table for compatibility with Receivables. Once validated,
the data is transferred into QuickCash tables
(AR_INTERIM_CASH_RECEIPTS_ALL and
AR_INTERIM_CASH_RCPT_LINES_ALL) .
At this point, you can optionally query your receipts in the QuickCash
window and change how they will be applied before submitting the
final step, Post QuickCash script.
•Ensures that each receipt complies with application and customer
requirements
•Customer must have a primary billing location
•Bank can provide a MICR or a customer number to identify customer
•Validated data is transferred to QuickCash tables
•Transfer does not affect accounts receivables amounts
•Receivables can use AutoAssociate or a billing address to identify customer
•Use the Lockbox Execution Import report to review the validation

3.Post QuickCash: This step applies the receipts and updates your
customer’s balances.
•Data is transferred from QuickCash tables to Receivables tables
•Posting updates the account balances to reflect the imported receipts
•View and update receipts in the Receipts window


These steps can be submitted individually or at the same time from the submit Lockbox Processing window. After you run Post QuickCash, Receivables treats the receipts like any other receipts, you can reverse and reapply them and apply any unapplied, unidentified, or on-account
amounts.
MICR Number:
What is a MICR Number:
–Magnetic Ink Character Recognition (MICR)
MICR # Consists of two segments
1st segment - Transit Routing Number (Customer’s Bank) this
identifies the bank from which your customer draws their check.
2nd Segment - Bank Account of the customer (Customer’s Account)
MICR Number Can Only Be Used For One Customer Only!
MICR Number is used to identify the Customer.
The bank account number and the transit routing number makeup
your customer’s MICR number. If a MICR number is shared with
more than one customer, the receipt is rejected.Customers that are
associated must have unique MICR numbers.
By default the lockbox validation program uses an invoice or debit
memo number to determine the customer.

How AutoLockbox Identifies Customers for Receipts:

AutoLockbox can validate your customer data based on the
following attributes . If no match is found, the receipt is imported
as Unidentified receipt. This unidentified receipts can be identified
and then applied from the Quick cash window or the receipt window.

1. Customer Number: If you provide a customer number for
receipts that you import through AutoLockbox, Receivables can
identify the customer to which the receipt belongs .
2. MICR Number: The MICR number that appears on each
receipt relates the customer to a bank. Lockbox only uses MICR
numbers to associate a customer with a receipt if both of the
following are true:
a). The customer number is not included in the transmission
format
b). The MICR number is passed
3. AutoAssociate: If the customer cannot be identified from either
the MICR number or the customer number (for example, if the
transmission does not include this information), you can use
AutoAssociate to determine the customer using matching numbers.
A matching number can be a transaction number, consolidated
billing invoice number, sales order number, purchase order number
or another custom defined number.
4. Associate Receipts with Billing Locations: Receivables also lets
you track receipts for each of your customer’s billing locations.
To use this feature, you must include a billing location in your
transmission format, data file and the flag Require Billing Location
should be set to Yes. This option should be set to yes both at system
options and at the setup of Lockbox. If the box is checked at the
Lockbox, the receipt will be validated only if the billing location is
provided. The setting at the system options level determines
whether Post QuickCash can process receipts with /without billing
locations.

How AutoLockbox Applies Receipts:
If Lockbox is able to identify the customer for a receipt and the
transaction number is provided , Lockbox applies the receipt to this
transaction.
If the transaction number is not provided and Auto associate is
set to Yes, Post QuickCash uses the matching rules defined for the
customer site, customer or Lockbox to apply the receipt.
The setting of Match Receipts By Option tells what type of matching
number is passed in the transmission. If Matching Rules fail, Post
QuickCash applies the receipt using the AutoCash rules set .
If AutoCash rules also fail, Lockbox assigns the receipt a status
of Unapplied. If the transaction number is not provided and Auto
associate is set to No, Post QuickCash assigns the receipt a status
of Unapplied.

AutoLockbox Receipts Matching:
Receivables applies the receipt using:
•Transaction number
•Sales order number
•Purchase order number
•Consolidated bill number
•User-defined number

Maintain Transmission Data:
Use the Lockbox Transmission Data window to delete and edit
transmission data imported into Receivables from your bank
using Lockbox.
You can correct your lockbox data in this window for receipts that fail
validation, then resubmit the validation step again .

Running AutoLockbox:

To Import and apply receipts using AutoLockbox, run each step individually or run them as a group.
Import:
a) If you are importing a new bank file, check the New Transmission check box, then enter a new Transmission Name.
b) If you are resubmitting an existing lockbox transmission, you can select a name from the list of values.
c) Enter the name of the datafile along with path and extension.
d) Enter the name of the control file with out extension. Make sure that
the control file in $AR_TOP/bin directory.
e) Select the transmission Format from list of values.

Validation:

a) Check the Submit Validation Check box.
b) You must enter a lockbox number if Submit Validation is Yes and
the lockbox number is not specified in your bank file.
c) To apply receipts to transactions belonging to unrelated customers,
check the Allow Payment of Unrelated Invoices check box.
d) If you defined your GL Date as ’Constant Date’ in the Lockboxes
window, you must enter a GL Date; if you specified a GL Date of
’Deposit Date’ or ’Import Date’, Receivables uses this as the GL date.
e) Enter a Report Format. Enter ’All’ to include all records processed
in this transmission. Enter ’Rejects Only’ to include only records
that failed validation.
f) To transfer only the lockbox batches in which all records pass the
validation step to the QuickCash tables, check the Complete Batches
Only check box. If you do not check this check box, Receivables will
transfer any receipts within a batch that pass validation, even if
others are rejected.

Post Quick Cash:

a) To apply the receipts and update your Customer’s balances, check
Submit post QuickCash check box.
b)Choose how lockbox should handle invalid transaction numbers.
c) Post Partial Amounts as Unapplied or Reject Entire Receipt

Save your work. Receivables displays the Request ID of your
concurrent process and generates the Lockbox Execution report.

Saturday, May 23, 2009

VSOE and Revenue Recognition

What is Vendor specific objective evidence(VSOE)
==========================================
Vendor Specific Objective Evidence, is Fair Value for Software.
SOP 97-2 was designed for Software companies, and works fairly
well for certain traditional business models.
The concept was introduced in 1997 by the AICPA in their Statement
of Position (SOP) 97-2: It governs how any company that licenses,
sells, leases or otherwise markets software (unless it’s incidental to
the product or service as a whole) must recognize the revenue.

In particular, it governs how companies must recognize revenue from
so-called “multiple-element arrangements” – bundles of software and
related products or services sold as a unit at a single price.

Today, more and more companies find themselves dealing with
VSOE as embedded software becomes an increasingly essential
element in traditionally non-software sectors - consider cell
phones, medical devices, computer networks, even cars with GPS
services, etc.

According to SOP 97-2: you allocate relatively, splitting the fee
amongst the products and related elements based upon VSOE –
which is the price established by the vendor for the separate sale
of each element. Each VSOE price is usually established through
accumulation of a quantity of discrete sales “sufficient” to prove
that the market, in it’s willingness to pay that price, thinks the
price is fair. And here’s the big catch:

You can not recognize revenue for any element either until VSOE
exists for each and every element, or until all of the elements
have been delivered.

Sec's Statement of Postion (SOP) 97-2, Software Revenue

Recognition and SOP 98-9, Software Revenue Recognition with
respect to certain transactions, applied to all entities that license,
sell, lease or market computer software. It specifies that revenue
from an arrangement involving multiple elements should be
allocated to the various elements based on VSOE fair values to
the customer.

Sections of SOP 97-2 were amended with SOP 98-9, Software

Revenue Recognition with respect to certain transactions,
SOP 98-9 states that the residual method of revenue recognition is
required when:
1. There is vendor specfic objective evidence of the fair values of all
undelivered elements in a multiple-element arrangment that is not
accounted for using long-term contract accounting.
2. VSOE of fair value does not exist for one or more of the delivered
elements in the arrangement and 3. All Revenue recognition criteria
in SOP 97-2 other than the requirment for VSOE of the fair value of
each delivered element of the arrangement are satisfied.

Elements of VSOE:
==================

-Software Licenses
- Warranty
- Installation
- Support and professional Services
- Training
Fair Market Value (FMV):
========================

The FASB defined 'fair value' in FAS 159 as "The price that
would be received to sell an asset orpaid to transfer a liability
in an orderly transaction between market participants at the
measurement date. " The key points in this definition are
'orderly transaction' and 'market participants.' Thus fair value
can't be established by looking at an exchange of assets in a
bankruptcy or between 'related parties' as defined by the SEC.

Fair value is established by multiple, non- related market
participants in 'normal, orderly transactions. ' VSOE, on the other
hand, is fair value as established by looking at the historical
transactions of a specific vendor and does not consider what other
vendors are charging for similar products.

Revenue Recognition:

====================
Revenue recognition in today's regulatory and business

environment involves sophisticated revenue scheduling and
allocation, Vendor- specific Objective Evidence (VSOE) carve-outs
and Sarbanes-Oxley compliance. Thus having a common system
for global compliance is key to reducing complexity.
Revenue recognition is a principle prescribing that revenue is
recognized when earned.

It has two considerations - when to recognize revenue, and how
much to recognize. Revenue recognition is relevant for companies
to be able to adhere to legal compliance as per the US GAAP
requirements.

Improper revenue recognition increases the risk of financial
restatement, and financial restatements. Revenue for ISV's is
typically divided into three categories: Software, Maintenance, and
Services. Assuming that software customization is not required,
revenue can be recognized when all of the following criteria are met:

There are four basic criteria that must be met to recognize
revenue
- Evidence
- Delivery
- Fixed or determinable fee
- Collectibility.

Revenue Accounting:
===================
Use the Revenue Accounting feature to quickly and easily adjust

revenue and sales credits at the transaction or line level. You can
make manual adjustments using the Revenue Accounting and
Sales Credits window. Alternatively, use the Revenue Adjustment
API to automatically perform these adjustments. Revenue
Accounting uses the Actions Wizard to guide you through the process
of making and modifying revenue adjustments.
You can also use the wizard to record early acceptance for an

invoice line, if the line is associated with a contract that offers an
acceptance clause.

Invoicing Rules:
===============
Use Invoicing Rules to specify whether to record receivables
amounts in the first (Bill in Advance) or Last (Bill in Arrear)
Period.
Invoicing rules determine when to bill the customer in relation to
the accounting rule Periods. Accounting rules determine the

accounting periods for revenue recognition and Billing.
Two invoicing rules are available:



Bill in Advance: Use this rule to recognize receivables immediately.

Bill in Arrears: Use this rule to recognize the receivable at the end of

the revenue recognition schedule.


•Invoicing rules determine whether to recognize receivables in the first or in the last accounting period.
•Once the invoice is saved, you cannot update an invoicing rule.
•If Bill in Arrears is the invoicing rule, Oracle Receivables updates the GL Date and invoice date of the invoice to the last accounting period for the accounting rule.


Accounting Rules:
=================
Use Accounting Rules to determine when to record revenues.
Accounting Rule determine the number of periods and percentage
of total revenue to record in each accounting period.

Each invoice can have different accounting rule.
Use the Accounting, Fixed Duration type to recognize revenue evenly
over a specific number of periods. Revenue can be spread evenly or a
percentage can be specified for each period.












Variable Duration type to recognize revenue by a percentage for
the first period. The remaining revenue is spread evenly across
the number of periods you specify during transaction entry.

Accounting rules determine when to recognize revenue
amounts. Each invoice line can have different accounting rule.


Oracle Receivables uses the First GL Date field in the Transactions
window to determine when to start recognizing revenue. The number
of periods in which revenue is recognized is determined by the
value in the Number of Accounting Periods field in the Transactions
window.Value defaults from fixed ruleValue must be entered for
variable rule. Accounting distributions are created only after you run
the Revenue Recognition program.

•Accounting distributions are created only after the Revenue

Recognition program is run.
•For Bill in Advance, the offset account to accounts receivable

is Unearned Revenue.
•For Bill in Arrears, the offset account to accounts receivable i

s Unbilled Receivables.
•Accounting distributions are created for all periods when

Revenue Recognition is run.

Revenue Recognition Program Execution Report :
=======================================
Use the Revenue Recognition Execution report to review all

revenue distributions created for invoices that use invoice and
accounting rules.

This report displays the account class, GL Date, Accounting
Flex field, the currency, amount, and accounted amount for
the revenue distributions Revenue Recognition creates for
each transaction.

Receivables automatically creates the Revenue Recognition
Execution report whenever you run the Revenue Recognition
program, the Revenue Recognition Master program, or the
General Ledger Interfaceprogram.

When the Revenue Recognition program encounters transactions
with problems that prevent the creation of distributions, the
program completes with a status of Warning, and Receivables
includes these transactions at the bottom of this report.

•The Revenue Recognition program gives control over the creation
of accounting entries.
•Submit the Revenue Recognition program manually through the

Run Revenue Recognition window.
•The Revenue Recognition program will also be submitted when

posting to Oracle General Ledger.
•The program processes revenue by transaction, rather than by

accounting period.
•Only new transactions are selected each time the process is run.

Automated Revenue Recolonization Tools in the Market:
-RevPro
-RevStream
-Revenue Edge.


Monday, April 20, 2009

Oracle iReceivables

Overview of i Receivables:

Oracle iReceivables is an online invoice presentment, dispute, and payment solution that enables external and internal users to inquire about their accounts and transactions, pay invoices, and dispute invoices via a streamlined credit memo workflow and it helps you reduce the cost of billing and collections while improving overall customer service.
Oracle iReceivables gives the customers self-service access to their accounts with real-time balance and transaction information. T
he Home page gives customers quick access to their account information with drill down capability to specific details. It shows transaction balance and aging information, supports print requests, gives discount alerts, and shows credit memo status



iReceivables Features:
-Customer Search
-Accont Details
-Interactive Invoice
-Payment and Credit memo display
-Dispute a bill
-Credit Memo Workflow
-Automatic Credit memo creation.
-Credit memo Request Confirmation Page


Oracle iReceivables gives your Customers Self-Service Account Management

  • Export transaction data to spreadsheet
  • Attach documents to transactions
  • Manage Payments and Ensure Data Security
  • Duplicate dispute warning
  • One-time credit card payment
  • Configurable service charges
  • Customizable transaction search.
Simplify the Payment Processes:

  • Anonymous user login:
    The Anonymous User Login feature allows external customers to log in by only entering an account number. Therefore, customers can access their customer account data without having to register for a username and password. Companies can customize this feature to take the users directly to the page they need to access the most, for example, the Account Details page or the Home page.
    The benefits of Anonymous User Login are: 1) it removes the registration overhead for users accessing Oracle iReceivables on the one-time basis. 2)It also speeds up the log-in and navigation process for them. As a result, customers are encouraged to make online payments in a more timely manner.
  • Multi-pay and multi-print:
    -The Multi-Pay feature allows the customers to select multiple invoices and pay all of them at once using credit card or bank account transfer. With this feature, customers no longer have to navigate into each invoice and pay them one by one. Instead, they can just select all the invoices they want to pay in the Account Details page and pay them all at once.
    -The Multi-Print feature allows customers to select multiple invoices and print all of them at once. The print format is defined in Oracle Receivables, including PDF, HTML, text, XML, PostScript, etc. Once the print job is completed, the customers will receive an e-mail notification containing a link for accessing the printed documents. The link allows for one-time access only.

Why do companies want to use Oracle iReceivables?

1. To remove their paper invoices and reduce the mailing and faxing overhead for their invoices. 2. To reduce the manual payment applications and receive payments from their customers more quickly. 3. To reduce phone calls and automate their collections and customer services. 4. To be able to resolve bill disputes quickly and improve their customer satisfaction.

Oracle iReceivables supports :

  • A paperless enterprises It streamlines the dispute processes to help reduce the DSO (Days Sales Outstanding)
  • It provides customers with self-service payment options such as credit card or bank account, and payment scheduling.
  • It enables companies to collaborate with their customers through the self-service account management.
  • It automates user administration and registration and expedites online access for one-time users.

Oracle iReceivables Modules Intergration:

1. It integrates with Oracle Receivables to provide real-time transaction status and details.

2. It with Oracle Trading Community Architecture to provide real-time account access and customer information.

3. It integrates with Oracle iPayment to enable online payment application and processing.

4. It integrates with Oracle Workflow to provide automated credit memo and multi-print processing.

5. integrates with Bill Presentment Architecture, which provides customizable bill presentment templates.

6. It integrates with Oracle Application Framework to enable personalized display of account information.


  • Set the Profile option, Currency:Negative Format correctly so that negative numbers have the negative sign not brackets to facilitate exporting to Microsoft Excel.
  • Set the profile option FND:View Object Max Fetch Size, so that all transactions can be viewed on a single page rather than scrolling pages.
  • setup of External users is done by the party number assigned to a contact.
Mobile Accounts:
  • Provides anytime, anywhere access to the application via a web enabled mobile device
    Designed specifically for mobile devices
  • For internal (Management , Collection Agents and sales reps) and external users (customers)
  • Access for internal and external users can be restricted based on configurable function security Integrated with Mobile Customer Directory

Mobile Accounts provides the following information about a customer :
–Account Overview
–Credit Information
–Recent Activity
–Aging


Features:
–Robust Customer Search using Mobile Customer Directory
–Powerful Transaction Search
–Ability to drill down to the Transaction Detail
–Pay an invoice
–Configurable access control
–Efficient non-hierarchical navigational menus

setups:

1. Defind iReceivables Internal Users2

. Defind iReceivables External users and customer Access

3. Define Function Security

4. Index the Customer Database

5. Set up for Self Registraion

6. Setup for Anonymous user login

7. Define Service Charges

8. Review and update Receivables lookups

9. Set the proifle option fo agining buckets

10.Define currencies for customers and customer bill to sites.

11. Define Receipt Class and Payment methodl

12. Set receivables system option for ireceivables payments.

13. setup document sequencing for ireceivables receipts.

14. Set Profile option for ACH Bank accoun transfer payments

15. Modify the dispaly of account information

16. Set profile option for bill presentment architecuture.

17. intergra ireceivables into your business processes.

for more information pls go through the implementation guide and user guide.

Thursday, April 16, 2009

Ramification of Invoice Match to PO and Invoice Match to Receipt

Oracle Payables shares purchase order information from your purchasing system to enable online matching with invoices. Invoiced or billed items are matched to the original purchase orders to ensure that you pay only for the goods or services you ordered and/or received. If you are billed for an item over the amount and quantity tolerances you define in the Invoice Tolerance window, during Approval, Oracle Payables applies a hold to the invoice, which prevents payment.
Oracle Payables supports three levels of matching which verify that purchase order and
invoice information match within defined tolerances.

Match Approval Level: 2-Way , 3-Way, 4-Way.

In 2-way: what ever you have ordered for the PO you will make the payment for the suppliers in 2- way i.e we will compare two documents PO and Invoice.
2-way matching verifies that Purchase order and invoice information match within your tolerances:
Quantity billed <= Quantity Ordered Invoice price <= Purchase order price Eg:Suppose we Had given PO for 100 items ,for that we will receive invoice for 100 items. so that we will make payment for that 100 items.
 In 3-Way you will compare 3 documents i.e PO+receipt+Invoice.
3-way matching verifies that the receipt and invoice information match with the quantity tolerances defined:
Quantity billed <= Quantity received. Eg:Suppose we have ordered 100 items in PO. But we had received only 75 items ,But we had received invoice for 100 items. so, we will make payment for only 75 items.
 In 4-Way you will compare 4 documents i.e PO+Receipt+Invoice+Inspection.
4-way matching verifies that acceptance documents and invoice information match within the quantity tolerances defined:
Quantity billed <= Quantity accepted. Eg:Suppose we have 100 items in PO. Suppers send us 75 items We will do inspection on those items what ever we have received, If 15items got damaged. finally, we are going to make payment to the 60 items only. When you match to a purchase order, Payables automatically checks that the total of PO_DISTRIBUTIONS.QUANTITY_ORDERED = AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED (2-way matching). Payables only checks QUANTITY_RECEIVED (3-way matching) if the RECEIPT_REQUIRED_FLAG is set to Y and only checks QUANTITY_ACCEPTED (4-way matching) if the INSPECTION_REQUIRED_FLAG is set to Y.

Invoice Match Option:
The Invoice Match Option determines whether or not you intend to match invoices for this supplier against purchase orders or receipts.
Invoice Match option to PO Match:
--------------------------------------------
•Payables must match the invoice to the purchase order.
•If the Invoice is matched to a PO rather than to the Receipt when the AP team do a match they have the full PO available to match rather than just the specific lines on the PO that were received.
•There is a possibility someone in payables matching to the wrong distribution if they use Match to PO.

•The accrual is valued at the PO exchange rate date.

Invoice Match option to Receipt:
----------------------------------------------
•Payables must match the invoice to the receipt.
•Receipt Match Option is recommended if you want accounting to use exchange rate information based on the receipt date or if you want to update exchange rate information on the receipt.
•If you use the match to receipt option AP team can't match until the goods are received. If the receiving doesn't happen there is no way to associate the invoice with the PO.
•Invoice processing will be on hold till a receipt is entered into the system.
•Receipt Match option determines the cost with more accuracy i.e. Match to Material item receipt and link other invoice charges to receipt and You can now also associate freight, tax, and miscellaneous charges from invoices to the related receipt.
•Run the Matching Detail Report from Other -> Request -> Run. This report will show you detail of how an invoice, purchase order, or receipt was matched. This report is especially helpful when an invoice is on hold and you are trying determine why the hold was placed.

The Invoice Match Option defaults from the Supplier Sites window. You can change the Invoice Match Option on the shipment until you receive against the shipment.

Financial Options - Invoice Match Option:
For purchase order shipments, indicate whether you want to match invoices to purchase orders or to purchase order receipts. If the supplier was created automatically during Expense Report Import, the default value is Purchase Order, and you can change it to Receipts as appropriate.

The decision to set the Invoice match option to Receipt or Purchase Order depends on Business Needs.
•If you are using Multi Currency Functionality for Purchase Order and if like to have the rate based on Receipt date you need to go with Receipt Match at the invoice match option.
•The main advantage is the Exchange Rate factor i.e. Receipt/Current Date instead of Purchaser Order date.
•Receipt Match gives much closer control of the matching process,Particularly where you have multiple receipts of large purchase order.

If a Business is using Invoice Match option Purchase Order and like to change from Purchase Order to Receipt Match, then what would be the impact?

•All Supplier sites need to be updated with Invoice Match option to Receipt.
•Purchase orders which are already approved with Invoice Match Option of Purchase order should continue with the same existing process.
•All existing Open PO, which need a change from Purchase Order to Receipt, should be corrected by changing the invoice match option in the purchase order shipment to Receipt. Payables team should match invoices to Receipt for all Purchase Orders created after the cut-off date.
•Training to AP/PO users.

In order for the receipt to use the current exchange rate and not the PO exchange rate, the Invoice Match Option at the system level and on the suppliers should be Receipt, not Purchase Order.