Tuesday, November 21, 2006

List of Oracle E-Business Suite's Business Service interfaces

Recently i came acrosss a very good site that provides a complete list of Oracle E-Business Suite's Business Service interfaces. This site provides the standard APIs for all the Apps modules like Payables, Receivables, GL, iExpense, HR Suite, Projects Suite, Property Manager, SCM, Advanced Planning, etc.

Wednesday, November 15, 2006

Exploring Oracle Self Billing (Payment on Receipt)

Last couple of weeks (and also weekends) have been quite hectic for me. Seems i have been clocking over 12 hrs a day, whew!!... Luckily, i have being doing some good work apart from the usual routine. One of them is testing the Oracle's Self Billing for our project. Self Billing is also known as Evaluated Receipt Settlement (ERS) or Payment on Receipt.
When Self Billing is enabled for a particular Supplier Site, standard invoices get created automatically for payment whenever the goods are received. One can automatically create invoices with multiple items and distribution lines that includes tax. We can select Payment method, "Pay On"as follows:
'Receipt'- used for material that is not consigned.
'Receipt and Use'- for material that can be either consigned or non-consigned material.
'Use'- employed for consigned material.One can assign 'Alternate Pay Site' in case we need to pay in that site an not the default supplier site. The supplier site is the default pay site. Invoices can be summarised based on the selection made in 'Invoice Summary Level'. Invoice summary level can be at:'Pay Site' - one invoice is created per supplier pay site.'Packing Slip' - one invoice is created per packing slip per supplier pay site.'Receipt' - one invoice is created per receipt per supplier pay site.
Also, enable the 'Create Debit Memo From RTS Transaction' option if you want the system to automatically create a debit memo in Payables when you enter a Return To Supplier (RTS) in Purchasing. The value for supplier defaults from the Purchasing Options window.
However, the invoice summary levels are dependent on the 'Pay On' method selected earlier. If 'Receipt and Use' has been selected, the invoice summary level available is 'Pay Site'. If 'Use' has been selected, the invoice summary level options are 'Packing Slip', and 'Pay Site'.The Invoice number that gets created is of the format "ERS-X-Seq#", where "ERS" defaults from the Profile Options "PO: ERS Invoice Number Prefix" which is by default set as "ERS" at Site level. X depends on the summary level:- if summary level = Pay Site then X = Invoice Date- if summary level = Packing Slip then X = Packing Slip Number- if summary level = Receipt then X = Receipt NumberAnd, Seq# is a unique system generated number.
Once Receiving is done, Run the Program 'Pay On Receipt AutoInvoice' individually or schedule it to run at discrete intervals.
(1) Choose Transaction Source as 'ERS'.
(2) Enter a Commit Interval. The Commit Interval is a numeric representation of the number of invoices evaluated before they are committed. For example, if you have a Commit Interval of 10, after 10 invoices have been processed, they are committed. If you then process another 5, and the process fails, only 5 will not be committed.
(3) Optionally enter a Receipt Number.
Note: If the Receipt Number is null, the program will try to process all the receipts that have not been invoiced successfully. If you enter a Receipt Number, only that receipt will be processed.
(4) Optionally enter an Aging Period.The Aging Period defaults from the PO: ERS Aging Period profile option, but you can change it here. For example, an Aging Period of 2 means that Payment on Receipt processes only those receipts that are 2 or more days old.
(5) Choose OK and then Submit Request to begin the process.
(6) Once the 'Pay On Receipt AutoInvoice' program is submitted the 'Payables Open Interface Import' program also starts running. Ensure that the 'Pay On Receipt AutoInvoice' process and the Payables Open Interface Import process complete successfully. View Output to check the 'Payables Open Interface Audit Report'. Check if there are any invoices rejected in the section 'Payables Open Interface Rejections Report' and accordingly one can go to the Payables Open Interface window and modify the invoice line / distribution and resubmit the Payables Open Interface Import process.

Reference:
(1) Oracle Applications Online Help
(2) Oracle Payables user Guide
(3) Oracle Purchasing user Guide

About Me

My photo
India
Krishanu's Oracle Applications Blog - Oracle Apps consulting services scenario in India. Also, an inside view of Oracle Apps outsource services in India. Also the blog features new developments in Oracle Apps and my learning's in this field. The views expressed are my own only and not of my employer Wipro Technologies. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine.