Oracle Payables Overview - Functional Document

Oracle Payables Overview - Functional Document

Please find implementation steps with screnshots for Oracle Payables implementation.
You will find these notes practical and useful in you ever want to implement Oracle Payables as a functional consultant.
Please note that in R12 supplier & bank registration screens have changes, however, the overall implementation process remains largely the same. This document has been prepared with real life Payables implementation, hence is very hands-on in nature.

Use link below to download pdf
http://apps2fusion.com/training_demo/ranu/oracle-ap/
Right click on file oracle_payables.pdf and save it to your desktop.

The topics covered in this document are
Setting up Banks
Defining Internal Bank
Payables Options
Defining Payment Documents

Creating Suppliers
Overview of Suppliers
Supplier Information - Control Region
Bank Account Region
Supplier Information - Invoice Tax region
Entering Basic Supplier Site Information
Supplier Site Information - General Region
Supplier Site Information - Tax Reporting region
Supplier Reports

Invoices
Invoice Types
Assigning a Default GL Date
Entering Invoices
Batch Control Form
Invoice Structure

Demo examples
Type of Accounting Flows
Invoice Gateway
Apply & Release Holds on AP invoices
Levels of Invoice Approval

Processing Debit & Credit Memos
Clearing a Credit
Recording a Price Correction
Processing Pre-Payments

Accounting in Oracle Payables
Accounting Events :
Creating Accounting Entries :
Viewing Accounting entries
Overview of Transferring accounting to GL
Reviewing accounting Entries

Implementing Supplier Invoices
Setting Tolerance Levels for invoice Taxes
Setting up invoice payables options
Implementation considerations

Payments
Payment overview
Create a quick Check
Processing Stop Payments
Voiding Payments
Refund
Overview of Payment Batches
Overview of Electronic Payment Options
Pre-Requisites for processing electronic payments
Creating EDI payment batches

Implementing Payments
Payment Terms
Payment Formats
Define Financials Options (Required)
Define Payables Options (Required)

Quick Reference

Set as favorite

Bookmark

Email This

Comments (23)

Subscribe to this comment's feed

Not able to open the document through both the links
written by panks , June 03, 2008

Hi,
I am not able to open the document, tried with both the links given, can you please have a look at it?

Error like 402 - page not found

report abuse

vote down

vote up

Votes: +0

Thanks
written by Enric , June 03, 2008

Hi Anil / Ranu,

Thanks a lot for the such a nice document.

Regards.

report abuse

vote down

vote up

Votes: +4

...
written by Praveenkumar2 , June 03, 2008

Hi Anil,
Thanks for this informative doc. on payables. Do you have anything explaining the Suppliers in TCA model. How is this new chnage going to impact conversions from legacy to R12.

Appreciate your help.

Thanks,
Praveen

report abuse

vote down

vote up

Votes: +2

...
written by Kotha Renuka , June 03, 2008

Thanks a lot for making available such a beautiful document. Thank You very much.

report abuse

vote down

vote up

Votes: +1

GL and AR Functional Doc's
written by Shiva Prasad Bollempally , June 04, 2008

Hello Anil,
Thank you very much for sending such usefull PDF............It is really very good with alot of Stuff...
Can you please the same functional Document on GL and AR...
looking for Doc's...

Regards,
Shiva Prasad B

report abuse

vote down

vote up

Votes: +1

...
written by Anil Passi , June 04, 2008

Hi Shiva

Ranu has already published GL and AP
AR will be published today or so.

Thanks,

report abuse

vote down

vote up

Votes: +1

Excellent work
written by srinivas kiran , June 04, 2008

Hi Anil/Srivastava
I don't know how to say thanks to both of you.
The Gl and Payables docs are really awesome.
As a technical developer,I can go now as a technofunctional guy with these docs.
And one more request also,can you please provide a document similar to these for the purchasing ,if possible only,
this is just a request.

report abuse

vote down

vote up

Votes: +0

...
written by Manav , June 04, 2008

Hi Ranu:

Thank you very Much ! Awesome !!
Is it possible to have PA documentation too

Thanks
Manav

report abuse

vote down

vote up

Votes: -1

Same PO Document Required
written by Rachna Garg , June 18, 2008

Hi Anil/Ranu,

Thanks for sharing such a wonderful doc. Could you please send us the same for PO and iProcurement.

Thanks & Regards.

report abuse

vote down

vote up

Votes: -1

...
written by Manav , July 10, 2008

Hi Anil/Ranu:

Thanks very much for this document. I am facing one problem in AP. For one of the invoice which is PO matched and unpaid,unvalidated ,not accounted.
AP Invoice Distribution Reverse Button is disabled. Could please help me out on this

Waiting for your reply

Thanks
Manav

report abuse

vote down

vote up

Votes: +0

Please send PO,OM and INV Implementation setup guide
written by Kaustuv , September 11, 2008

Please send PO,OM and INV Implementation setup guide which is used in real time environment.

report abuse

vote down

vote up

Votes: +0

Payment Facilities in Oracle Apps - Payables
written by Mukunthan L , September 13, 2008

Hi Anil,

I would like to know, if there is a way to use Letter of Credits (L/Cs) in Oracle Apps? How to make oracle bend for this facility?? Please help!!!

Thanks,
Mukunthan L

report abuse

vote down

vote up

Votes: +0

Payables Hold
written by santhosh , October 15, 2008

Hi All
I am working in Oracle apps version 11.5.10.
My requirment is :

I want to create two new Custom Invoice types.
Lets take it as Invoice type 'A' and Invoice type 'B'.
I also want to create a new custom hold lets name it as 'Z'.

I need to apply 'Z' automatically only when invoices of type 'A' is created.
How can i do these settings?
Could you please let me know the navigation path for creating custom hold?
Could ayone help me in this regard?

Regards
Santhosh

report abuse

vote down

vote up

Votes: +0

oracle financials implementation documents
written by zakir khan , November 26, 2008

thanks for a very valuable document.

report abuse

vote down

vote up

Votes: +0

...
written by raj , February 06, 2009

Hello Anil ,Ranu and team,

would you please let me know - how to set up Supplier Site Information - EDI Region 1) EDI Location and 2) EDI ID number
we are on R12 (12.0.6)

Thanks,
Raj

report abuse

vote down

vote up

Votes: -1

DBA
written by sanal , February 24, 2009

How to create source in Payable manager. I am writing an interface program to upload ivoices in payables. I need to create a soruce to upload this.

report abuse

vote down

vote up

Votes: +0

Electronic Payments
written by Aijaz Alam , May 12, 2009

Hi,

We are using 11.5.9 oracle payables. we need to setup electronic payment and send to our bank for a specific supplier, how we could it configure.

Thanks
Aijaz smilies/shocked.gif

report abuse

vote down

vote up

Votes: -1

...
written by ERP support , May 12, 2009

I want to implement a transmission feature available in Banks setup and wanted to send a payment batch files using that in AP.

Does anybody who have worked on similar type of task.

1) What are the setups needs to be done?
2) What type of sample java class file needs to be write for file transmission using $AP_TOP/java/transmission/BankClassTemplate.txt.
3) Please provide me sample class file if anybody has

report abuse

vote down

vote up

Votes: +0

Supplier Bank account
written by Prasenjit , November 02, 2009

HI Anil,
I have a problem.
Suppose, a supplier has two sites. One of the site is attached to a bank account, where the onther bank account is not attached to none of the site...
So, there are two bank account. One is supplier level another is site level. Now, For a batch payment (In R12 for Payment Process Request), we have a requirement to find out the supplier associated with that batch payment alond with Supplier bank account number.

Now, for Bank account at supplier site level,its not a problem.. Problem occurs for bank account at supplier level. When an invoice is created against that supplier site which is not attached to any bank account, upon payment of that invoice, money should go to default Supplier level bank account.
But, for a bank account at supplier level the corresponding value of column supplier_site_id will be NULL in table iby_external_payees_all table. Now, how could I join an invoice which have a definite vendor_site_id to a Bank account having supplier_site_id as NULL in table iby_external_payees_all.

I am attaching my query herewith.

SELECT substr(v.NUM_1099,3, smilies/cool.gif

,
UPPER(substr(V.VENDOR_NAME,1,30)) ,
ia.INVOICE_NUM ,
TO_CHAR(ch.check_date,'YYYYMMDD') ,
LPAD(TO_CHAR(ip.AMOUNT*100),11) ,
ieb.bank_account_type ,
DECODE(ieb.bank_account_type, '1', '000', '2', '000', cbbv.branch_number),
substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_account_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) ,
' ' FLAG ,
' ' FLAG1,
DECODE(v.num_1099,'20913339','20209133394',substr(v.num_1099,1,11))
FROM
hz_party_sites hps
,apps.iby_external_payees_all iep
,apps.iby_pmt_instr_uses_all ipi
,apps.iby_ext_bank_accounts ieb
,apps.ce_bank_branches_v cbbv
,ap_invoice_payments_all ip
,ap_checks_all ch
,ap_invoices_all ia
,Po_vendors v
,po_vendor_sites_all vs
WHERE
ieb.branch_id =cbbv.branch_party_id
AND ieb.bank_id = cbbv.bank_party_id
AND ieb.ext_bank_account_id = ipi.instrument_id
AND ipi.ext_pmt_party_id = iep.ext_payee_id
AND cbbv.branch_party_id = hps.party_id (+)
--AND iep.supplier_site_id = vs.vendor_site_id
AND iep.supplier_site_id vs.vendor_site_id
AND iep.supplier_site_id IS NULL
AND iep.payee_party_id = v.party_id
AND ip.CHECK_ID = ch.CHECK_ID
AND ip.INVOICE_ID = ia.INVOICE_ID
AND ch.VENDOR_ID = v.VENDOR_ID
AND ia.VENDOR_ID = vs.VENDOR_ID
AND ia.VENDOR_SITE_ID = vs.VENDOR_SITE_ID
AND ch.AMOUNT > 0
AND ch.CHECKRUN_NAME = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_date,SYSDATE-1) AND nvl(ipi.end_date,SYSDATE+1)

report abuse

vote down

vote up

Votes: +0

...
written by Sriram N , July 06, 2011

Thq for the material this is very helpful.