Oracle AP PPR Process

[@soniasharma5187]

Very helpful video. Thank you for all your efforts.

[@OracleEbizandFusionVideos]

Glad it was helpful!

[@papayyasastrychalla1872]

How much we spend in the last couple of years. This will help us to determine our active vendors that we are using currently?

[@ramuluk7126]

Thank you so much sir for your valuable vedio

[@OracleEbizandFusionVideos]

Most welcome

[@debaduttadas4690]

Thank you very much for the videos!!

[@OracleEbizandFusionVideos]

Glad you like them!

[@anooreddy4863]

Thanks a lot . All your videos are very helpful. I have a question on submitting positive pay file creation. Do we have to manually check the check box to submit positive pay file every time we run the process. Is there any way we can automate the positive pay file generation ?

[@OracleEbizandFusionVideos]

Yes, you can also schedule Positive pay program separately

[@mamtajain6057]

Could you please let me know which process calls our ACH Template to generate the e-text outbound file ? Is it 'Format Payment Instructions (with Text Output)' program?

[@hillview2005]

Great videos! Can you please adjust the volume in your next videos?

[@OracleEbizandFusionVideos]

Noted!

[@taruneetkaur6910]

Thanks for the informative video. Can you also make video for details on Payment Instruction Format and Default Payment Document details and how to create them

[@OracleEbizandFusionVideos]

sure

[@Neeru369]

Thanks for sharing this video.

[@OracleEbizandFusionVideos]

Thanks

[@ChandraShekar-yl6bl]

Thank you very much excellent video

[@OracleEbizandFusionVideos]

Thanks Chandra

[@muralisethi]

Thanks arvind for explaining PPR. Could you describe what is pay through date?

[@OracleEbizandFusionVideos]

PPR process selects all approved and unpaid invoices that have a due date on or before the Pay Through Date

[@papayyasastrychalla1872]

Arvind garu can we use supplier payment history report.

[@OracleEbizandFusionVideos]

You can, if it meets your requirements and it has all the information which you are looking for

[@phanirdg]

Worth Video

[@OracleEbizandFusionVideos]

Thanks

[@osamaahmed9585]

Thank you Can I set payment limits per month such as 1000000 per month via pppr

[@ramamohan9957]

Thanks for uploading this video. can you upload scheduled PPR and How to import suppliers header and site's information in implementaion

[@OracleEbizandFusionVideos]

In a implementation project, supplier headers and supplier sites are loaded via interface

[@onlinealways9853]

Sir, Please tell me that where we link the disbursement bank in the PPR process

[@onlinealways9853]

1. Payment instruction format= should have assigned to the bank so that can be select as in DEFAULT PAYMENT document (This is the linkage, Right sir?) 2. Sir, If we select the EFT payment method, Then how we can maintain the document number Because in NEFT/RTGS the number is generated at the run time. sir how we can trace or reconcile the disbursement of payment number.

[@OracleEbizandFusionVideos]

@@onlinealways9853 Yes, you specify Disbursement bank in PPR template and when you assign this PPR template in PPP, disbursement bank account gets defaulted to PPP

[@balurachuri700]

Please make the whole video on Payment Process Profile by explaining each and every field. Thanks in advance.

[@OracleEbizandFusionVideos]

Sure I will

[@balurachuri700]

It's a great video but if you do it with rejected invoices, it will be more helpful to understand. It looks more like a real-time issue if you present this video with errors as well.

[@OracleEbizandFusionVideos]

Noted!

[@ujwalagudla1017]

Hi sir, what is payment process profile and why do we need to create it?

[@OracleEbizandFusionVideos]

As mentioned in the video, different attributes of payment like Payment method, payment format etc... are specified in Payment Process profile (PPP) and these get defaulted to PPR

[@papayyasastrychalla1872]

If I write a query do u have any such query? Also I want to prove my query is right by reconciliation.e

[@OracleEbizandFusionVideos]

Sorry, your question is not clear... Can you rephrase your question

[@papayyasastrychalla1872]

Arvind garu

[@papayyasastrychalla1872]

Arvind garu we want to provide extract of all active suppliers that are involved with us for the last 3 years and total invoice amount paid.also if they want address details. Email address we cannot do it without site correct. Is there any other report. Apart from supplier payment history report . What other ways u can do. In fusion how do u do it. We r in r12.24

[@OracleEbizandFusionVideos]

In order to get these details, probably you need to write a Custom SQL query

[@shiahaq9191]

Dear , how to handle payments to 1000s of suppliers. Like shareholders , we have to pay them dividend and number of shareholders are in 1000s. How we can handle such cases in oracle?

[@OracleEbizandFusionVideos]

Option 1:- Create a direct GL entry debiting Dividend account and crediting bank account Option 2:- Create a dummy supplier by name "Dividend" and then make a payment... Give standing instructions to Bank asking them to make payment to all concerned share holders.... It does not make sense to create all those share holders as Suppliers in AP and hence any of the above options needs to be chosen

[@papayyasastrychalla1872]

Arvind please let me know if I want report for total paid for vendors in last 3 years.

[@OracleEbizandFusionVideos]

Ping me your email id, i can send you a query which shows the details of AP suppliers along with their payments... You can tweak the query based on your requirements

[@oraclelearner5578]

Hi Sir, When we are scheduling Payment Batch in parameters we have Pay Through Date as optional parameter if we leave blank it will take all the eligible invoices for that payment batch but if we give any one date after completion of that date how it will consider as it is schedule one we don't want to keep changing Pay Through date regularly. Please help on this sir. Thanks

[@OracleEbizandFusionVideos]

When you are scheduling the Payment process request, give a date may be Sysdate and then you need to check "Increment Date Parameters" checkbox so that the Pay through date will be incremented automatically for every run

[@lvnareshsunrise]

Can you please explain PPR process for Fusion as well

[@OracleEbizandFusionVideos]

sure... Keep following my channel

[@rajashekar4273]

Hi sir, can you create a video on Autolock box process in AR module

[@OracleEbizandFusionVideos]

Sure

[@kishorekumar7057]

Can you please share Project costing and Billing Videos..

[@OracleEbizandFusionVideos]

I will try creating videos on Project Accounting in future

[@TAITRAN-lp1qt]

Hi, Can i ask a question about payment process? Can i impleming payment process for multiple suppliers? (1 payment for 2 invoice of tow suppliers) Thanks

[@OracleEbizandFusionVideos]

If your question is about possibility of creating a PPR for specific suppliers, then, yes, its possible to create a PPR to consider invoices of specific suppliers. You can create a separate pay group and assign the same to these supplier sites of these two suppliers. All the invoices which are created using these suppliers will get a default pay group assigned at supplier site. In PPR, you can specify this pay group as the criteria. This way, when PPR is run, system will pickup invoices of only these two suppliers

[@TAITRAN-lp1qt]

​@@OracleEbizandFusionVideos Yeah, i see. But i've ever been tested this process, so can you give me any relate video? Many Thanks!

[@OracleEbizandFusionVideos]

@@TAITRAN-lp1qt I did not get you... Did you test and were u facing any issues or else you were not able to test?

[@abhisekhnayak5780]

Dear sir, Thanks a lot for uploading such helpful videos. Could you kindly tell me, how/where to find the Payment file which has been generated after the ppr process is completed?

[@OracleEbizandFusionVideos]

Do you want to know the default path where Oracle generates Payment file? In general, for most of the clients, after PPR is completed, Payment file gets pushed to Bank Portal and after someone from Client approves the same, the file will be processed by Bank

[@abhisekhnayak5780]

@@OracleEbizandFusionVideos yes sir, I want to know the default path where the payment file generated? We have client requirement that we have to add the OU name in front of the payment file .

[@NeerajPalDiaries]

Aur please make a video on journal approval process

[@OracleEbizandFusionVideos]

Sure. Stay tuned to my channel and i will try to create one and let you know

[@OracleEbizandFusionVideos]

Hi Neeraj, based on your request, i had created the below video:- kzbin.info/www/bejne/pZLFnI1pfJedjMU

[@mallimalli2156]

What does meaning of payment format step, , why use that step?..

[@OracleEbizandFusionVideos]

Payment format is the format in which you want the file (in the case of Electronic payment) to be generated or the format in which you want your check to be printed (in the case of Check payments)

[@ramamohan9957]

can u upload implementation process video.

[@OracleEbizandFusionVideos]

Ping me on my facebook page and i can help you with that facebook.com/CAArvindVaraganti/