R12: AP/IBY: Detailed Troubleshooting Guide For AUTOSELECT Issues: When PPR Does Not Select Expected Invoices
(Doc ID 952763.1)
Last updated on JULY 25, 2024
Applies to:
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]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.2.10 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.
Purpose
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.
Scope
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!
Details
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
| Purpose |
| Scope |
| Details |
| 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? |
| References |