R11i/R12 Payables: What data does the table PO_HISTORY_VENDORS hold?

If you are on R11i or R12 check out article "What is the purpose of PO_HISTORY_VENDORS?" from My Oracle Support via note ID 2169186.1 to find out what data the table holds and how it relates to purging programs!

R12.1.3 Payables: Invoice Validation program has performance issue

For the article "R12: AP: Invoice Validation program (APPRVL): Performance Issue - Insufficient Parameters" on My Oracle Support via document ID 2138625.1 you need to read up on the attached bug as well since it appears this dynamic query is actually being designed to run for an excessive amount of time if you do not provide an invoice date range.  That means that just entering an Operating Unit parameter does not actually limit the query as much as you would think, and Oracle Development has closed the bug as "not a bug" even though it really sounds like a bug!

Weekend Learning: Enabling data encryption for Oracle Payments module in R12

If you have upgraded to R12, or have a plan to do so, make sure you read MOS document "How To Enable Oracle Payments Data Encryption Functionality" from document ID 1301337.1 to learn how to get on the middle tier, create an Oracle Wallet .p12 file, and what concurrent requests you need to be running as well depending on what profile options you choose for the encryption method.

R12.2.4 Payables: Payments form has performance issue

I have talked about XLA slowness in Payables before, but the My Oracle Support note "R12: AP: Performance Issue With Payments Form (APXPAWKB)" from article 2117534.1 has no hooks into XLA but still has a performance issue due to indexes that appear to be missing or incomplete on AP_INVOICES_ALL!

R12 Payables: JBO-25013 error is thrown when selecting supplier relationship

A few months ago there was an article I put up about several IBY tables and article "R12.1:22878464:Error JBO-25013 On Supplier When Selected The Supplier Relationship Tab" on My Oracle Support via document number 2115923.1 was just solved today but what I think is important from this is finding out a new IBY table AND another instance of something that needs to be added to your testing suites!

R12 Payables: Invoice Mass Additions Diagnostics

Make sure you have installed the diagnostic from My Oracle Support document 1162973.1 "R12.1 Mass Additions Diagnostics" so you can find out why something did not transfer from the Payables module in EBS over to the Assets module!

R12 Payables: Vendor and vendor sites can be updated post merge

The My Oracle Support article "R12: Payables: Merged Vendor and Vendor Sites can be Updated in Supplier Entry Screen" via document ID 2107797.1 talks about what happens when vendor sites can be updated after being merged and an error is thrown when trying to merge it again.  Also, I learned about the table AP_DUPLICATE_VENDORS_ALL which will let you know if a vendor has ever been merged before and with the data pattern described in the document could give you a chance to build a proactive alert!

R12.2.3 Payables: Maximum value size is violated for DFF

The issue described in MOS article "DFF Error - The Maximum Value Size For Segment Is X. Truncating Value To Xxx (R12.2)" from document ID 1960243.1 may be due to a direct upgrade from 11.5.10.2 right to 12.2.3 but I will bet it could also be seen if you upgrade from an earlier version of R12 as well!  Check out the associated bug and patch for all the details and update your testing suites accordingly!

R12.1.3 Payables: APP-SQLAP-10264 error is thrown while new operating unit is setup In Financials During Setup Of New Operating Unit [2096022.1]

Article "R12 AP: Error APP-SQLAP-10264 In Financials Options During Setup Of New Operating Unit" on My Oracle Support via document ID 2096022.1 is a good one to read about why data validation is important and how automatic numbering can trip the system up.

R12 Payables: Invoice numbers can be duplicated

Even though this main article is directed at R12.2, I know we have had this issue reported in our R12.1.3 instance AND the linked document in MOS article "R12:AP:Duplicate Invoice Numbers Got Created For Same Supplier and Site" from ID 2094877.1 is for all versions of R12 after R12.0.1 so consider yourself warned that a custom index needs to be created to prevent this from happening to you!

Payables: Reversing swept transactions or sweeping future period transactions?

As I work on the Close for Receivables tonight, the document on MOS "How do you unsweep/reverse the sweep for transactions swept by the Unaccounted Transaction Sweep Program? How do you sweep transactions entered in a future period that was mistakenly opened to a previous period?" from article ID 2094016.1 seems especially penitent!  Check this out for the answers AND participate in the Payables Community by voting on the associated Enhancement Request!

R12 Payables: Performance issue with Invoice Workbench and Validation

I often post about performance issues, and even have posted about similar issues in Payables, but tonight on MOS you should look at "REL12 AP: Performance Issue During Invoice Validation at DELETE FROM ZX_REC_NREC_DIST" from article ID 1531928.1 to add this to your testing suites!

R12.1.3 Payables: Performance issue with Period Close

MOS article ID 1408983.1 for "Performance issue with the Payables Period Close" reports that this can take up to 30-45 minutes to run due to a combination of wrong table in the query and lack of index so make sure you check the version you have of the files for this and patch if needed!

Weekend Learning: Oracle Payables - Information Center

I posted this last year in a batch of different Payables documents, but it bears reposting because it is such a great wealth of knowledge about Payables all in one spot so don't miss out on adding MOS document ID 1417598.2 to your bookmarks for the "Information Center: Oracle Payables" article!!

P.S.  I may have taken another unintended break and found out how it is easier to break a routine, than get into one, but I'm looking to start up another streak of nightly posting right NOW!  :}  Thanks for the continued viewership through this time of not so many posts, I hope to give you a lot of good information in the weeks to come so make sure you keep coming back here every day.

Payables: Transaction Objects Diagnostics Program

Have you ever been in a situation where you needed to gather more information about a problem you are having with Payables?  Then check out the My Oracle Support document "R12: How To Run The Transaction Objects Diagnostics Program in Oracle Payables?" from note ID 558196.1 in order to add this program to your toolbox when you find yourself in such a situation!

R12 Payables: Finding where "Submit Positive Pay Program Immediately" gets stored in the system

If you have ever wondered "Where Is The Information Stored When User Checks "Submit Positive Pay Program Immediately" During Running Of The Record Print Status Program." My Oracle Support tries to answer that question in article ID 2043169.1 which is actually a more complex answer than just yes or no so take a moment to learn something about this process in Payables and a bit more about tables IBY_PAYMENTS_ALL and IBY_PAY_INSTRUCTIONS_ALL!

R12 Payables: Setting up payment terms for Credit Memo

To learn a bit more about the EBS application check out My Oracle Support note "R12: How to Setup Payment Terms for Credit Memo Instead of Using Standard Invoice Payment Term?" from article ID 2035942.1 to see if this is possible and maybe even learn something about forms personalization options!

R12 Payables: Error APP-SQLAP-10065 if supplier name changes

Have you ever seen "APP-SQLAP-10065: The Supplier Name Has Changed Since Payment Creation" that is being reported via MOS document ID 2032954.1?  It looks like this is a rather benign issue, but it does help point out another way that testing suites can help out by looking at how we can change the data and see how it affects the EBS application!

R12 Payables: Invoice Approval Workflow problem

I usually advocate creating testing suites on many different aspects of the system, and one I try to touch on regularly is file/file system checks and MOS note 1989619.1 has a good article "Problem With Invoice Approval Workflow" that highlights how a possible check like this could prevent an issue before it happens!

Payables: Performance issue with purge routine

Even though you may be on R12 the article "Slow Performance When Running Payables Purge" on My Oracle Support deals with 11i, which can be found by document ID 2030741.1, and will remind you that there are purging routines for the Payables EBS module if you have not already set them up!