My Oracle Support Banner

R12: AP/IBY: Detailed Troubleshooting Guide For AUTOSELECT Issues: When PPR Does Not Select Expected Invoices (Doc ID 952763.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.1 [Release 12.0 to 12.1]
Oracle Payments - Version 12.0.0 to 12.1.1 [Release 12.0 to 12.1]
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Understand how the AutoSelect program (AP_AUTOSELECT_PKG) works and what to check for when a Payment Process Request (PPR) does not select the expected Invoices.


Oracle Payables Users and those who support the application.

The EBS Payments (IBY) Funds Disbursement Analyzer (Doc ID 1587455.1) contains these checks to verify if this issue is present in your instance. Download the latest version today and get proactive!



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 How Invoices are Selected in a PPR
 1. Through the Submit Payment Process Request (PsrPG) OA Framework page
 2. As a Concurrent Request
 Determining Why an Invoice did not get Selected:
 1. The invoice should not be selected by any other PPR or netting batch
 2. The payment schedule's relevant date should be between the PPR's Pay From and Pay Through dates. The relevant date for selection can be either a discount date or the due date
 3. The payment schedule cannot be fully paid
 4. The invoice cannot be subject to forced revalidation
 5. The payment schedule's payment priority must be between the Payment Priority High and Payment Priority Low parameters designated for the PPR
 6. Cancelled invoices will not be selected
 7. There cannot be a hold on the payment schedule
 8. A supplier site level hold will prevent payment schedule selection
 9. For Payment Request invoices there must be a corresponding record in hz_party_sites
 10. Fv_econ_benf_disc.ebd_check must return Y for this invoice
 11. If the user specified an Invoice Batch Name, the invoice must be in that batch
 12. If the user specified the Payee the invoice must be from that payee
 13. If the user specified an exchange rate type, it must not conflict with the exchange rate type on the invoice
 14. If the user specified a payment method, it must match the payment method on the payment schedule
 15. If the user specified a vendor type, it must match the vendor type of the invoice's supplier
 16. If any legal entities were specified, the invoice must be in one of those legal entities
 17. If any operating units were specified, the invoice must be in one of those operating units
 18. If any currencies were specified, the invoice's payment currency must match one of them
 19. If any pay groups were specified, the invoice's pay group must match one of them
 20. For zero-amount invoices, the user must have checked the Include Zero Amount checkbox
 21. Unapproved invoices will not be selected
 24. An invoice with holds will not be selected for payment
 25. The invoice must be fully validated. A different query is executed based on whether purchase encumbrances are used for any of the included orgs
 26. Invoices without distributions will not get selected
 27. For customers using CCR (a Federal functionality) the Invoice Supplier should not be CCR Expired
 28. The check date must be in an open AP period
 29. If the allow pre-date payables option is disabled, the payment date cannot be earlier than the current date
 30. When third-party payments functionality is used the payee relationship must be active
 31. If exchange rates are mandatory or the exchange rate type is user, exchange rates must be available:
 32. If the maximize credits checkbox is not checked, credit memos will not be selected if they would cause the payment amount to be zero:
 33.  If the customer is running a Payment Process Request (payment batch) using a set of Payment Documents that has the option "Restrict Use To Manually Issued Payments" selected:
 34.  If the "Include Only Due" checkbox on the Scheduled Payments Selection Criteria tab was checked:
 35.  If the supplier's account has a credit balance:
 36. If the Supplier site is inactive the invoice won't be picked by the Payment Process Request - Autoselect program
 37. "Set Operating Unit Mode" is set to single in a MOAC environment
 Standard Patching Process
 Patch Wizard
 Have more questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.