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!

EBS: Removing username and password hint

Not only do you learn something about how to "Remove/Change User Name/Password Hint" for the Oracle EBS from My Oracle Support document ID 1585864.1 but the article also has another link for personalizing the login page for R12!

Personalizing the R12 login page

Were you aware that there is a profile option value you can change in order to personalize the login page for R12?  Read MOS document "How To Remove Links From R12.X Login Page?" from note ID 1939787.1 for the details on what profile option value it is, what it needs to be, and what the page looks like when it gets updated.

Weekend Learning: Procurement Personalization Index

If you have dealt with the EBS application for a while, you know that there are several different ways of creating personalizations in the application and what can be personalized is different in each module that you work in.  The My Oracle Support document rather simply named "Procurement Personalization Index" in note 1553987.1 has a plethora of information related directly to Procurement but also a lot of general information that will be interesting to you if this is something you always wanted to know about.

R12: Personalizations

Around two years ago we started attacking our long running SQL statements, and one of those was a blind query possible within the EBS forms on the AP_INVOICES_ALL table.  Our developers placed a personalization on the form so any user interactions with it required query criteria to be present before the query would actually try to run, so the full table scan possibility was completely avoided.  Imagine my surprise today when I went into that same form, tried to have it run the blind query, and then had my EBS application freeze up while it was waiting for the results of the query.  If we had our connection information correct, I might have been able to find my session which I needed to do because it wasn't showing on our long running alert and that is my next mystery after I find out why our personalizations might be missing in R12.  Yet another tip that needs to go on the R12 installation checklist!