The Oracle calendar creation form exists throughout the system: General Ledger, Receivables, Purchasing, OPM, etc., all have at least one calendar form. And of course, with different Oracle development teams creating these forms, they can and often do function in entirely different ways.
One example: unlike the GL calendar, the OPM Financial Calendar new creation line starts at the end of all the months previously created. The form does not auto-query, and does not take the cursor to the next new row. As a result, our client, who was very familiar with the General Ledger version of the calendar form, unknowingly created an issue with the OPM calendar.
The user did not query the existing periods in the calendar to start with, or go to the end of the list of existing periods, therefore the period was created with a range of 01-JAN-2005 through 31-JAN-2016. You might think this isn’t necessarily a big deal, but for processing, it’s huge. Oracle not only validates the records in the date range, it also validates all ranges of the calendar. Even though the test records were all prior to 01-JAN-2016, it didn’t matter. We could not execute any jobs because of “duplicate date range”. The 01-JAN-2005-start date included every record ever created.
It’s been three months since I joined OnPlan Consulting as director of Business Development, and I think it’s safe to say my feet are wet! It’s not every day that a you find yourself with a company whose organizational values line up with your own, and who approaches clients with the same loyalty and dedication that you do. I’ve spent over a decade in corporate business development, and my biggest struggle in prior positions was the conflict between my role in being an advocate for my client, and the internal belief that the bottom line always comes first. That model (though I understand why it’s necessary) has never been a good personal fit for me, because I believe my role is to always be on the “side” of my client, to put them first and insure they are getting what they expected. It’s a tough line to walk in many organizations and can make the sales role a very difficult one.
OnPlan Consulting started the New Year right, helping a preeminent metals solution company in Oregon with CRP1 of an R12.2 upgrade from 11i. CRP0 (as it was called) had been around for months but had only been partially tested; having users working in a new architecture with limited outside assistance had resulted in a slow start. But the second week of January, it was all hands on deck to test the upgrade.
