Oracle Apps Tutorial: How to Create a Form Personalization that will Only Fire When the Field was Originally Null or Blank

On May 10, 2014, in Oracle E-Business Suite, by ssutphin

A client came to me with a requirement to only fire a personalization when the user was entering the project end date for the first time. This personalization would need to check to see if the user entered project end date was in the future and was it on the last day of the fiscal […]


Oracle Apps Tutorial: Using Application Diagnostics to Resolve Supplier Invoice Account Generator Errors

On April 24, 2014, in Oracle E-Business Suite, Oracle Payables, Oracle Projects, Workflow, by ssutphin

When you enter a project-related invoices into the Accounts Payable module, you must populate the POET (Project, Expenditure Organization, Expenditure Type, Task) information on the invoice line or invoice distribution. This information is passed into the account generator workflow to determine the accounting string. If the Account Generator returns an invalid accounting string, the you […]


Oracle Apps Tutorial: Finding Information in Oracle EBS – Oracle Java Form Query Tricks and Tips

On March 6, 2014, in Oracle Basics, Oracle E-Business Suite, by ssutphin

In any information system, there are four basic functions we perform on data. We create data, retrieve data, update data, and delete data. For 3 out of the 4 functions require you to first retrieve data. In this post, I’ll give you some tips and tricks on how to retrieve data in the Oracle Java […]


Oracle Apps Tutorial: Using Oracle GRC Module to Submit Concurrent Programs in Multiple Operating Units

The more operating units you have the more problems with running and scheduling all the concurrent programs. This is because most programs developed in 11i are operating unit based. Some concurrent programs designed with R12 in mind allow you to run for all operating units at once. Using Oracle Governance, Risk, and Compliance (GRC), you […]


Oracle Apps Tutorial: Summary of Changes in R12.2

Summary of R12.2 Changes So we looked at each product family and R12.2 is definite first a technology stack upgrade then it is a functional upgrade. To see how R12.2 is different from R12.1, you should read Oracle’s Steven Chan’s blog post ( Here is a summary of the number of changes per product family […]


Oracle Apps Tutorial: Changes in R12.2 for CRM Suite

For the final product family in my series of blog posts on the changes from R12.1.13 to R12.2, I look at the changes to the CRM suite. The changes from R12.1.3 to R12.2 were minimal. The affected modules are Incentive Comp (1 change), Incentive Comp Analytics (4 changes), iStore (2 changes), Quoting (3 changes), and […]


Oracle Apps Tutorial: Changes in R12.2 for Procurement Suite

Like Supply Chain Management and more specifically the Order Management module, the Procurement development team took the opportunity to include quite a few changes in R12.2. There are changes in the iProcurement, iSupplier, Procurement Contracts, Purchasing, Sourcing and Spend Classification modules. Let’s start with the core of the Procurement suite – the Purchasing module. R12.2 […]


Oracle Apps Tutorial: Changes in R12.2 for Value Chain Planning

Like the other product families, Value Chain Planning did not have a lot of changes from 12.3.1 to 12.2. The R12.2 changes affected only the Advanced Planning Command Center (APCC), Advanced Supply Chain Planning (ASCP), Demantra, Rapid Planning, and Strategic Network Optimization products. R12.2 Oracle Advanced Planning Command Center (APCC) Changes Oracle Advanced Planning Command […]


Oracle Apps Tutorial: Changes in R12.2 for Supply Chain Management (Part 2)

The Order Management team at Oracle took advantage of this release to incorporate 13 enhancements. The most exciting (maybe, for those of you who are implementing Order Management) is the use of User Defined Attributes on the order header and order lines. Other enhancements include: Assemble-To-Order (ATO) Items in Pick-To-Order (PTO) Models and Kits Order […]


Oracle Apps Tutorial: Changes in R12.2 for Supply Chain Management (Part 1)

Unlike the other product families (Financials, Projects, HR), Supply Chain Management has been busy with enhancements in the R12.2 release.  Because Order Management has a lot of changes, I’m dividing my discussion into two posts.  This first post will cover the changes to Advance Pricing, Electronic Kanban (new product), Inventory, Sales Contracts, and Service Contracts.  […]


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!