Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Ranu Srivastava
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

×

Warning

JUser: :_load: Unable to load user with ID: 857

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

 


Comments   

-1 #1 panks 2008-06-03 03:46
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
Quote
0 #2 Enric 2008-06-03 06:43
Hi Anil / Ranu,

Thanks a lot for the such a nice document.

Rega rds.
Quote
0 #3 Praveenkumar2 2008-06-03 09:43
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.

Appreciat e your help.

Thanks,
Praveen
Quote
0 #4 Kotha Renuka 2008-06-03 12:34
Thanks a lot for making available such a beautiful document. Thank You very much.
Quote
0 #5 Shiva Prasad Bollempally 2008-06-04 00:47
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...

Regar ds,
Shiva Prasad B
Quote
0 #6 Anil Passi 2008-06-04 02:14
Hi Shiva

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

Thanks,
Quote
0 #7 srinivas kiran 2008-06-04 09:25
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 technofunctiona l 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.
Quote
0 #8 krishna.roshan 2008-06-04 20:47
Hi Ranu:

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

Thanks
Manav
Quote
0 #9 Rachna Garg 2008-06-18 07:21
Hi Anil/Ranu,

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

Thanks & Regards.
Quote
0 #10 krishna.roshan 2008-07-10 16:22
Hi Anil/Ranu:

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

Waiting for your reply

Thanks
Manav
Quote
0 #11 Kaustuv 2008-09-11 18:35
Please send PO,OM and INV Implementation setup guide which is used in real time environment.
Quote
0 #12 muneendra 2008-09-13 05:49
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
Quote
0 #13 santhosh 2008-10-15 05:05
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
Quote
+1 #14 zakir khan 2008-11-26 08:55
thanks for a very valuable document.
Quote
0 #15 raj 2009-02-06 14:24
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)

Thank s,
Raj
Quote
0 #16 sanal 2009-02-24 23:45
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.
Quote
0 #17 Aijaz Alam 2009-05-12 05:16
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.

Tha nks
Aijaz :o
Quote
0 #18 ERP support 2009-05-12 08:24
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/tr ansmission/Bank ClassTemplate.t xt.
3) Please provide me sample class file if anybody has
Quote
+1 #19 Prasenjit 2009-11-02 01:19
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_i d will be NULL in table iby_external_pa yees_all table. Now, how could I join an invoice which have a definite vendor_site_id to a Bank account having supplier_site_i d as NULL in table iby_external_pa yees_all.

I am attaching my query herewith.

SELE CT substr(v.NUM_10 99,3,8) ,
UPPER(substr(V. VENDOR_NAME,1,3 0)) ,
ia.INVOICE_NUM ,
TO_CHAR(ch.chec k_date,'YYYYMMD D') ,
LPAD(TO_CHAR(ip .AMOUNT*100),11 ) ,
ieb.bank_accoun t_type ,
DECODE(ieb.bank_accoun t_type, '1', '000', '2', '000', cbbv.branch_num ber),
substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_accoun t_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) ,
' ' FLAG ,
' ' FLAG1,
DECODE(v.num_10 99,'20913339',' 20209133394',su bstr(v.num_1099 ,1,11))
FROM
hz_party_sites hps
,apps.iby_external_pa yees_all iep
,apps.iby_pmt_i nstr_uses_all ipi
,apps.iby_ext_b ank_accounts ieb
,apps.ce_bank_b ranches_v cbbv
,ap_invoice_pay ments_all ip
,ap_checks_all ch
,ap_invoices_al l ia
,Po_vendors v
,po_vendor_site s_all vs
WHERE
ieb.branch_id =cbbv.branch_pa rty_id
AND ieb.bank_id = cbbv.bank_party _id
AND ieb.ext_bank_ac count_id = ipi.instrument_ id
AND ipi.ext_pmt_par ty_id = iep.ext_payee_i d
AND cbbv.branch_par ty_id = hps.party_id (+)
--AND iep.supplier_site_i d = vs.vendor_site_ id
AND iep.supplier_site_i d vs.vendor_site_ id
AND iep.supplier_site_i d 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_NAM E = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_d ate,SYSDATE-1) AND nvl(ipi.end_dat e,SYSDATE+1)
Quote
0 #20 Sriram N 2011-07-06 23:48
Thq for the material this is very helpful. :)
Quote
0 #21 Harshad T 2011-09-05 12:24
Hi,
Is there anything on Oracle Cash Management 11i ?

Regards,
Har shad
Quote
0 #22 shaik.bavajan 2011-09-24 11:43
i want some senarious of AP,AR
Quote
0 #23 Carlo 2011-12-21 08:48
I use Oracle Cash & Expence Management and it works fine!

Carlo
http://www.fornoamicroonde.org
Quote
0 #24 Jeevaaruna 2012-07-26 04:15
Hi

please send the Oracle payables PDF


thanks
Regar ds
Jeeva.A
Quote
0 #25 pharmaceptica 2021-06-22 15:29
cloroquine https://pharmaceptica.com/
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner