Paper Proposals Selected for OAUG Collaborate 2016

Taming Oracle EBS R12.x Accrual Reconciliation Load

Following our EBS R12.1.3 upgrade, we experienced inconsistent runtime and resource utilization with the Accrual Reconciliation Load program. During one month end close, a plant accountant could run accrual reconciliation for three years of data in under 10 hours. The next month, the same amount of data would take upwards of 30 hours to load. This behavior made it hard to plan for month end closure; successful accrual load being crucial to the finals for the month. Through multiple rounds of testing, we were able to complete the reconciliation process with nearly 15 years of data in just 1 hour and 45 minutes.

OAUG Pro Tips: Take Five – Performance Tuning During EBS 11i to 12.1.3 Upgrade

In addition to my upcoming article in the Winter issue of OAUG Insights magazine, I’m proud to share my OAUG Pro Tips video on memory tuning, currently available on the OAUG website.

Discussing the necessity for memory management and tuning for Oracle systems.

Finalist for the 2016 Oracle Excellence Award for Data Management Innovation!

Our team was nominated for the 2016 Oracle Excellence Award: Oracle Cloud Platform Innovation in both Data Management and Integration. Today, I received an update stating that we’re in the top 6 finalists out of a field of a few hundred nominees for Data Management Innovation.

“Congratulations! On behalf of our awards committee, I am pleased to inform you that Simmons has been selected as a Finalist for the 2016 Oracle Excellence Award for Data Management Innovation!   The Award Ceremony will take place at Oracle Open World on Tuesday, September 20, from 4:00-6:00 p.m. at which time Simmons will be presented with the Award.”

Continue reading

Regenerate Secure DBC file in Oracle EBS R12, R12.x

Most blog posts that I’ve seen have the directory listed incorrectly. As you’ll see in the following example, you will need to venture down $INST_TOP and not $COMMON_TOP to locate  This instance was recently upgraded from to 12.1.3

Continue reading