Oracle Apps Tutorial: How to Automate Oracle EBS Patch Testing

On March 29, 2011, in Oracle Order Management, Oracle R12, Oracle Upgrade, Testing Oracle, by ssutphin

One of the universal facts with Oracle E-Business Suite or any other large software package is that you eventually will need to apply patches.  The Oracle E-Business Suite patches vary in size and scope.  From the small one-off patches (also called an Emergency Patch) to a large upgrade patch, you will need to determine two [...]

Tagged with:  

Oracle Apps Tutorial: How does Project Type Information flow to your Project Template and Project?

On March 25, 2011, in Oracle 11i, Oracle E-Business Suite, Oracle Projects, Oracle R12, by ssutphin

It’s helpful to understand how the information from your project type affects and controls your project.  Most of the project type information can be overwritten at either the project template level or at the project level. The Project Type form is composed of header information and ten tabs.  In the header, you will select the [...]

Oracle Apps Tutorial: How to Perform to Mass Updates on Customers and Suppliers in Oracle EBS R12

This week I was faced with the task of updating over 250 suppliers.  Back in Oracle 11i, I would breakout my DataLoad program (www.dataload.com) and create a macro.  The macro would send the keystrokes and mouse clicks to load the data into Oracle.  But now that I’m using R12, suppliers and customers are using TCA [...]

Oracle Apps Tutorial: How to Adjust Average Cost with Invoice Price Variances (IPV)

If you want to get your inventory cost, and ultimately your cost of goods, to reflect the actual cost you paid for your items, then you will want to interface the Invoice Price Variance (IPV) from Oracle Payables to Oracle Inventory/Cost Management.  The ability to perform this update of inventory cost is only for inventory [...]

Oracle Apps Tutorial: How to Calculate Sales Tax on the Cost of an Item

In certain circumstances, you will need to calculate sales tax on the cost of an item instead of the sales price. The most common example of this is when you purchase a cell phone with a service contract.  Since you are purchasing a bundled product, some states (like California) require you to charge the customer [...]

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!